Importing historical adjusted stock prices?

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

 

[Bucky]

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.

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.

 

[Don Guillett]

goto the yahoo group xltraders

http://groups.yahoo.com/group/xltraders/
and look for free files with my name donaldb36 as the author. It's there.

 

[Guest]

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

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