Importing historical adjusted stock prices?

S

Schultz

I would like to put a list of stock ticker in excel and have excel import
not only the day's closing price for those tickers, but also the adjusted
closing price of a certain date from the past.

Does anyone know how to do this or where I could go to look for this?

Seems like a long time ago I remember a yahoo group that was involved in
this sort of thing.

Thanks.
 
B

Bucky

Schultz said:
I would like to put a list of stock ticker in excel and have excel import
not only the day's closing price for those tickers, but also the adjusted
closing price of a certain date from the past.
Click to expand...

I don't know how to do it automatically, but finance.yahoo.com has
historical adjusted prices in CSV format. That should get you started
in the right direction.
 
J

joeu2004

Bucky said:
I don't know how to do it automatically, but finance.yahoo.com
has historical adjusted prices in CSV format.
Click to expand...

Beware of using Yahoo adjusted close figures. Yahoo
incorporates dividends into the adjustment. For example,
see HPQ 21-Dec-05 and 22-Dec-05. That might be useful for
determining historical yield, but it is not appropriate (IMHO)
for determining historical price movements (historical
average and volatility).
 
Top