Tag: asset allocation

person driving a person flying an aircraft

A new asset tracker

RobHLeave a comment

My entire retirement strategy is built around the idea of maintaining my asset allocation1 within the 5 categories I’ve (somewhat arbitrarily) decided to care about, namely:

  • Cash and ultra short term bonds, which make up 5% of my retirement portfolio
  • Bonds, which make up 15% of my retirement portfolio
  • Canadian Equity, which makes up 23% of my retirement portfolio
  • US Equity which makes up 37% of my retirement portfolio
  • And International Equity (anything that’s not the US or Canada) is 20% of my portfolio.

Tracking these percentages across the multitude of accounts2 me and my spouse hold, across multiple brokers requires some external tool help. For many years, it was based on the multi-asset tracker I have linked on the Tools I Use page. But in the past few months, I’ve migrated to a “new, improved” version of that tracker that has been re-architected so it is now based on pivot tables. Here’s some screenshots:

Pivot tables make maintaining the values in my portfolio much, much easier, and having structured tables makes it really easy to create new ways to analyze my holdings.

For instance, with the old asset tracker, say I wanted to compare the total value of my RRIF accounts with that of my spouse. Since we’re too young for income splitting, I’m motivated to try to keep the values between them relatively equal, so that we’re both withdrawing roughly the same dollar amount every year (thankfully, my spouse and I are the same age).

I could do this with the old asset tracker, but it would involve creating a new sheet, linking to the relevant values, (not so easy when you’re working from a single screen) making the calculations and looking at the result. And I would make it quick and dirty, since I wouldn’t know at the time whether it was something I wanted to track long term or not.

With the new asset tracker, it’s just a pivot table away. Takes seconds.

I’ll be posting a more thorough walk-through of it in the coming days, but if you want to check it out, it’s available here.

  1. If you want to learn more about asset allocation, this is a good starting point: Investment basics: Asset Allocation ↩︎
  2. TFSAs for both. RRIFs and Spousal RRIFs for both. Non-registered accounts for both. An extra non-registered account that serves as a cash cushion, and an extra RRIF at Wealthsimple because I needed a new laptop 🙂 ↩︎
snowball toss in los penitentes mendoza

Review: Snowball Analytics

RobHLeave a comment

Snowball Analytics (link here) is a tool that markets itself as a “Simple and Powerful Portfolio Tracker” with “automated dividend tracking”.

I don’t remember when or where I first kicked the tires of this tool but I figured I’d give it another look. I’m only using the free version of Snowball, since my multi-asset tracker tracks my portfolio and also I don’t really care about dividends.

Startup

Snowball gives you full access to all its feature set for 2 weeks so you can really see if it’s worth paying for. That’s a plus in my view. But even the free version allows you to manually create a single portfolio with up to 10 holdings in it. All the paid-for versions include direct connection to your brokerage, and the ones I’m most familiar with (Questrade and Wealthsimple) are both supported.

For fun, I created a public portfolio that’s sort-of1 based on the percentages in my June 2026 portfolio update. You can see it here. What you see on these public portfolio pages is similar, but not identical, to the screens shown if you create your own login.

Dashboard

Gives a high level overview of what’s going on in the portfolio: what it’s worth, how much you made today/all time, and, atypically, Passive Income aka yield.

One weird thing Snowball does is insist on putting your assets into “Categories” which you can define yourself or let it assign them automatically. It doesn’t really know what to do with ETFs and so it classifies them all as “Funds”, which is about as helpful a category as “Unclassified”. I flagged this with support, but I don’t really expect much. If you click through the pie charts, it does show what’s underneath, so this is mostly a cosmetic issue.

Pie Chart, like the one I show every month

Also shown on the dashboard are the timing and predicted value of future dividend payments, which is nice.

Future passive income from dividends shown on the Dashboard

Dividend tracking

