Tag: anthropic

a man with bruised knuckles having a headache

The ongoing struggle to simplify getting paid in retirement

RobHLeave a comment

Last week, I sat with my spouse and let her take the wheel in performing the steps to getting paid in retirement1. And although I’ve built an impressive2 set of tools and spreadsheets in an effort to make the steps easy to follow, it’s clear the process involves too many logins, too many screens, and too many manual steps to make this a true DIY project for my spouse. I’ll list a few of the issues I’m facing here.

RRIF withdrawals are automatic. Cash availability is not.

Problem: Both Questrade and Wealthsimple allow the recurring withdrawal of RRIF payments on a monthly basis. Both assume that I have taken steps to ensure that cash is available to enable that withdrawal.

I initially thought that Questrade’s Flow feature was going to solve this problem for me. And, in theory, it could. There are practical limitations with Flow right now that prevent me from using this in its current state, but at least the product team is listening to feedback.

One other possibility came to the forefront of my crowded mind courtesy of a recent post by one of my favourite bloggers, The Loonie Doctor. BMO’s Target Cash Flow ETFs were discussed last year in ZGRO versus ZGRO.T, and I did mention that ZGRO.t would actually be a pretty good idea in a RRIF. ZGRO.t provides monthly payouts (currently targeting a 6% yield) and it pays them out on the 2nd working day of every month:

From https://bmogam.com/ca-en/products/exchange-traded-fund/bmo-growth-etf-target-cash-flow-units-zgro-t

In order to take advantage of this, I’d have to

  • confirm that the monthly payout from ZGRO.t would cover my RRIF minimum payments in each RRIF account
  • convert my XGRO into ZGRO
  • turn off DRIP for ZGRO in my RRIF account
  • monitor cash in RRIF accounts to deal with excess cash

I did a quick check; unfortunately this wouldn’t work in all my RRIF accounts. The current payout of $0.058/unit wouldn’t be enough to cover RRIF minimums in every RRIF account I have. So unfortunately, this isn’t an option either.

Anthropic’s Claude is another possible pathway but it’s limited to Questrade. Most of my monthly payments use Questrade, but there is that one Wealthsimple RRIF account I still have. I could bring that account to Questrade, but I like keeping an eye on a few brokers to make sure I’m getting a good user experience.

But a bigger problem is the non-registered account portion of my monthly salary

My RRIF is only paying about 35% of my monthly salary. The rest comes from two non-registered accounts held by me and my spouse. These accounts will hang around for at least a few more years; the current decumulation is shown in the chart below:

It’s clear my non-registered accounts will be hanging around for a while yet.

What I choose to sell every month in my non-registered accounts depends on:

  • How far my asset allocations have drifted from their targets: most of my holdings in the non-registered account are a single asset class (Canadian equity, US Equity, International equity) so if any of those asset classes get too large, that’s a factor to consider
  • What my forecast is for my net income versus that of my spouse: this is the more important consideration since it impacts my tax bill. The idea is to keep our net incomes as close as possible. Capital gains are realized every time a sale in made in the non-registered account, but if I’m careful, I can split those capital gains such that our net income becomes pretty close by the end of the year3. Right now, I’m playing catchup — my spouse’s net income is currently forecast to be below mine, so I need to generate capital gains from her investments for the remainder of the year.

And then, there’s the broker UIs

Questrade is terrible when it comes to trying to use one login to do trades. Accounts for which you have trading authority are only visible for trading if you use the Questrade Edge interface, which is a lot less welcoming than the default web interface.

And then there are the infuriating limitations placed on trading authority. This is only a problem when we have to use my spouse’s non-registered accounts to pay our monthly salary.

  • You can’t move money between accounts unless you are the primary owner. For joint accounts on Questrade, that effectively means one spouse (the secondary owner) can’t get money out of a jointly held account. And since my monthly routine generally makes changes to our jointly held cash-cushion, I have to be the one to make those changes, or I have to do weird things like moving money out of Questrade to a bank account, and then moving money back in. It’s so silly.
  • Trading authority does not extend to withdrawing money. So if we need to sell my spouse’s non-registered investments, I can. make the sale, but then my spouse has to login with her own credentials to actually withdraw the money.

Wealthsimple has recently added trading authority support, but I haven’t tested what can and can’t be done from this feature.

I don’t have answers to my issues at this moment in time. I will have to continue experimenting; I will spend some time revisiting passiv.com to see if that makes things better.

  1. The monthly steps are described in detail over at The Mechanics of Getting Paid in Retirement: 2026 Edition ↩︎
  2. To me, at least ↩︎
  3. I use https://moneyengineer.ca/tools-i-use/#:~:text=Canadian%20Tax%20Calculators to help me figure this out ↩︎

a robot holding a cup

Questrade: Custom Indexing extends to CAD stocks, more AI platform support

RobHLeave a comment

Questrade has been beavering away on a raft of new features, some of which were promoted with great fanfare in an online event last month. I covered that in some detail in a previous post. There are already some significant developments to these features so I thought I’d mention them here so you have the latest view.

Custom Indexing now includes Canadian Equities

Custom Indexing, in Questrade’s estimation, allows you to

“Combine the control of picking stocks with the ease of owning ETFs to put your own spin on the market. Then, keep the whole thing in sync with one click.”

Questrade website: Custom Indexing

Custom Indexing wasn’t actually part of last month’s event, but was quietly released earlier in the year. I covered its first release in this post. In essence, it gives you the ability to create your own all-in-one fund. In its first release, I thought it showed promise but as it only permitted the inclusion of US Equities, the feature was of limited use to most people. (Including me, since I’m nearing the end of my multi-month initiative to kick USD out of my retirement portfolio.)

