Tag: xeqt

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. ↩︎

assorted sushi and sashimi platter top view

What’s in my retirement portfolio (April 2026)?

RobHLeave a comment

This is a monthly look at what’s in my retirement portfolio. The original post is here.

Portfolio Construction

The retirement portfolio is spread across a bunch of accounts:

  • 5 RRIF accounts
    • 3 for me (Questrade, Wealthsimple)
    • 2 for my spouse (Questrade)
  • 2 TFSA accounts (Questrade)
  • 4 non-registered accounts, (1 for me, 1 for my spouse, 2 joint, all at Questrade)

The view post-payday

I pay myself monthly in retirement1, so that’s a good trigger to update this post. On April 24 at mid-day, this is what it looked like:

The portfolio is dominated by my ETF all-stars, (and if not an all-star, they are probably on the Magnificent Seven ETFs list). The charts look almost identical to the previous month, in spite of some conversion of AOA to XGRO. (I use Norbert’s Gambit to move USD denominated funds into CAD on a quarterly basis since my spending is all in CAD).

Plan for the next month

The asset-class split looks like this; you can read about my asset-allocation approach to investing over here.

It’s looking pretty close to the targets I have, which are unchanged:

  • 5% cash or cash-like holdings like ICSH and ZMMK
  • 15% bonds/income (most are buried in XGRO and AOA, rest are in XCB)
  • 20% Canadian equity (mostly based on ETFs that mirror the S&P/TSX — HXT and XIC)
  • 36% US equity (dominated by ETFs that mirror the S&P 500)
  • 24% International equity (mostly, but not exclusively, developed markets)

The alignment with target is what drives my investment decisions; and here I see that the international equity portion of my portfolio has drifted 1% below target, which is usually the threshold whereby I start to pay attention. Do I need to take action to increase my International Equity portion, or is my target something to reconsider? I have some thinking to do.

Overall

Part of using VPW2 as a strategy is the need to calculate your retirement net worth on a monthly basis. Last month’s meltdown is yet another speed bump that we’ve managed to survive, and April 2026 brings me to another all time high of my retirement net worth, as compared to January 20253.

My VPW-calculated salary continues to increase, albeit at a more modest rate, as expected.

  1. Questrade, although my RRIF settings are for the last day of the month, seems to need a lot of time to process the payment; I’ve learned that unless I have cash in the account at least 3 business days prior to the last business day, the automatic payment won’t happen. ↩︎
  2. Variable Percentage Withdrawal, my chosen decumulation strategy. ↩︎
  3. In constant dollars. I should really adjust my net worth to show inflationary impacts but it’s more calculating than I feel like doing at the moment. ↩︎

What’s in my retirement portfolio (March 2026)?

RobH1 Comment

This is a monthly look at what’s in my retirement portfolio. The original post is here.

Portfolio Construction

The retirement portfolio is spread across a bunch of accounts:

  • 5 RRIF accounts
    • 3 for me (Questrade, Wealthsimple)
    • 2 for my spouse (Questrade)
  • 2 TFSA accounts (Questrade)
  • 4 non-registered accounts, (1 for me, 1 for my spouse, 2 joint, all at Questrade)

The view post-payday

I pay myself monthly in retirement, so that’s a good trigger to update this post. On March 30, this is what it looks like:

The portfolio is dominated by my ETF all-stars, (and if not an all-star, they are probably on the Magnificent Seven ETFs list). This split is before all the quarterly dividends have paid out. AOA, XGRO, XEQT, XIC all have a quarterly payment that collectively might skew the numbers a bit — I have all these investments on DRIP so I just buy more of the same. All that to say that there weren’t big changes month to month; my USD holdings got a bit of a boost this month thanks to a favourable exchange rate. (A lot of my retirement holdings are in USD, so the FX rates matter somewhat). Here’s what the USD has looked like in CAD since my retirement:

Plan for the next month

The asset-class split looks like this; you can read about my asset-allocation approach to investing over here.

It’s looking pretty close to the targets I have, which are unchanged:

  • 5% cash or cash-like holdings like ICSH and ZMMK
  • 15% bonds/income (most are buried in XGRO and AOA, rest are in XCB)
  • 20% Canadian equity (mostly based on ETFs that mirror the S&P/TSX — HXT and XIC)
  • 36% US equity (dominated by ETFs that mirror the S&P 500)
  • 24% International equity (mostly, but not exclusively, developed markets)

The alignment with target is what drives my investment decisions; seeing the chart above tells me there’s no movements needed, which makes things simpler.

Since we’re just about in to the 2nd quarter of the year, it’s time for me to move some AOA into XGRO using Norbert’s Gambit1. The Gambit has worked out pretty well for me so far; I track my effective FX rate every time I do it, and it’s always less than relying on the instant (and relatively expensive) FX conversions offered by my broker2.

Overall

Part of using VPW3 as a strategy is the need to calculate your retirement net worth on a monthly basis. As you can see below, the most recent market gyrations have had a bit of an impact on the bottom line, taking me back to a value I haven’t seen since September last year:

