View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default How to Retrieve Historical Stock Prices?

From my file that you cited in your tirade. Yahoo CSV info on the Data page.
Date Open High Low Close Volume Adj. Close*
12/12/2005 30.00 30.12 29.72 29.97
10,127,700.00 29.97
12/9/2005 29.22 30.00 29.22 29.92
9,133,900.00 29.84


--
Don Guillett
SalesAid Software

" wrote
in message ...
"Robert K" wrote:
With user defined stock symbols and date range, go to either
MSN Money or Yahoo!Finance and retrieve historical closing
prices and populate it back in Excel.


Caveat emptor ....

Yahoo's "adjusted close" price includes an "adjustments" for
dividends. For example, see HPQ for 9-Dec-05 and 12-Dec-05.
If that satisfies your needs for your analysis of the portfolio
performance, great!

On the other hand, Yahoo's "close" price is not adjusted for
splits and other exchanges due to organizational changes (e.g,
spinoffs). And the "split" information that you see online is
not included in the CSV-formatted download data :-(.
Consequently, it is difficult to automatically compute the price
adjusted for splits and other exchanges based on Yahoo data.