Now that Custom Indexing supports Canadian equities, you can build your own all-in-one fund, and save on the additional management fees these funds typically attract (I broke down how much a fund like XEQT costs in a previous post). It’s quite easy to set up, I built an equivalent to XEQT in about 5 minutes using its underlying funds (XTOT, XIC, and XEF). And with one click you can reset the desired percent allocations of each fund)1.

I could see using this in my TFSA accounts as a result; I’d really like to use this in my RRIF accounts, but you can’t have a RRIF that uses custom indexing, inexplicably.

Questrade’s MCP expands

If you missed it, the MCP is what allows your Questrade accounts to be connected to an AI platform. I’ve been experimenting with Anthropic’s Claude. I talked about my experiences using it previously. But already it’s expanded in scope.

  • The MCP now supports ChatGPT, Cursor, Codex and VS Code
  • The MCP now supports trading — all trades have to be approved via push notification

I continue to tinker with this feature. There’s a lot of promise here to get rid of some of the manual tasks I have to execute on a monthly basis. Using free versions of these AI platforms is in itself a bit limiting2, but since I’m still learning, I don’t mind.

  1. For longtime Questrade customers, this will seem eerily familiar; “one click rebalancing” is one of the features of Passiv Elite, a service that used to be offered gratis to Questrade users. ↩︎
  2. For example, I can’t connect both my wife’s Questrade accounts and my Questrade accounts to the same instance of Claude without paying for a Claude subscription. But I can use multiple AI programs, no big deal. ↩︎

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

rocket launch space discovery

SpaceX and index investing

RobHLeave a comment

This Friday (June 12, 2026) SpaceX (which, as it turns out, doesn’t just make rockets — it also encompasses Starlink and Twitter — er, X) will launch its mega-IPO. It’s expected to immediately become a top 10 company in terms of market capitalization, putting it in the same stratosphere as Nvidia, Apple, and Microsoft.

There’s a lot of chatter over how (and even if) this will impact the boring old index investor. It might help to review what the major US Indices are. The major US indices1 that show up again and again in ETFs are

  • S&P 500 — this is the index used by ETFs like VFV, XSP, ZSP and HXS
  • S&P Total — this is used by XEQT/XGRO2 and AOA3
  • Nasdaq 100… includes ETFs like XQQ, ZQQ, HXQ4
  • The Solactive US Large Cap Index5: TPU aka TEQT
  • CRSP US Total Market Index — VUN, VUS and VEQT for example

The ETFs that track indices don’t have discretion over when or if to include a stock in their ETF. When the index changes, so does the ETF. It’s totally mechanical. The indices also have published rules on how and when to include stocks, but because SpaceX is anticipated to be so exceptionally large, there was pressure on the index providers to tweak their rules to make sure SpaceX was included. If you’re keeping score, only Nasdaq made changes to accommodate SpaceX. S&P did not.

After much anticipation, here’s the state of play as of June 9, 2026:

IndexSpaceX included when?How much?
S&P 500 (VFV, XSP, ZSP, HXS)>1 year from now6Float-adjusted, as usual
S&P Total (XEQT/XGRO, AOA)Once 10% float achieved…a quarter or two?Float-adjusted, as usual7
Nasdaq 100 (XQQ, ZQQ, HXQ, QQQ)Shortly after IPO…15 trading daysBased on full market cap, as usual
Solactive US Large Cap (TPU, TEQT)Next quarterly reviewFloat-adjusted
CRSP (VUN, VUS, VEQT)Shortly after IPO…5 trading daysFloat-adjusted

Many of the indices use the float-adjusted amounts; this means a lower weighting for SpaceX than its full market-cap, which means a lower weight in any index that uses float. In the coming months, I’ll take a peek at how much SpaceX I hold, and how it’s changing, just for my own education.

So, for me, it looks like I’ll be owning some SpaceX in the not-too-distant future since the vast majority of my US holdings are in XEQT/XGRO/AOA. And, the odds are, it will lose value post IPO. That kinda sucks.

Of course, as BMO correctly points out, nobody will be immune from this kind of market movement — why, you may ask? Given SpaceX is going to be included in the popular Nasdaq 100, funds that mirror this index are going to have to make room for the new arrival, selling off shares of things they already hold, like Nvidia, and Microsoft. This will create downward pressure on the prices of these tech stocks, and hence it will also create downward pressure on any ETF that also holds Nvidia, and Microsoft. The S&P 500 holds many of the Nasdaq 100 companies, so you can expect some price erosion of ETFs mirroring the S&P indices as the Nasdaq ETFs do their rebalancing act.

In the grand scheme of things, I don’t think I really care. I don’t love SpaceX, or any other stock for that matter. The S&P indices have historically rewarded the patient investor, and I see no reason to change my strategy based on one IPO, no matter how splashy. It won’t be the last — both Anthropic and OpenAI are probably close behind with their IPOs.

  1. The small cap Russell 2000 is also popular, but I don’t mention it in the main list since SpaceX is too big to be a small cap ↩︎
  2. This is a CAD ETF and holds things beyond “just” the S&P index. See more here. ↩︎
  3. This is a USD ETF, and holds things beyond just the S&P index. See more here. ↩︎
  4. The most famous Nasdaq 100 ETF trades in USD and is QQQ. This would explain the not-very-original names chosen by the Canadian management companies. ↩︎
  5. I think only TD uses this one, but since I’ve written about TEQT in the past, I figured I’d include it. ↩︎
  6. and likely longer, since there is a profitability screen imposed as well for inclusion in the S&P 500 ↩︎
  7. Over time, the size of the SpaceX float is expected to increase as insiders unload their shares; the timing of this is not known. I’d expect the SpaceX % to increase over the first year of inclusion on the S&P Total index. ↩︎