Here we see what Snowball’s focus is. The dividend screen is quite comprehensive, and will warm the heart of the dividend-focused investor. I can’t really comment if the numbers presented on this screen are sufficient for that audience. My portfolio focus is on absolute growth, and I’m completely indifferent as to whether that growth comes from dividends or unit price appreciation. 

Anyway, I’m happy to hear whether others out there find this sort of dividend analysis useful, let me know at comments@moneyengineer.ca!

Analytics

Here you have a bunch of views of the makeup and performance of your loaded portfolio. For the holder of all-in-one ETFs, these pages are a mixed bag of helpful and not-helpful. On some screens, Snowball isn’t able to look deeply enough into what’s actually inside an all-in-one and thus produces unhelpful results. For example, I know my portfolio is 80% equity. Snowball has other ideas, especially when it comes to Canadian ETFs:

Asset class distribution has obvious problems

There’s problems here:

  • XGRO/XEQT/HXT are missing asset classes. Their percentages don’t add up to 100%
  • A lot of Canadian all-in-one ETF asset classes are classified as “Other”, which is wrong. XGRO (for example) should line up exactly as AOA does, with 80% stocks and 20% bonds, more or less. For XGRO, the bond percentage is right, but the other 80% is suspect.
  • XIC/VFV/HXT are 100% Canadian equity, but Snowball seems lost here.

The performance widget seems to be a lot better; here you can backtest your portfolio against a bunch of benchmarks. Unfortunately, none of the included benchmarks includes bonds, but you can see how my portfolio stacks up against a global equity pool, namely the MSCI World index:

Growth charts are helpful to see how your portfolio compares to a benchmark

I did see a few problems here, too:

  • Not all of my portfolio holdings have been around for (for example) 5 years. So how is the tool generating 5 year return charts?
  • When you select “all” as a timeframe, my portfolio shows a one year performance. Puzzling.

The fact that my portfolio lags the MSCI World is unsurprising since my portfolio has 20% bonds, and the MSCI World has none. Bonds add stability to a portfolio at the expense of growth. Sometimes I wonder if that stability is really worth it.

Conclusion

Snowball, like many tools, struggles with understanding what’s actually inside an all-in-one ETF like XEQT or XGRO. For me, that sort of shortcoming is a deal-breaker. If you were a holder of individual stocks that cared about passive (dividend) income, it might be worth your time.

What do you think? Let me know at comments@moneyengineer.ca!

  1. “sort of” because I have more than 10 holdings in my portfolio. I got most of them, and scaled it to start as a 100k CAD portfolio. ↩︎

black and white photo of a woman holding birdcage

CAGE versus XEQT: what’s the deal?

RobHLeave a comment

It’s not that often an ETF launch causes so much buzz, but my usual feeds are all talking about Avantis CIBC CAGE. So what is it? Per its fact sheet it

Invests primarily in equity securities from developed and emerging markets through a portfolio of ETFs. The fund selects companies based on value and profitability characteristics, using a broad set of company financial fundamentals such as book value, earnings, and cash flow, together with current market prices. Designed to provide diversified global equity exposure in a single investment option.

https://www.cibc.com/content/dam/cibc-public-assets/personal-banking/investment/etfs/pdfs/cibc-fund-snapshot-cage-en.pdf

So let’s break that down:

“Invests primarily in equity securities…through a portfolio of ETFs”

Translation: CAGE is a fund of funds that’s 100% equity. Sounds a lot like XEQT/ZEQT/TEQT/VEQT. Looking a little deeper, it holds

  • CAUS: A US Equity ETF
  • CACE: A Canadian Equity ETF
  • CADE: An International Equity ETF
  • CASV: A Global Small Cap ETF
  • CAEM: An Emerging Equity ETF

Seems pretty normal so far.

“The fund selects companies based on value and profitability…using financial fundamentals”

Translation: This isn’t an index fund. CAGE is picking which companies to invest in based on balance sheet metrics. This starts to sound like a typical managed fund that typically underperforms the index it’s supposed to be measured against1.

