Tools for tracking my portfolio

A few readers have asked me which financial software I am using to track my portfolio. I will try to clarify with this post.

My portfolio is mainly tracked on a spreadsheet with Microsoft Excel. I created a spreadsheet that lists the major asset classes I have invested in and the investment vehicles in each asset class. Using an Excel macro (see my post HERE), I can update the real-time price of each fund with the click of a button. This allows me to, at a glance, view the weight of each asset class in my portfolio. I can make the decisions of where I should invest new cash and/or when I should rebalance with information from this spreadsheet.

The following is a sneak view of the current and past weights of the different asset classes in my portfolio starting from last year:

2007-11-01-portfolio-weights.PNG

(US L = U.S. LargeCap/Total Market, US S = U.S. SmallCap, US R = U.S. REITs, IN L = EAFE LargeCap, IN E = Emerging Markets, IN S = EAFE SmallCap, IN R = EAFE RealEstate (already eliminated), PME = Precious Metals and Mining equity, HC = Healthcare equity, BND = bonds and cash)

In addition, this spreadsheet is also used to generate my portfolio monthly return charts. A screen capture program is used to grab the chart from Excel as a .png file which I upload to my site.

2007-11-02-portfolio-return.PNG
Figure above created using Microsoft Excel.

For tracking transactions, I am currently using Microsoft Money. This software is used to track my investment purchases and sales, as well as my credit card and banking transactions. Microsoft Money can also generate a number of differnt charts but I am not using any of them in my monthly portfolio update posts.

Those of you who follows my portfolio updates would notice a chart showing the monthly returns of different mutual funds / ETFs. I used these as proxies for the different asset classes held in my portfolio. The chart is pretty accurate as long as there are no capital or dividend gain distributions in the month. It is generated from the MoneyCentral.com website, and the same screen capture program was used to create the picture file.

2007-11-02-portfolio-individual-returns-480×362.png
Figure above generated from MoneyCentral.com.

Leave a Comment

Your email address will not be published. Required fields are marked *

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Anti-spam image