Please try the software and leave your feedback, I am always looking for ways to improve it. There are also tutorials on my website's wiki.
You can download it here:
Windows: 3.2.0
MacOS (64-bit only): 3.2.0
Linux (portable version): 3.2.0
Go to http://code.google.com/p/mypersonalindex/ for more information and the source code.
--------------------------------------------------------------------------------------------------------------------------------------------------------
This refers to an old Excel workbook. I now have the program mentioned above that I am actively working on. However, this spreadsheet still functions correctly.
This Excel workbook will help you effectively track the performance of your investment portfolio. The workbook has been designed to handle all of the calculations for you and gather the data; all you need to do is provide the tickers and shares. The spreadsheet makes extensive use of behind the scenes VBA code to effectively compute a pseudo mutual fund based on personal data (using a NAV).
I began working on this idea because it became difficult to reasonably track investments with dividends, purchases, sales, splits, etc. I assume other portfolio aids like this exist, but I made this in Excel both for the level of personal control (you can do your own analysis) and the simplicity.
I welcome all comments and criticisms. This is not meant to be a end-all solution, but I feel it provides enough computation to use the data in meaningful ways.
The Google Groups page is located at http://groups.google.com/group/mypersonalindex and the file can be downloaded from:
Excel 2003 Version (Deleted)
Excel 2007 Version (Save Link As...)
Download Sample Workbook (Deleted)
Make sure to enable macros! The workbook downloads data from Yahoo! Finance. The outputs page does not show anything until after the first update of prices. I recommend you read the instructions page carefully before starting. Also, look over the sample workbook for an introduction and general overview.
I hope this helps other people,
Matt
P.S.: One thing I did not make clear is that you should not have the enter a purchase for the tracking index (the gray column on the Shares page). This should only be used if the tracking index splits, otherwise it defaults to one share.
Update 1: Fixed error displaying on invalid ticker; Added sheet to list update and modifications; Set calculation of Excel to automatic on exit.
Update 2: Added the ability for asset allocation. Tweaked code and moved some things around.
Update 3: Added the ability for a desired asset allocation so you can keep the course.
If you want to transfer over to the newest version, set the "Data start date" to the same as your old version, copy over your tickers on the Inputs sheets, and then copy over the shares on the Shares sheet. Just click Update Prices and you have an exact copy on the new version.