I’m skeptical. Index (aka passive) investing has proven that it works over time.

What’s inside CAGE?

So, let’s see what’s actually inside this fund and compare it to XEQT2. As it turns out, this isn’t easy. Figuring out what’s inside CAGE requires you to navigate to each of CAGE’s holdings and look at what’s there. Irritating, but that’s not the worst of it — the constituent funds only show top 10 holdings each. That leads to a tremendous blind spot as to what you’re actually purchasing when you buy shares of CAGE. I hope CIBC fixes this, and soon. Anyway, I took XEQT’s top 10 and compared it to CAGE’s allocation.

CompanyXEQT Holding (%)CAGE Holding (%)
NVIDIA3.07%1.89%
Apple2.52%1.88%
Microsoft1.92%1.45%
Royal Bank1.81%1.88%
Amazon1.64%1.51%
Alphabet Class A1.42%0.96%
TD Bank1.30%1.44%
Broadcom1.25%<1%3
Alphabet Class C1.13%0.77%
Shopify1.07%0.99%
Total ex Broadcom15.88%12.77%
Comparing top holdings of XEQT versus CAGE

What’s immediately obvious is that CAGE doesn’t place as much money in the trillion dollar market cap companies as XEQT does.

A more interesting (?) exercise might be to take a look at CAGE’s top holdings as compared to that of XEQT.

CompanyCAGE Holding (%) / RankXEQT Holding (%)/ Rank
NVIDIA1.89% / 13.07% / 1
Apple1.88% / 22.52% /2
Royal Bank1.88% / 31.81% /4
Amazon1.51% /41.64% /5
Microsoft1.45% /51.92% /3
TD Bank1.44% /61.30% /7
Shopify0.99% /71.07% /10
Alphabet Class A0.96% /81.42% / 6
Canadian National Resources0.91% /90.72% / 16
CIBC0.86% /100.75% /14
Total14.56%17.00%
Comparing top holdings of CAGE versus XEQT

And again, not too much of interest here — CAGE holds less of the trillion dollar companies than XEQT, but the differences aren’t massive.

High level metrics

Well, since we can’t get a good feel on what’s inside CAGE, maybe looking at other vital signs are helpful?

MetricCAGEXEQT
MER0.28%40.20%
Number of underlying holdings692658475
Dividend Yield2.18%60.82%7
Target allocations8US Equity: 39.4%
Canadian Equity: 30%
International Equity: 17.6%
Global Small Cap Equity: 8%9
Emerging Equity: 5%		US Equity: 45%
Canadian Equity: 25%
International Equity: 25%
Emerging Equity: 5%
Comparing CAGE metrics with XEQT

This shows that CAGE is more expensive, holds fewer underlying stocks (we think), has a higher dividend yield (unsurprising, given its focus) and invests more in Canada than XEQT at the expense of International Equity10.

Performance

Comparing performance isn’t going to be very useful since CAGE is new, but CAGE inherits its strategy from an older US-based fund, namely AVGE. Now, to be clear, AVGE and CAGE aren’t quite the same thing. CAGE, as a Canadian fund, will tilt more to Canadian Equity holdings. But the approach used by AVGE and CAGE is the same: find quality companies and invest in them, wherever they are. So to me, comparing AVGE to its benchmark, the MSCI all-country investable market index, is a fair comparison. That index can be purchased by buying ACWI, an ETF that I’ve never heard of. I have heard of VT, so I’ll throw that into the mix since that seems to be a similar idea. Here’s what https://dqydj.com/stock-return-calculator/11 had to say about that:

Comparing performance of VT, ACWI and AVGE to gauge effectiveness of Avantis’ stock picking techniques

AVGE doesn’t have a hugely long track record either (less than 4 years in existence) but, regrettably, it’s coming up on the short end of the stick as compared to the passive index funds. Not by a lot, though.

My take

