Tag: xgro

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

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

a person is holding a package with their hands

What companies are in my retirement portfolio?

RobH1 Comment

I cover what I hold in my retirement portfolio every month (latest update is here), but as you can see, I only hold ETFs. What’s underneath the ETFs? Let’s take a look!

Calculating this is straightforward:

  1. Use the percentages I have of each ETF from the June update
  2. Look at the “Holdings” section of ETF or in the case of AOA/XGRO/XEQT, “Aggregate Underlying Holdings”1 and write down the percentages of each stock. I stopped when I accounted for 20% of each ETF.
  3. Multiply (1) by (2) and add them all up.

By doing this exercise, I can now account for the 20 companies that make up 20% of my retirement portfolio:

These 20 companies are really the tip of my personal investment iceberg — my aggregate retirement portfolio has at least 32,000 holdings, since that’s what’s actually inside AOA, the one ETF I own with the most holdings2. But the fate of these 20 companies will have an outsized influence on the overall performance of the portfolio. The only surprise for me is that there is only one company outside North America in the list. I would have expected one or two more.

It will be interesting to see what kind of differences I see once I complete kicking USD out of my retirement portfolio and go back to a list of only seven magnificent ETFs. I’m not sure there will be big changes, given that I’m keeping my asset allocations constant throughout, but I’m expecting some differences3. We’ll see come January 2027, I guess.

Just for fun, and given my recent article on the SpaceX IPO, I wanted to know how much I held of that particular company. AOA hasn’t included it yet4, but XGRO and XEQT have already. As of June 30, 0.02% of my portfolio is invested in SpaceX.

  1. In most cases, as of June 30. VFV only shows to May 30. ↩︎
  2. XGRO has 22000, for reference. I think the extras in AOA come mostly from fixed income (bond) products since they have broader geographic coverage. ↩︎
  3. The biggest changes won’t be visible since they occur in the bond side of my holdings. AOA and XGRO have very different approaches to this part of the market, but as it’s only 15% of my retirement holdings, they don’t show up as a “top” holding in my retirement portfolio . ↩︎
  4. And won’t until SpaceX is profitable. AOA includes IVV, which is an S&P 500 index fund, and the S&P 500 requires companies to be profitable before inclusion in that index. ↩︎

different flavor of pizzas on a wooden surface

News: Questrade adds fractional share support for (some) Canadian ETFs

RobHLeave a comment

“Fractional Shares” allow you to buy less than a single share of the stock or ETF that supports it. Fractional shares ensure that every last penny of cash in your account is actively invested, which, in my view, is a Good Thing. Non-interest earning cash isn’t helping you meet your retirement goals.

Questrade currently holds the majority of my retirement savings, mostly because they were offering free money last year to move accounts over to them1.

They provided support for fractional US ETFs over a year ago, to great fanfare, with Canadian ETFs “coming soon”. It would appear that “soon” is “now”. There’s no way to see which Canadian ETFs have support for fractional trading in any sort of list, but here’s the status of the Canadian ETFs on my magnificent seven ETFs list2, which you can see if you ask for a quote of any symbol you’re interested in.

ETFFractional share support?
XGROYes
XEQTYes
XICYes
VFVYes3
XCBNo
ZSTNo
ZMMKYes

I’ve tested it out, and the one flaw I’ve found is that you cannot enter a dollar amount for a trade when using the Edge Web version of the Questrade platform. You’re free to do the math yourself and enter a decimal number of shares when using Edge Web4.

Wealthsimple also offers fractional ETFs, and there I have found no restrictions. Questrade is catching up, but still behind Wealthsimple in this regard.

  1. And if you are considering Questrade yourself, you can earn a bit of free money if you use my referral code: 755609544498867 ↩︎
  2. These are the ETFs that make up the lion’s share of my retirement portfolio. ↩︎
  3. Fractional VFV is particularly valuable since its unit cost is north of $100. ↩︎
  4. Which you are forced to do if you want to make trades on accounts for which you are the authorized trader. ↩︎