Z
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.
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.