I use Microsoft Excel to maintain my portfolio positions in a spreadsheet. One convenient feature about using Excel is that there is a free plug-in available that allows you to download the latest stock and mutual fund quotes directly from the web into the spreadsheet. So you do not have to spend the trouble to key in the latest stock or mutual fund prices when you want to check your latest asset allocation.
The stock quote download plug-in is distributed free from the Microsoft website. You can use the following search keywords “excel stock quote download” from the Microsoft website main page to locate the files. For Excel 2002/2003, here is the link to the file.
Here is how the stock quote toolbar looks like in Excel after you install the plug-in:
To insert the latest price of a fund, for example VTSMX, enter the following into a cell:
You can also reference the name of a fund using another cell. For example if cell A1 contains VTSMX, the following will also give the latest price of the fund:
You can have multiple instances of the above code to download the prices of as many stocks or funds as needed. Once you have modified the spreadsheet with the MSNStockQuote commands, you will be able to view your latest portfolio asset allocation with the click of a button. 🙂