How To Track Your Asset Allocation

Knowing your asset allocation is an important step to control and manage your investments. In a perfect world, you should be able to easily calculate and see your asset allocation. Simply press the button and voila! The reality is not that simple. Not all accounts you may have easily work together and that usually leaves you in charge of figuring out your asset allocation across all your accounts.

Consolidate Your Account Statements

Sounds simple? It can be but it can also require some work. If your finances have evolved to multiple accounts with different investments, it’s probably not that simple. Accounting software can greatly ease the pain of consolidating your statements but not all of them are online. For starter, not all investment providers allow you download statements not to mention that not all investments are publicly tracked openly. For examples, my company RRSP plan has mutual funds that aren’t trackable trough public markets. They are proprietary to the company and often times catered for the company they provide the service for.

With that said, the solution for me is manual tracking with Google Spreadsheet. A spreadsheet is perfect for the job as you can leverage its graphing capabilities and the math functions to group your investments under the appropriate allocation. You just need to build a table to categorize and track the information you need for the asset allocation graphs you want.

I’ll warn you up front that mutual funds are not easy to track within many other accounts. The fund company’s report will easily report your allocation for what you hold with them but you may have to do a bit of work to fit it within the different asset allocation graphs you desire. As mutual funds hold many other investments such as cash, bonds or equities, you may have to either classify the mutual fund as one asset or group the holdings within the fund.

The Different Asset Allocation Graphs

There is more than one way to look at your allocation. Some may be more important than others depending on your investments but it’s nice to see your portfolio from different angles. If you use a spreadsheet, it’s pretty easy to classify your allocation differently as shown below.

Just as an example, I am showing my dividends investment allocation below. The first graph represents my overall portfolio allocation otherwise it represents the dividend producer of my portfolio.

Allocation By Investment Types

To my surprise, I thought my fixed income ratio would have been higher. I put it together just recently and while I thought it was too high, seeing it this way changes my perception. If I look at my company RRSP account, it’s almost 60% but when I look at it across my entire portfolio, 31% isn’t too high.
How To Track Your Asset Allocations

Allocation By Sector

The asset allocation by sector allows you to see if you are more exposed to cyclical or risky companies. For example, I am overweight in the energy sector and it’s compounded by the fact that my holdings are only in one company. I have a plan to reduce my exposure here, I just have not pulled the trigger yet.
How To Track Your Asset Allocations

Allocation By Location

As the saying goes, Canada represents only a small fraction of the economic pie of the world. To benefit from the world economies, it’s often recommended to hold international investments. Personally, I understand Canada and the U.S. and that’s enough for me. I prefer to invest in a North American conglomerate that does business all over the world to get more international exposure. In any case, a graph by allocation can tell you if you are increasing your risk and may indicate that it is time to rebalance.
How To Track Your Asset Allocations

Allocation By Capitalization

Depending on your investment strategy, market capitalization may give you a hint as to how you want to rebalance your portfolio. I am quite happy with my current ratio here. My guidelines for the graph were:
  • Large Cap > 10B$
  • Mid Cap > 2B$
  • Small Cap < 2B$
Feel free to set your own guidelines.
How To Track Your Asset Allocations

Reviewing Your Asset Allocation

My primary focus in reviewing my asset allocation is to identify potential risks and future rebalancing. I would recommend you review your allocation at least once per year, and if possible, twice. One of the benefits of rebalancing based on percentage is that it indicates when one allocation does better than the other and it forces you to take your profits and redirect them towards your less performing investments.

Readers: How do you track your asset allocation? What do you look for?

Enhanced by Zemanta
Sign Up for my FREE Money Tips Newsletter!

15 Responses to "How To Track Your Asset Allocation"

  1. Mihou says:

    Hi everyone,
    As a dividend investor and in order to have more canadian stocks in my portofolio ,i am about to choose 2 stocks between four which are :TA.TO,NWF.TO ,ENF.TO ,AGBF-B.TO.
    Please give your thoughts
    Have a nice day

  2. Awesomeness says:

    I was using this post as a guideline in analyzing my portfolio. Was wondering which sector a couple of companies would fall under?
    Russell Metals and Exchange Income

  3. The Passive Income Earner says:

    A quick look in Globe Investor online and the classification comes out as "Merchandising and Lodging" for Russell Metals and "Transportation and Environmental Services" for Exchange Income.

    Now, you can organize it differently. For example, BCE comes up as Utilities but I classify it as Telecoms. My utilities are all energy utilities providing energy to consumers such as electricity and natural gas.

  4. Beating The Index says:

    You always have great graphs to get your point across. We share a similar investment type when comparing to my RRSPs.
    In fact my fixed income allocation fell to 25% with the recent market run, I am gonna have to rebalance and bring it back up to 35% this time.

  5. 101 Centavos says:

    TPIE, I recently forced myself to determine asset allocation by writing a post on it, and boy howdy was it a lot of work. The obvious benefit is that now I know better where our money is stashed.

  6. Agree with Mich; you have some pretty good graphs here. I need to go over all of my accounts and create a chart like this, too.

  7. Once you’ve determined the asset allocation that is best for you, you have to implement it via the investments you choose for your portfolio. At this point, the most important question you have to answer is whether you are going to take an active or a passive approach to investing. In a nutshell, the active investor believes that he or she can regularly generate (or choose fund managers who can generate) returns that are above the returns generated by some benchmark portfolio. In contrast, the passive (or index) investor wants only to match those benchmark returns at the lowest possible cost.

  8. I have to agree, diversifying is always best as it provides the less minimal risk when investing. Passive income is always good too. I recently asked my trader at scottrade to move my portfolio to a different broker though, didnt like them all to much :-(

  9. We absolutely love your blog and find most of your post’s to be what precisely I’m looking for. Does one offer guest writers to write content for yourself? I wouldn’t mind creating a post or elaborating on a number of the subjects you write related to here. Again, awesome weblog!

  10. rubik cube says:

    I just could not depart your site prior to suggesting that I extremely enjoyed the standard information a person provide for your visitors? Is going to be back often to check up on new posts

  11. It抯 actually a cool and helpful piece of information. I am glad that you shared this helpful information with us. Please keep us up to date like this. Thanks for sharing.

  12. I tend to make my investments in physical products, for example suisse gold bars. If something happened and the computers went down and you owed $20k in virtual gold on the market, what then? Just my thoughts.

  13. I think consolidating all your statements is a good though here. I love the asset location theory.

  14. JeffreyM says:

    RE: Asset (Sector) Allocation

    I am seeking a spreadsheet template to track my sector allocations.

    The tool used for this article and its output would be perfect. I would appreciate getting some links.

    • The Passive Income Earner says:


      Let me put it together as a Google Template and I’ll share the link. Thanks for the interest.


Leave a Reply

Submit Comment

Copyright © 2010 - 2014 The Passive Income Earner. All Rights Reserved.
Powered by HostGator on Theme Junkie.