But my VPW-calculated salary, which has a built in shock absorber (aka cash cushion), continued its upward trend nonetheless:

I’m expecting to take a pay cut at some point if the markets fail to recover, but pay cuts are an expected outcome of using VPW as a strategy. The “V” is for “variable”, after all. At this point, I’m still taking over 10% more than I did a year ago, so no matter how you slice it, things are more than on track.

  1. Of late, my need for spending in USD seems not so critical anymore. ↩︎
  2. Typically 1.5% of the amount converted. ↩︎
  3. Variable Percentage Withdrawal, my chosen decumulation strategy. ↩︎

What’s in my retirement portfolio (Feb 2026)?

RobH1 Comment

This is a monthly look at what’s in my retirement portfolio. The original post is here.

Portfolio Construction

The retirement portfolio is spread across a bunch of accounts:

  • 5 RRIF accounts
    • 3 for me (Questrade, Wealthsimple)1
    • 2 for my spouse (Questrade)
  • 2 TFSA accounts (Questrade)
  • 4 non-registered accounts, (1 for me, 1 for my spouse, 2 joint, all at Questrade)

You will notice that QTrade is no longer in the mix. I successfully moved the last RRIF accounts during the month; I learned a lot in the process. QTrade was the victim in the chase for free money offered by Questrade last year; based on current offerings, I’d say that QTrade still has an edge in terms of user experience over Questrade. I’ll go into more detail in a future post.

The view post-payday

I pay myself monthly in retirement, so that’s a good trigger to update this post. On February 28, this is what it looks like:

The portfolio is dominated by my ETF all-stars, (and if not an all-star, they are probably on the Magnificent Seven ETFs list) but if you’ve been following along, you’ll see a few changes.

  • I dropped XAW since I realized I didn’t need it if I was smarter the ratios of holdings I already owned (XEQT/XIC/XCB). Less is more.
  • I sold XIC instead of HXT in my non-registered account this month to help pay the bills because I reasoned that eliminating its dividend payouts would be better from a tax perspective2.

Plan for the next month

The asset-class split looks like this; you can read about my asset-allocation approach to investing over here.

It’s looking pretty close to the targets I have, which are unchanged:

  • 5% cash or cash-like holdings like ICSH and ZMMK
  • 15% bonds3 (most are buried in XGRO and AOA, rest are in XCB)
  • 20% Canadian equity (mostly based on ETFs that mirror the S&P/TSX — HXT and XIC)
  • 36% US equity (dominated by ETFs that mirror the S&P 500)
  • 24% International equity (mostly, but not exclusively, developed markets)

I am mulling over making a small tweak to these percentages, increasing US equity exposure at the expense of International equity based on some calculations I’ve done4 but this is neither urgent nor will it be massively impactful to the overall picture.

Overall

There is a bit of an anomaly this month that I should mention. A number of readers have questioned my wisdom of contributing monthly to a TFSA in retirement. From a tax-free growth perspective, it would be far better to make the contribution at the beginning of the year. And many studies have shown that lump sum investing provides better returns than spacing them out. And so, I have taken their advice5 and made all my TFSA contributions for the year this month. And since my TFSA is part of my net worth, there’s a bump being caused by that contribution.

And so, net worth overall is up month over month, a two month winning streak.

My VPW-calculated salary also continues its upward trend.

  1. One spousal, one individual. One at Wealthsimple because (a) I like their user experience and may consider them as my primary broker in the future and (b) they offered me free money and a laptop to move some fees their way. I can be bought. ↩︎
  2. HXT does not pay dividends and instead uses swap contracts to convert them into capital gains, which receive better tax treatment for me ↩︎
  3. Referred to as “Income” on the chart above ↩︎
  4. I’ll share those in a future post ↩︎
  5. With thanks to Steven and Sylvain ↩︎

Quick links for the long weekend

RobHLeave a comment

(Quick aside: as a retiree, I did have to make sure this coming weekend was, in fact, a long weekend 🙂 )

What’s the deal with AOA?: updated

While many Canadians are familiar with all-in-one products that trade on the Canadian exchanges (XEQT/XGRO, VEQT/VGRO, TEQT/TGRO, ZEQT/ZGRO), there is also a USD product that I use quite heavily in my retirement portfolio. That ETF is AOA. In this updated post, I break down what’s inside it. TL/DR: lots of US Equity, lots of International Equity, a tiny slice of Canadian equity, and broad coverage of the US and international bond markets.

Rob Carrick is back in (digital) print

One of my favourite ex-Globe And Mail staffers was Rob Carrick, the keyboard behind such valuable assets as the ETF Buyer’s Guide. He retired last year, but it seems he’s back doing the same job in a different way. He’s now writing on Substack, and you can find his words of wisdom over here: https://substack.com/@robcarrick1.

PWL on Retirement: “Finding and Funding a Good Life”

Not a new publication, but new to me…It’s penned by Ben Felix, a certified Canadian financial rockstar. Looks like a good read over a cup of coffee. Finding and Funding a Good Life.