Importing stock quotes

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top