Tag: RRIF

variety of cookies in a box

What’s in my retirement portfolio (July 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 retirement, so that’s a good trigger to update this post. On July 301 before the markets opened, 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).

There have been pretty big changes since last month as my strategy to Kick USD out of my retirement portfolio continues in earnest. This has focused on getting rid of AOA and ICSH in my spouse’s RRIF account this month as she takes advantage of the free Norbert’s Gambit included in her trial subscription to Questrade Plus2.

AOA is largely being replaced by XGRO, but because AOA is so heavily US Equity weighted, I always have to pick up VFV to make up the difference — I’m kicking USD out of my portfolio, not the US market. ZST is my pick for the RRIF to replace ICSH. It’s a similar idea to ICSH, but since Canadian interest rates are lower, I expect I’m sacrificing a bit of return there. I hope this will work itself out in the long run.

And I’m trying to respect my asset allocations at the same time.

Plan for the next month

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

The moves I made to start reducing USD in my portfolio have quickly allowed me to get to my recently revised target allocations I have for each asset class:

  • 5% cash or cash-like holdings like ZMMK and ZST
  • 15% bonds/income (most are buried in XGRO and AOA, rest are in XCB)
  • 23% Canadian equity (mostly based on ETFs that mirror the S&P/TSX — HXT and XIC); this is up from the old 20% target
  • 37% US equity (dominated by ETFs that mirror the S&P 500); this is up 1% from the old target
  • 20% International equity (mostly, but not exclusively, developed markets); this is down 4% from the old target

With the asset class splits under control, next month will see more moves to get rid of USD in my portfolio. There’s only USD in my RRIF accounts now, all invested in AOA and ICSH. These positions will be reduced by 1/5th in August as my target is to be fully USD free by the end of the year.

My timing for conversion looks to have been pretty decent; the USD/CAD rate continues to run north of 1.40, which for me is a good thing.

Overall

Part of using VPW3 as a strategy is the need to calculate your retirement net worth on a monthly basis. My three month winning streak has come to an end as I took a slight step back month over month. However, I’m worth 19% more than when I started my retirement journey in January 2025.

Irrespective of my net worth stumble, my VPW-calculated salary continues to increase, albeit at a more modest rate, as expected. The VPW cash cushion (now 100% invested in ZMMK) acts like a shock absorber to my salary, smoothing out the more volatile month to month variations in my net worth.

  1. I did all the trading I needed to do on the 24th; it takes a few days for everything to settle and for money to get sent to the bank account. My net worth is quite a bit lower after the mini-crash on the 29th! ↩︎
  2. Questrade Plus is 11.95 monthly, but offers a 30 day free trial. I’m a cheapskate, remember? Norbert’s Gambit is otherwise 9.95 a go plus HST. ↩︎
  3. Variable Percentage Withdrawal, my chosen decumulation strategy. ↩︎
ai chat interface on laptop screen

Mini-Review: Questrade MCP support for AI agents

RobHLeave a comment

I’ve had AI on the brain lately; it’s partly because I’m always curious about new technology — but I also recognize that my own portfolio management is more labour-intensive than it needs to be. That’s partly because I enjoy the tinkering, partly because I like things done in a certain way. My spreadsheets help a lot with making things more mechanical, but I still have to manually update them to get useful results1.

Now, I’m far from an expert on this sort of thing, but I’ve been experimenting with Anthropic’s Claude2 for a few days, getting familiar with how it works, and downloading the desktop client to my laptop.

Coincidentally, this week, I noticed a new little popup in my Questrade portal this week which promoted a new capability, namely MCP support: How to Connect Questrade to AI Tools with MCP3.

“MCP” stands for “Model Context Protocol”. Gemini helpfully describes it as “… a universal USB-C port for artificial intelligence”. Clear enough. In other words, MCP allows Claude read-only access to my Questrade account, which sounded rather useful and instead of pages of documentation (typical for an API integration), I got a three step process to make the connection.

  • copy the MCP URL from Questrade
  • Plop it in Claude’s Custom Connectors setting
  • Login to Questrade and permit access from Claude

I successfully followed these three steps in roughly 60 seconds, and next thing I knew, Claude was able to give me a list of my Questrade accounts and balances4.

