Yahoo! Excel Portfolio Manager

This is a simple spreadsheet that allows you to pull stock quotes in from Yahoo Finance, for a range named 'tickers'. If you change the tickers, the company names and stock prices will change as well. This spreadsheet just makes it easier to track a portfolio using Excel.

Virtually all financial quotes tell you the amount that a stock has changed since the prior close. One benefit of this spreadsheet approach is that by recording your observation, you can review the change since the last time you looked at your portfolio, whether that was an hour or a week ago.

This is written in visual basic for excel, and I've left the source code open.

email: jasonchroman@y@hoo.com

Click Here to download or right click and select ‘save target as’.