Buzz or no, I don’t think this product is for me. I buy passively managed ETFs, for the most part12. The lack of transparency on CAGE’s holdings is irritating (I am hoping/assuming that CIBC will fix this) and there’s nothing about the performance of its US sister that leaves me with FOMO. I’ll stick with The magnificent seven ETFs for now.

  1. Canada’s own CPP fund is, sadly, one of those ↩︎
  2. As of April 30, 2026 for both. I note that XEQT provides daily updates on one screen to see what’s inside. For CAGE, you have to resort to spreadsheets. ↩︎
  3. The constituent ETFs of CAGE only show top 10 holdings; Broadcom doesn’t crack the top 10 of CAUS which is 40.13% of CAGE. ↩︎
  4. Per https://usegreenline.com/en-ca/articles/cage-etf-explained. ↩︎
  5. 1782 for CAUS per https://www.investing.com/etfs/caus-toronto-holdings, 299 for CACE per https://www.investing.com/etfs/cace-toronto-holdings, 2403 for CADE per https://www.etfrc.com/CADE.TO, 1316 for CASV per https://www.investing.com/etfs/casv-toronto-holdings, 1126 for CAEM per https://ca.investing.com/etfs/caem-toronto-holdings for a total of 6926. For reasons unclear, CIBC doesn’t seem to think it’s worthy of them to publish this information themselves. ↩︎
  6. As of end April 2026, the latest thing published ↩︎
  7. As of end May 2026. ↩︎
  8. For CAGE, refer to https://www.cibc.com/content/dam/cibc-public-assets/personal-banking/investment/etfs/pdfs/cibc-fund-snapshot-cage-en.pdf. For XEQT, refer to https://www.blackrock.com/ca/investors/en/literature/product-brief/core-etf-portfolios-product-brief.pdf ↩︎
  9. 60% is US Equity, 4% is Canadian Equity per https://www.cibc.com/en/personal-banking/investments/etfs/avantis-global-small-cap-value-etf.html ↩︎
  10. XEQT is a bit of an outlier here; read Are my portfolio’s asset allocation targets “correct”? ↩︎
  11. It seems that my formerly preferred tool has gone to a registration process; I’ll have to revisit Tools I Use I guess… ↩︎
  12. Bond funds are often actively managed. ↩︎

crop sportswoman checking information on tracker

Mini Review: Portfolio Tracker

RobHLeave a comment

Over the years I built my own portfolio tracker (the multi-asset tracker) and I’ve shared it on this website1. I’ll be the first to admit it’s not terribly user-friendly, which is somewhat understandable since I built it for myself.

If you want to take a look at another Google Sheet tracker that is fully documented and more user friendly, then you might want to take a look at Portfolio Tracker.

I’m not sure where I first encountered this tool; possibly on Reddit or perhaps the Financial Wisdom Forum.

Anyway, the brains behind this tool are substantial, and I bow to the organization and wizardry of the author. For people who adhere to the idea of asset allocation as a way to make investment decisions, you won’t find a better fit.

So, in a nutshell, what does it do?

  • It allows you to track the value of your portfolio across multiple brokerage accounts using multiple data sources for near-real time quotes2
  • It allows you to set up your own asset classes to track and to set individual targets for each, both at the portfolio level and at the account level3.
  • It will show you how far off you are from your targets and make high-level recommendations for where (what account) to buy/sell to get back on track

One very nice feature of Portfolio Tracker is that a given asset can be divided up into multiple asset classes. For fans of asset allocation funds (like me) this is a critical feature. With this feature you can accurately depict that (say) XEQT is 25% Canadian equity and 45% US Equity.

Once I figured out the terms used in Portfolio Tracker, it was pretty straightforward to enter my own portfolio across the 5 RRIF, 2 TFSAs and 3 non-registered accounts.

