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