That’s easy stuff, admittedly, so I figured I would ask it to please calculate the number of XGRO shares I would have to sell in order to make my monthly RRIF minimum payment. (This is something I actually do every month; you can see the steps I have to take to get paid in retirement over at What do you have to actually DO to get paid?

Claude was happy to help me — and it knew enough to ask me how old I was and what the value of my RRIF was at the beginning of the year. (This is how RRIF minimum is calculated, if you’re new to how RRIFs work, you might want to give Demystifying RRIFs a read).

But since I already know what my monthly RRIF minimum payments are, I told Claude to please use those. And it correctly calculated how many shares to sell based on the live cash balance in the RRIF account and the live quote for XGRO.

Claude immediately offered to set up a monthly schedule to do this…but, unfortunately, Claude scheduling is one of those capabilities that requires a not-free Claude subscription. The entry level subscription would be $24/month, or around $300 a year. In the grand scheme of things, that’s not a ton of money, but as a rule I’m a bit reticent about subscription-based services since they have a way of slowly adding up and becoming a drain on your hard-earned savings5.

That was a silly, easy question to ask, and failing that test would have resulted in mockery.

So I asked Claude a more difficult question, namely to tell me how much Canadian Equity exposure I had across my entire portfolio.

Claude was quickly able to identify my 100% Canadian equity holdings (currently VCN, XIC and HXT), and correctly pointed out that my all-in-ones (XGRO, XEQT, ZEQT) were also sources of Canadian equity. With a confirmation to proceed, Claude was able to quickly create an aggregated table that showed all my Canadian equity holdings6.

But there remained a problem. Claude failed to uncover the Canadian equity portion of AOA, which is a USD-based 80/20 fund. My own calculation put the Canadian equity portion of AOA at 2.64% so it’s small, but not zero. But since I have a pretty large (if dwindling7) portion of my savings in AOA, this is a signifiant miss. I pointed this out to Claude who agreed (naturally) and fixed it8, along with a helpful and accurate observation9:

“Notes on AOA specifically: it’s a US-domiciled fund, so its 3.03% Canada weighting is small and comes through its international-developed-markets sleeve rather than a dedicated Canada allocation — nowhere near the home-country tilt you get from XEQT/XGRO/ZEQT. Its USD value was converted at the last USD/CAD rate we pulled (1.4087); today’s rate may differ slightly.”

Anyway, this experiment proved to be interesting, but without additional automation10, not particularly helpful to me. The key gaps right now are that it does not currently provide access to my spouse’s accounts (this I blame on Questrade’s design and decisions regarding how to treat TA accounts), and the lack of an MCP connector to Wealthsimple11 (where I have some retirement holdings). Have you connected your DIY accounts to an external tool? Tell me about it at comments@moneyengineer.ca!

  1. Questrade (my primary broker) has had API access for quite a long time, and I kept thinking I would figure out how to make it useful but I do find the security aspects of messing with this a little daunting. And there have been enough negative posts about its reliability and availability it makes me wonder whether it’s worth my time. ↩︎
  2. The free version, naturally. I am still a cheapskate. ↩︎
  3. It appears that the promotion of this capability is not showing up in everyone’s account. Whether it is being selectively enabled on a per account basis is unknown. ↩︎
  4. Well, not all of them. I’ve long complained about how Questrade handles accounts for which I have Trading Authorization (i.e. my spouse’s accounts). There’s no unified view from my login and this also shows up in my interactions with Questrade via Claude. Claude also doesn’t know about the accounts for which I have TA. ↩︎
  5. “Pay yourself first” (cfr The Wealthy Barber) cuts both ways. If you set aside money for savings before you ever see it land in your bank account, it is a bit like magic over time. If you are billed for a subscription service that automatically renews, it’s like magic for the provider of the subscription service. They’ve done the work to land a client, and now they can just watch the monthly revenues roll in, knowing that automatic renewals are unlikely to get noticed immediately, if ever… ↩︎
  6. It appears Claude took a look at the real time Canadian equity exposure of (for example) XEQT. I don’t myself bother doing this because XEQT (for example) has a stated objective of keeping the Canadian equity portion of its fund at 20% and it rebalances periodically to do this. So 20% is good enough for me. ↩︎
  7. I’m actively kicking USD assets out of my portfolio: Kicking USD out of my retirement portfolio ↩︎
  8. It set the percentage at 3%. ↩︎
  9. This wasn’t new or helpful to me since I own AOA, but I include it just to show the sorts of things Claude mentions. ↩︎
  10. Which may be possible; I’ll have to play with it a bit more ↩︎
  11. There are some 3rd party integrations I’ve seen, but I’d prefer it to come from the source. ↩︎

variety of cookies in a box

What’s in my retirement portfolio (June 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 June 30 before the markets opened, 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). But the observant reader will start to see some changes from last month as my strategy to Kick USD out of my retirement portfolio starts to take effect. The contributions of AOA and ICSH (both USD funds) to my retirement portfolio are notably down and SCHF has disappeared entirely — SCHF was the last bit of USD in my non-registered accounts. ZMMK, XGRO and VCN, on the other hand, have gained in importance to make up for the USD-denominated departures. And ZST (ultra short-term bond fund) and VFV (S&P 500 US Index fund) have begun to make an appearance; you’ll see more of these funds in future months. My ETF all-stars post has been updated accordingly.

Plan for the next month

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

The moves I made to start reducing USD in my portfolio have quickly allowed me to get to my recently revised target allocations I have for each asset class:

  • 5% cash or cash-like holdings like ICSH and ZMMK
  • 15% bonds/income (most are buried in XGRO and AOA, rest are in XCB)
  • 23% Canadian equity (mostly based on ETFs that mirror the S&P/TSX — HXT and XIC); this is up from the old 20% target
  • 37% US equity (dominated by ETFs that mirror the S&P 500); this is up 1% from the old target
  • 20% International equity (mostly, but not exclusively, developed markets); this is down 4% from the old target

With the asset class splits under control, next month will see more moves to get rid of USD in my portfolio. There’s only USD in my RRIF accounts now, all invested in AOA and ICSH. These positions will be reduced by 1/6th in July as my target is to be fully USD free by the end of the year.

My timing for starting the conversion looks to have been pretty decent; the USD/CAD rate moved significantly in my favour this month. I don’t expect that to last!

Overall

Part of using VPW1 as a strategy is the need to calculate your retirement net worth on a monthly basis. And once again, a new all-time high:

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

  1. Variable Percentage Withdrawal, my chosen decumulation strategy. ↩︎
variety of cookies in a box

What’s in my retirement portfolio (May 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 May 29 before the markets opened, 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; AOA is up a bit mostly because the USD has been on a bit of run this month, increasing almost 1% month over month :

Plan for the next month

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

Here I have some work to do, since I’ve recently revisited the target allocations I have for each asset class:

  • 5% cash or cash-like holdings like ICSH and ZMMK
  • 15% bonds/income (most are buried in XGRO and AOA, rest are in XCB)
  • 23% Canadian equity (mostly based on ETFs that mirror the S&P/TSX — HXT and XIC); this is up from the old 20% target
  • 37% US equity (dominated by ETFs that mirror the S&P 500); this is up 1% from the old target
  • 20% International equity (mostly, but not exclusively, developed markets); this is down 4% from the old target

At the same time, I’m looking to get rid of my USD allocations since they are adding needless complexity and I no longer have a way to easily spend USD anyway. This is going to be a multi-month process1, but I want to be USD free by the end of the year.

So, next month, I will begin. I’ll first tackle ICSH in my non-registered account, which I’ll do once it pays out its monthly dividend in the first week of June. And I’ll begin replacing AOA with XGRO2.

Overall

Part of using VPW3 as a strategy is the need to calculate your retirement net worth on a monthly basis. And once again, a new all-time high:

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

  1. Multi-month because I want to make sure I don’t get burned by a sudden change in USD/CAD FX rates. By converting some every month, I can smooth out any weird spikes. ↩︎
  2. The biggest difference between AOA and XGRO (besides the native currency) is the amount of Canadian Equity content. AOA has a very small amount (about 3%) whereas XGRO has 20% ↩︎
  3. Variable Percentage Withdrawal, my chosen decumulation strategy. ↩︎
man juggling on a tightrope against cloudy sky

What do you have to actually DO to get paid?

RobHLeave a comment

I’ve covered the mechanics of getting paid in retirement at what is a pretty detailed level, but maybe you’re curious about the actual, blow by blow steps of getting paid?

In a typical month, I make 6 sell trades (one for each RRIF, one for the non-registered account) and perform 2 cash movements (one withdrawal from my non-registered, and either a withdrawal from the cash cushion or an inter-account cash movement from the non-registered account to the cash cushion).

The diagram from the previous post1 I’ll include here, since it may make things a bit clearer:

Step 1. Make sure net worth is accurate in my spreadsheet

By the time the end of the month rolls around, this is normally fine. The beginning of the month has a bunch of (of mostly, but not fully, automatically reinvested) dividend payments and reward payments (aka “free money”) so the opening few weeks of the month always require tweaks to share amounts and outstanding cash amounts.

A quick login to Passiv, which connects in real time to all my retirement accounts held at Wealthsimple and Questrade, allows me to do a sanity check of my spreadsheet values versus what’s actually in all of my accounts. In the event there are discrepancies, I fix them in the spreadsheet before proceeding.

That’s what is behind step A in the diagram.

Step 2: Decide the order of priority for liquidating various assets in my non-registered accounts

Every month, I know that I will have to liquidate shares in my non-registered account, but since I have four different holdings to choose from, I have to input which ones are the most important to liquidate first2. This year, I’ve been trying to reduce dividend-paying holdings to reduce that source of income come tax-time. Another factor I consider is how far my portfolio has drifted from the asset allocation targets. Selling a fund to reduce an overweight asset class (e.g. Canadian Equity) is always a good way to take advantage of a needed asset sale.

This is an input for step G in the diagram.

Step 3: Run the Monthly Macro

The monthly macro3 does a bunch of things to help me figure out exactly what I need to do:

  • It plugs my current net worth into the VPW spreadsheet which then generates the VPW suggestion; the macro then squirrels the suggestion away
  • It takes a look at the current value of my cash cushion and squirrels that away;
  • It takes a look at the current value of the CAD/USD FX rate and squirrels that away4
  • It saves the current month’s numbers into a monthly ledger, which allows me to share with all of you things like my salary and net worth over time.

None of that, strictly speaking, is in the diagram, but is a necessary step for Step 4, below.

Step 4: Follow the step by step instructions that result

With the static copies of key bits of data (VPW suggestion, value of cash cushion, FX rate) these now plug into a specially crafted spreadsheet that provides instructions in English, step by step.

  • It tells me how many shares to sell in each of my accounts5
    • How many XGRO6 to sell based on the current share price and current cash position in each of the 5 RRIF accounts (steps E and F in the diagram; the RRIF payment amount is fixed at the beginning of the calendar year)
    • How many and which shares I need to sell in my non-registered account based on VPW’s suggestion (step G)
  • It tells me if I have to move money to my chequing account from my cash cushion or if I have to move money from my non-registered account to my cash cushion. (That’s step D or D’ in the diagram above).
  • The RRIF payments (steps E’ and F’ in the diagram) are automatic; nothing for me to do there
  • Step G’ requires a visit to Questrade’s “Move Money: Withdraw” menu in order to get money into my chequing account

In summary, I have to execute as many as 6 “sell” trades — one for each of the RRIFs7, and one (possibly more8) in the non-registered account. And then there are two “move money” transactions I have to make — one from my non-registered to my chequing account, and one representing step D/D’ (one of the two is always in play).

Step 5: Update my records

This I usually do right away since I have all the necessary data in front of me. That means

  • updating my holdings spreadsheet to reflect the reduction in XGRO in my RRIFs and the reduction of whatever holdings I liquidated in my non-registered account
  • Add the transaction in my non-registered account to adjustedcostbase.ca so I know what my capital gain/loss was.

Step 6: Wait for the Money

The non-registered cash is usually the first to arrive in my bank account, a day or two later.

Wealthsimple is next, and Questrade’s payments inexplicably arrive on different days depending on what I don’t know. Although all 4 Questrade RRIFs are set up with the same payment schedule, the 4 RRIF payments never arrive on the same date.

  1. Ok, I lied, it’s not exactly the same. I decided I didn’t like the D/D’ arrows in the original post since it wasn’t 100% accurate. ↩︎
  2. And usually, the first one listed is the only one sold. My spreadsheet can handle the scenario where there’s not enough shares held to meet the amount I’m requesting. ↩︎
  3. The macro mostly just makes static copies of these values (aka “squirrels away”) and puts them in known places so I can perform other calculations on them. Since my retirement spreadsheet uses live market data — delayed by 20 minutes, that’s what you get for relying on googlefinance(), the value of things is constantly changing. If I didn’t make static copies, it would make it hard to perform consistent calculations. ↩︎
  4. The value of my cash cushion is dependent on the USD/CAD rate since the majority of my holdings there are in USD since the interest rates are better. ↩︎
  5. It doesn’t actually need to do this for my Wealthsimple RRIF since I’m permitted to sell a dollar amount of assets instead of a number of shares with Wealthsimple’s trading tool. Handy, that. But I haven’t yet made the change to the macro. ↩︎
  6. It’s always XGRO I sell since that’s the majority CAD holding in each of the 5 RRIF accounts ↩︎
  7. My spousal RRIF and my spouse’s individual RRIF are both rather modest in size and their monthly payments are sometimes covered by cash on hand. And I have cash on hand there because Questrade doesn’t offer fractional trading for CAD listed ETFs. . ↩︎
  8. My spreadsheet is fancy enough that I can sell up to 3 different non-registered assets, but only in the scenario where I reduce the holding of a given asset to 0. ↩︎