What confused me at the beginning about Portfolio Tracker is that it has more layers than I’m used to:

  • It starts with asset. Like XGRO, AOA or ZMMK. So far so good.
  • Assets belong to one (or more) asset classes. If more than one, the percentage has to add up to 100%. Asset classes are where I focus my attention: Portfolio Tracker has more of them than I need4 by default but you can define as many or as few as you like.
  • Asset classes in turn belong to a unique Asset Category)5.; a given Asset Category can be the parent of multiple asset classes (e.g. US Small Cap and US Total Market asset classes are both included in the US Equity Asset Category)
  • And asset categories roll up into Parents (stocks, bonds, short-term)

One minor point of confusion to the Canadian user is the inclusion of TIPS which is a uniquely US investment vehicle. In Canada you can buy real return bonds or buy ETFs that hold TIPS if you wish. I don’t bother with either myself.

The only limitation I could find in this tool was that it didn’t support multiple currencies. If you hold USD assets (as I do), that is a very serious limitation, but one that I could (and did) correct myself pretty easily with a few changes. When I sent a note to the provided support email on that limitation, the author promptly replied and admitted it was not the first time someone had asked about it.

I recommend this tool as a user-friendly introduction to tracking your own portfolio.

  1. I’ve built a new version based on pivot tables; on my to-do list is to make it generic enough to share. The new design lifts some ideas from Portfolio Tracker, in fact. ↩︎
  2. At one time my own tracker did this too but as it requires web scraping code it breaks pretty frequently, and in the mean time googlefinance() has become much more reliable ↩︎
  3. I’ve only really cared about portfolio level, but I have some broad rules about what goes where at the account level. TFSA: Equity only. RRIF: only place outside of the cash cushion where cash can be held. And the only place I hold bond funds. Non registered: equity only. ↩︎
  4. It divides US Equity into small cap (“US Small Cap”) and total market (“US Total Market”). This particular example I found a bit weird since logically “US Small Cap” is normally considered part (albeit a very small part) of the “US Total Market”. ↩︎
  5. Asset Categories for me are a level of detail I don’t need. If you set them to be the same as your Asset Classes then they effectively aren’t used. Although probably best to given them “AC”names so you don’t get mixed up, e.g. US Equity asset class belongs to US Equity AC asset category. ↩︎

close up view of colorful liquids in laboratory glasswares

Are my portfolio’s asset allocation targets “correct”?

RobH1 Comment

A key aspect of my investment philosophy is to have targets for each of the asset classes I invest in. Because I like to keep things simple, my asset classes are rather broad1:

  • Cash, which includes ultra-short-term bonds (bonds with durations measured in days, not years)
  • Bonds2, which means corporate and government bonds from multiple geographies with various and assorted durations
  • Canadian Equity: Canadian stocks
  • US Equity: US Stocks
  • International Equity: Stocks that don’t sit in North America

The targets I’ve used for a few years now are

  • 5% Cash
  • 15% Bonds
  • 20% Canadian Equity
  • 36% US Equity
  • 24% International Equity

But where did those target numbers come from?

The easy answer is that they are based on the target number of the Canadian 80/20 fund I use in my retirement portfolio, namely XGRO, one of my ETF all-stars. XGRO’s makeup is actually

  • 20% Bonds
  • 20% Canadian Equity
  • 36% US Equity
  • 24% International Equity

The immediately obvious difference between XGRO and my target is the presence of “Cash” in my target, something XGRO doesn’t have3. “Cash” was a recent arrival to the portfolio, a decision I took to accommodate the presence of a Cash Cushion in my portfolio. The Cash Cushion is an integral part of my chosen decumulation strategy, VPW. So rather than keep the Cash Cushion as something set apart from my asset allocation model, I chose to create a new asset to track. 5% was a small and round number, and is about 2x the value of the Cash Cushion today.

That 5% is almost all invested in ultra-short term bond funds so perhaps you could also argue that I never stopped holding 20% bonds in my portfolio4; I just segmented that category a bit more precisely.

