What is most time-efficient way to track portfolio asset allocation?
I've recently decided I wanted to track my investments over time so that I could accurately determine really cool financial things like:
My actual asset allocation
My actual rate of return over time
I had a couple goals for doing this:
If I know my CURRENT asset allocation, I can determine what steps I need to take (buy mutual fund X and sell mutual fund Y) in order to achieve my TARGET asset allocation. The importance of this can be found by googling The importance of asset allocation
I'd like to see which mutual funds are ACTUALLY giving me the highest returns. This helps me provide a feedback loop to myself to determine
The challenges in doing this:
In short, I have multiple investments. Between Roth IRA's, Rollover IRA's, 401k's, and individual stock purchases I've made, it could be a nightmare to maintain this if I didn't use a good application or spreadsheet.
I dollar cost averaged some of my investments. That means some of my investments were buying $X (e.g. 0 per month) of a stock or mutual fund. I really didn't want to manually enter trades for the following example: I made monthly purchases over 18 months (18 transactions) for 3 different mutual funds ( 54 transactions) with a fixed price of purchase but a varying number of shares purchased. This is just one example, there are many transactions like this (I invest in my 401k every month too, I'm betting you do too?)
I often reinvested dividends. Again, I really didn't want to manually enter the repurchase of dividends of some variable amount of money that bought X amount of stock every 3 months for so many different funds.
So, overall, the question is: how do I solve this complex challenges ensuring I dont enter tedious, error prone data, while saving myself the most time possible?
Note: I did find a program that I think does a great job of dealing with this situation, but I honestly would love other people's opinions on the matter to see if there are better solutions out there.
Another Note/Clarification - does anyone know how this program compares to Quicken?
(3)3 Comments
Sorted by latest first Latest Oldest Best
If you have enough assets at T Rowe Price, you get what I think is a scaled back version of the portfolio tracker for free.
I want to mention I've found 2 options for more powerful tools that can be used to manage asset allocation:
Vanguard's Portfolio Watch tool
Morningstar's Instant X-ray
Advantages/Disadvantages:
Vanguard
+ve Vanguards's tool is free with a Vanguard account, and automatically tracks your Vanguard investments.
+ve Vanguard's tool can add external accounts (e.g. if you have another 401k somewhere else, you can manually add the symbols for that tool and it breaks down those investments into their asset categories)
-ve Vanguard's tool has been criticized as being inaccurate on some forums, like The posts referenced in this Bogleheads wiki
Morningstar X-ray
+ve It is rumored to be more accurate than Vanguard's performance. See a link to it here
-ve in order to save results, you have to pay some 5/year for Morningstar's investment service.
I hope this helps others struggling with asset allocation.
I found that an application already exists which does virtually everything I want to do with a reasonable interface. Its called My Personal Index.
It has allowed me to look at my asset allocation all in one place. I'll have to enter:
Mutual fund or stock ticker
Either the number of shares purchased or the amount of $ used to purchase shares (awesome) as well as the date of the purchase. The purchase price was optional as it can automatically be pulled from an internet database like Yahoo Finance.
The features which solve my problems above include:
An option to select "Automatic reinvestment of dividends" which automatically determines the dividend amount and purchases more stock for you at that price.
Determination of today's value of the investment based on queries to Yahoo's
Ability to easily enter the asset allocation of a stock or mutual fund, including partial asset allocation (e.g. 50% large cap value, 50% mid cap blend)
Note - This is related to an earlier post I made regarding dollar cost averaging and determining rate of returns. (I finally got off my duff and did something about it)
Terms of Use Privacy policy Contact About Cancellation policy © freshhoot.com2025 All Rights reserved.