Importing sotck quotes

[Z]

Hi,
I am running Excel 2007 and would like to import stock quotes to my
worksheet.


I have my stocks listed in columns:

(1) Company names and tickers
(2) Prices i bought the stocks at

In the next columns I would like:
(3) Current price (or last available price)
(4) Last days' closing price
(5) Today's movement in percent
(6) Calculation of total return/loss in percent
(7) Calculation of total return/loss

There must be some simple formulas for pulling and calculating this
data? I might have searched on the wrong terms, but googling and looking
in the Excel 2007 help did not help much

Thanks.

 

[Ch.Wolfram]

Excel 2007: I have my stocks listed in columns:
(1) Company names and tickers
(2) Prices i bought the stocks at
In the next columns I would like:
(3) Current price (or last available price)
(4) Last days' closing price
(5) Today's movement in percent
(6) Calculation of total return/loss in percent
(7) Calculation of total return/loss

Answer:
Assuming the columns are in A:A - G:G, Records startes in line 2.
Format the colums E:E and F:F as "percent value".
e.g. "0.21" will be shown as "21 %" .

Formulas (copy them down in every row)
in E2: =D2/C2-1
in F2: =C2/B2-1
in G2: =C2-B2

Yours
Christian

 

[Bernd P]

Hi,
I am running Excel 2007 and would like to import stock quotes to my
worksheet.

I have my stocks listed in columns:

(1) Company names and tickers
(2) Prices i bought the stocks at

In the next columns I would like:
(3) Current price (or last available price)
(4) Last days' closing price
(5) Today's movement in percent
(6) Calculation of total return/loss in percent
(7) Calculation of total return/loss

There must be some simple formulas for pulling and calculating this
data? I might have searched on the wrong terms, but googling and looking
in the Excel 2007 help did not help much

Thanks.

Hello,

Have a look at
www.mathfinance.cn/value-at-risk
or see my version for Excel 2007 at
http://sulprobil.com/html/value_at_risk.html
(the 331 kb Excel 2007 sample file, please read my disclaimer first!)

Regards,
Bernd

 

[Z]

Answer:

Assuming the columns are in A:A - G:G, Records startes in line 2.
Format the colums E:E and F:F as "percent value".
e.g. "0.21" will be shown as "21 %" .

Formulas (copy them down in every row)
in E2: =D2/C2-1
in F2: =C2/B2-1
in G2: =C2-B2

Thank, I am a starter so this helped as well, but I first need to get
past the problem of actually importing the quotes.

 

[Z]

Hello,

Have a look at
www.mathfinance.cn/value-at-risk
or see my version for Excel 2007 at
http://sulprobil.com/html/value_at_risk.html
(the 331 kb Excel 2007 sample file, please read my disclaimer first!)

Thank you. I came a bit closer here. I was however hoping that you could
define a single field so it says "Import current price for IBM from MSN
Money" or so. So I can make a column where I only change the ticker of
the company.

 

[Bernd P]

Thank you. I came a bit closer here. I was however hoping that you could
define a single field so it says "Import current price for IBM from MSN
Money" or so. So I can make a column where I only change the ticker of
the company.

Hello,

Have you actually opened and tried to understand these worksheets?

You DO only enter a single ticker and then the stock prices get
downloaded automatically (from yahoo).

Ha det bra,
Bernd