But why 20% bonds? Shouldn’t a retiree have a greater portion of bonds to protect against market downturns5? Habit, I suppose. I’ve held 20% bonds for decades now, since well before I retired. I don’t see any reason to change that now. I’m hoping my retirement will go on for decades, and so having a good chunk of equity is a good way to make sure my portfolio returns outpace inflation and offer some protection against outliving my money.

So 80% equity it is; but are the allocations between Canada, the US and International markets the right allocations? Like I said, I basically picked the equity targets to match what the percentage allocations are in XGRO. If I look a bit further at the other *GRO funds (TGRO, VGRO, ZGRO), I find that XGRO is a bit of an outlier with respect to International Equity allocation:

ETF% CAD% US% Int’l
XGRO (Blackrock)203624
TGRO (TD)626.735.617.8
VGRO (Vanguard)253520
ZGRO (BMO)204020
Average for all22.936.720.4

This tells me a few things

  • My US allocation target of 36% is justified by looking across multiple funds
  • My International Equity target is probably too high if I rely on the wisdom of (small) crowds.

Since I like dealing with round numbers, a case could certainly be made for my targets to instead look like

  • 23% Canadian Equity
  • 37% US Equity
  • 20% International Equity

Using these targets and looking at my current holdings would require me to move about 3% of my International equity holdings into Canadian equity.

I can control my equity allocations in normal monthly transactions, somewhat — since a good chunk of my retirement salary is funded by selling non-registered assets, I get to choose (somewhat) what equity class to liquidate. Here’s the problem I see — my International Equity component in my non-registered account is SCHF, which trades in USD. Liquidating SCHF is possible. but the small problem with SCHF is that it’s denominated in USD, and thanks to my current credit card lineup, I don’t have a way (or need) to spend USD natively anymore.

Sigh. Actually, there’s really no good reason for me to hold *any* USD assets in my non-registered accounts. USD assets are now, for me

  • Difficult to spend as USD
  • Problematic because they are counted against my “foreign income”, per CRA’s T1135; hold too much foreign income, and you have to file additional paperwork at tax time. I hate paperwork.

So, in conclusion,

  • I think I will shift my asset allocations slightly, tilting a bit towards Canadian Equity at the expense of International Equity; this will take time as I draw down SCHF from my non-registered portfolio
  • I will get rid of USD-denominated assets from my non-registered accounts. This will start with reversing the decision I took about a year ago when I went with a majority of ICSH in my Cash Cushion.
  1. 5 categories could easily morph into 20 if you were particular about things. For example, bonds could be split by geography, and/or by duration and/or by bond quality. The US and Canadian equity categories could be split into sectors and/or company size. The international equity categories could be split by region, country, sector, company size. The possibilities are endless, and so could the number of assets you actually hold to meet them. I don’t claim that my 5 are the right ones for you, but I’ve used them for quite a while now. ↩︎
  2. For the longest time, and for many earlier posts, I refer to this segment as “Income”. This made some sense in the days where I didn’t track “Cash” as a distinct category. But it’s time to move on. What lives here are bonds, and only bonds. ↩︎
  3. Of course, all ETFs hold some portion of cash, it’s pretty much unavoidable as you shift assets, collect dividends and so on. I don’t worry about this sort of thing; my assumption is that the ETF manager is doing their job and adhering to their published targets. That MER has to be worth something, right? ↩︎
  4. Questrade (my primary broker) doesn’t offer high interest savings accounts; at my previous broker (QTrade) this cash cushion really was cash held in a high interest savings account. ↩︎
  5. And there will always be market downturns. SORR is a common acronym thrown around; it stands for “Sequence of Returns Risk”. Basically this is the admission that there will be market downturns during retirement; SORR is the risk that those downturns happen really early in retirement and blow up your well-crafted plan because you are forced to sell into a down market. My mitigation strategy concerning SORR? I can always find a job if things got really bad… ↩︎
  6. The reason TGRO’s numbers aren’t round is because the other *GRO funds hold 80% equity while TGRO holds 90% equity. I’ve scaled TGRO’s holdings accordingly. ↩︎