Category: Tools

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

abandoned plane wreck on icelandic landscape

PortfolioPilot Review: Any better?

RobHLeave a comment

I last took a look at PortfolioPilot a year ago, and since their email frequency seems to have ticked up, I figured I’d give it another look.

If you don’t feel like looking at the old review, the TL/DR is “good promise, errors in the data make me hesitant to recommend it”.

And guess what? Nothing has changed in that regard. All the lovely formatting in the world, all the tailored recommendations, all the graphs and charts are pretty much useless if PortfolioPilot can’t accurately reflect what’s underneath the ETFs in my portfolio. 

And, as I’ll show with a few examples, both of which I reported to support, the errors are not minor.

Now, bear in mind that I’m a big fan of all-in-ones, and these are essentially “funds of funds”, so if you DON’T hold these kinds of assets, then your perception of PortfolioPilot’s usefulness might be quite different. For me, if PortfolioPilot doesn’t have an accurate handle on what I actually own, it can’t have an accurate handle on anything else: the risk calculations, the forecasts, the recommendations — all are suspect.

Problem number 1: PortfolioPilot doesn’t know what’s in XGRO

So here’s the breakdown PortfolioPilot shows when you give it a portfolio with just XGRO in it:

PortfolioPilot’s Assessment of the “By Holdings” look-through of XGRO

The first few entries are accurate, per the XGRO product page. As of April 17, 2026, it reports:

  • 36.31% in ITOT, the iShares Core S&P Total US Stock Market1
  • 20.31% in XIC, the iShares Core S&P/TSX Capped Composite2
  • 20.21% in XEF, the iShares Core MSCI EAFE ETF3

So it’s got about 3/4 of the holdings right so far. PortfolioPilot now reports that XGRO holds 12.3% in a BondBloxx ETF. This is dead wrong. I’ve never heard of it, and “BB rated USD High Yield” sounds rather speculative, not something I’d want to invest 10% of my hard-earned money in. How can this kind of error creep in? My friend google gives a hint for those in the know:

Google Gemini’s take on BondBloxx BB Rated HY Corporate Bond ETF

The clue? The symbol of this ETF per Google Gemini is “XBB”. XGRO does not hold XBB on any US market4. XGRO does, however, hold XBB.TO, which, admittedly, is also a bond fund, but its description is a lot more boring:

Why XBB? Low cost, broad exposure to the Canadian investment grade bond market

XBB by Bondbloxx is clearly a much different animal than XBB by Blackrock, and that’s a pretty big miss.

There’s more to shake your head at, though. PortfolioPilot has “other equities” sitting at 7% of the portfolio. This is also wrong. XGRO is an 80/20 fund, which means it’s 80% equity. 75% of it we’ve already talked about (ITOT, XIC, XEF), and the other 5% is the next line in the PortfolioPilot report, namely XEC, the iShares MSCI Emerging Markets fund. So by PortfolioPilot’s estimation, XGRO is about 88% equity, which is off by 8 percentage points.

Anyway, two pretty serious errors for a fund that makes up 15% of my retirement portfolio.

But perhaps it’ll do better with a fund based in the USA?

Problem #2: PortfolioPilot doesn’t know what’s in AOA either

AOA is even a more important fund for me at the moment: it’s 50% of my portfolio, give or take. So what does PortfolioPilot have to say about what’s underneath?

PortfolioPilot’s Assessment of the “By Holdings” look-through of AOA

I don’t really know where to begin with this breakdown. Perhaps it’s faster to point out what it has right:

  • iShares US Aggregate Bond ETF (IUSB) percentage is correct

The rest is pretty much random:

  • PortfolioPilot claims the top holding of AOA is a Vanguard fund. Given that AOA is a product of iShares (a major competitor of Vanguard) this seems rather unlikely. And it is, I assure you, completely wrong.
  • PortfolioPilot correctly says that AOA holds the S&P 500 ETF (IVV) but the percentage is totally wrong. Per the AOA product page, it sits at about 45%
  • The other three major holdings (namely “other”, iShares Real Estate and SPDR Gold) are all wrong. AOA holds none of these.

Of course, my test is a very small sample, but important to me. If you do use PortfolioPilot, I’d make very sure that it accurately reflects what you actually own; otherwise the rest of the service cannot possibly work correctly. I’ll let you know if/when the situation at PortfolioPilot changes, but until it does, I’m not trusting it even at its free tier.

  1. AKA “US Equity” to my way of thinking of asset allocation ↩︎
  2. AKA “Canadian Equity” ↩︎
  3. AKA “International Equity” ↩︎
  4. Recall that PortfolioPilot is a US based tool that happens to support Canadian-listed ETFs, but to find them you have to add “.TO” to the end of the Canadian symbol ↩︎

MyACB: A new ACB Tool

RobHLeave a comment

ACB stands for “Adjusted Cost Base”, and is something you need to care about if you have non-registered stocks/ETFs that you buy and sell. If you don’t track your ACB, you can’t calculate the capital gains and losses for a given asset sale.

“But that’s what the T5008 is for, isn’t it?”

Theoretically, yes, but online brokers are notoriously sloppy with tracking ACB and hence your T5008 may not track capital gains properly. Some common reasons why this is are:

  • You hold the same asset at multiple brokers (or even within multiple accounts at the same broker). The CRA doesn’t care where you own the asset, they only care that you own the asset. No matter how many ways and in how many accounts the asset is sliced, CRA considers there to be only one ACB for all of them.
  • You move the asset from one broker to another and the ACB gets set incorrectly by the receiving broker
  • Your asset is priced in USD and your broker is using a different FX rate from you1
  • Your asset delivers a return of captial (RoC for short) which lowers your ACB (and increases future capital gains); your broker may or may not track this on your behalf
  • Your asset reinvests dividends into the fund (this sounds the same as a DRIP, but it isn’t — it’s commonly known as a “phantom distribution”). This increases your ACB.
  • Your asset undergoes a share split or share merge.

For these reasons, I don’t trust T5008s, and I track my own ACB. In Tools I Use I mention the ACB tool I use; it’s the one I have been using for many years now, namely Adjusted Cost Base. (Before that I think I used an Excel template…which I converted to ClarisWorks format, but I digress…)

I use the free version of Adjusted Cost Base because it suits my needs, and I wasn’t aware of a reasonable alternative, and I’m a cheapskate. But it seems there is one now — MyACB. I gave MyACB a quick spin this week, here’s how it compares to Adjusted Cost Base, both in “Free” mode:

User InterfacePortfolios Automated FX Automated RoC and phantom distributions Import from other sourcesPay models
Adjusted Cost Base Not pretty; subscription eliminates ads– two; 5 with subscriptionNoNo, requires subscriptionNo, requires subscription$49/year
MyACB Pretty– one; 5 with family subscription,
100 with “pro” subscription 		YesFor one asset only; more assets require subscriptionYes$29/year for family

$99/year for pro2

User Interface

Adjusted Cost Base won’t win any graphic design awards3. The design is functional but not at all modern looking. MyACB looks like a modern website. Dark mode? Check. Logical layout? Check. And at present, MyACB is ad-free4.

One big thing MyACB does better than Adjusted Cost Base is its support for editing portfolios, specifically related to deleting symbols. It’s far too easy to accidently trash an in-use symbol in Adjusted Cost Base. MyACB makes it very clear how destructive your desired action will be and asks for a specific and impossible-to-click-too-fast confirmation!

Portfolios

Tracking ACB for me means tracking it in my account, my spouse’s account, and our joint account. So that’s three portfolios. And I try to hold different assets in different portfolios to avoid raising the CRA’s ire.

Anyway, my three portfolios exceed the “free” capacity of both products; I get around the restriction by having my spouse have her own Adjusted Cost Base account to track her portfolio. Not a big deal, just a minor inconvenience. With MyACB it would be a bit trickier.

Once nice thing that MyACB does here is support for a “Group” of portfolios. This allows for a user to have multiple portfolios at multiple brokers to keep an eye on superficial losses. I wasn’t able to test this function, since MyACB is limited to one portfolio in the free version. But I can see it as being useful. (In my case, as an Adjusted Cost Base user, I just merge all my transactions across multiple accounts into one portfolio and achieve the same result. The MyACB model is cleaner and more useful).

Automated FX

Since I trade in both USD and CAD, I need to know what the CAD<->USD exchange rate is on day of settlement5. If you only hold CAD-denominated assets, then this won’t matter to you.

Here the free version of MyACB wins hands down. MyACB will do FX calculations for you by looking up the FX rate on the day of settlement. This is a something Adjusted Cost Base makes you enter manually.

Automated RoC and phantom distributions

ETFs have a habit of using these means of distributing money to their unit holders. I’m no tax accountant, but you can read all about these weird distributions over on both of the websites

Both tools offer support for these, no issue there. I’ve been tracking these distributions in Adjusted Cost Base for years.

MyACB adds a small teaser in the free version that allows you to automatically add these transactions for any ONE asset in your portfolio6. So if your non-registered account has one asset, this might be construed as useful. For me, and my 10 different non-registered assets, it’s merely an effort to entice me to pony up and pay for the family version of MyACB. Anyway, I tried it out and it performs as advertised, and is an exceedingly useful feature, but in the free version, it’s really just a way to kick the tires for most of us.

But compared to the free version of Adjusted Cost Base, one thing missing is support for multiple portfolios. Adjusted Cost Base’s free version supports two portfolios. I actually need three portfolios: one for my account, one for my spouse’s account, and one for our joint account. To get around that restriction, my spouse tracks her portfolio in her own Adjusted Cost Base account.

.

Import from other sources

Adjusted cost base doesn’t offer this in their free version, but it’s in the subscription version.

MyACB allows this in the free version, not too surprising, since it’s the new kid in town. The feature seems well thought out, and includes contributions from others (“schemas”) to save you time in figuring out how to map fields to MyACB.

I did try to do an export from Adjusted Cost Base to MyACB and ran into a few problems:

  • The way splits are modelled in the two platforms is different. MyACB puts the split ratio in a dedicated field, whereas Adjusted Cost Base puts in two places — once in the Transaction field and once in the Shares field. A bit of Google Sheets post-processing can fix this, but this may be a problem for a user less familiar with string manipulations.
  • In MyACB, the ticker symbol is mandatory, whereas in Adjusted Cost Base it isn’t.
  • Adjusted Cost Base doesn’t call out the currency used, just the exchange rate, and a “yes/no” if it’s a foreign currency transaction. MyACB stores the currency “kind” (e.g. USD, EUR etc). Again, a minor difference, but one that requires some thought as to how to covert one to the other.

Am I switching?

For the moment, no. Adjusted Cost Base meets my needs, and it would require some work for me to move to MyACB. To get the most out of the switch, I would have to pony up for a family plan given the portfolio limitations in MyACB’s free version. If you’re just starting out in getting help with your ACB tracking, either tool will meet your needs. MyACB has some nice features in the free version (automatic FX lookups, transaction importing) that warrant giving it a close look.

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

  1. There’s more than one acceptable way to do this. What I do is find the Bank of Canada rate on the settlement date and use that. ↩︎
  2. “Tax pros” is an assumption on my part. I don’t see how even the most dedicated DIYer has a need for 100 portfolios… ↩︎
  3. I see that the top hat guy for Adjusted Cost Base’s logo has had a makeover; he looks a little less scary and seems to have given up cigars. ↩︎
  4. I do respect the need for content creators and developers to be compensated somehow for the work they do. The ads on Adjusted Cost Base are quite prominent and can be quite distracting. ↩︎
  5. You track your ACB in Canadian dollars, always. And you convert each transaction — buy or sell — to CAD. ↩︎
  6. The UI to do this is a bit (uncharacteristically) clunky, in my view — you can only import one year of transactions at a time, which gets tedious pretty quickly. ↩︎

Wealthsimple: Tax mini-review

RobHLeave a comment

Ah, Tax Season. No surprise — I do my own taxes. I have been the “tax man” for many years, filling out taxes for me and my spouse, my parents (when they were alive), my mother-in-law…

For many years, I used TurboTax as my go-to software, taking advantage of the annual discount rate offered to CIBC customers. I include this research should any of you (a) bank with CIBC and (b) use TurboTax (which used to be called QuickTax).

Anyway, I don’t use TurboTax anymore. TurboTax had a nasty bug a few tax seasons ago related to Final Returns (I was filling out my late father’s final tax return) and after spending several hours with support, who ultimately admitted there was some bug, advised me to direct a call to the developer line and explain the problem to them — from scratch — I was less than impressed. And this after enduring yet another price increase (usually hidden as “upgrades” to do simple tasks, like add capital gains) I decided to look elsewhere for my tax filing needs.

I think it was a Rob Carrick column1 that advised me that upstart Wealthsimple offered tax software which was free2. As a certified cheapskate, “free” was certainly a price I could get behind. And so I gave it a try a few years ago.

I think Wealthsimple uses Tax as a loss-leader to get you started on their platform. It certainly worked that way for me. I started using just Tax, then added a prepaid Mastercard (no-fee FX), then added an RRSP/RRIF account (to get a new laptop), now a few savings accounts, investment account, Wealthsimple Visa card….

Anyway, you might be dubious about a free product, but it works great. It supports everything you would expect including auto-fill, eFile, saving information across tax years so you don’t have to type excessively, support for joint filing with your spouse…I’ll note that my tax needs are relatively simple: T4s, T5s, T3s, plenty of non-registered stock sales that generate capital gains and losses…Compared to QuickTax, Wealthsimple Tax is a little less user-friendly but a little easier to skip around. It didn’t take long for me to find my way around.

The hidden cost? You have to setup a login with an email address, and this will generate Wealthsimple marketing emails, which may or may not be welcome3. The Recommendations section includes helpful tips aka upsell opportunities like opening a TFSA to avoid paying tax on bank interest. But to me, it’s a fair trade.

  1. Mr. Carrick now has a Substack too. Retirement for him I guess means “doing the same stuff I did before without deadlines”, which is good news for the DIY investor. ↩︎
  2. Wealthsimple added Tax to their lineup back in 2019 with the acquisition of SimpleTax, a product some of you may know…? ↩︎
  3. I do like their Monday newsletter called TLDR. ↩︎

Top Five Money Engineer posts of 2025

RobHLeave a comment

The Money Engineer launched in January 2025 and according to the WordPress stats, I made 144 posts last year. What were the most viewed posts of 2025?

5th-ranked post of 2025: ZGRO versus ZGRO.T

ZGRO versus ZGRO.T: what’s the difference?

I got wind of ZGRO.T through Reddit, specifically r/CanadianInvestor. ZGRO and ZGRO.T are both all-in-one asset allocation ETFs from BMO, but with vastly different yield characteristics. I was confused, but in the end, decided that ZGRO.T was probably not a bad pick for use in a RRIF account as it might save you the hassle of selling shares. Their TOTAL returns (assuming all dividends are invested) are effectively identical.

4th-ranked post of 2025: Spousal RRIF Attribution Rules

Caution! Spousal RRSP/RRIF Attribution Rules

I think I was first warned about this nuance of spousal RRSPs/RRIFs by my DIY neighbour (thanks, Steve) and is the main reason I’m only drawing RRIF minimum for the next two years1. I think most of the visits to this article were search-driven. Either that, or people came to admire what might be my favourite article thumbnail2 I’ve posted thus far.

3rd-ranked post of 2025: Norbert’s Gambit with Questrade

Questrade Example: Exchanging USD/CAD with Norbert’s Gambit

As someone who holds more USD-denominated assets than might be wise, I do very much appreciate the existence of a cheapskate way of converting between USD and CAD assets. I think I first learned about this trick via The Loonie Doctor’s blog. The #3 blog entry explains how it works if Questrade is your broker. I would also recommend https://moneyengineer.ca/2025/08/21/tracking-norberts-gambit-costs-with-questrade/ for a very clear picture of what it actually costs (in time and fees) to execute the Gambit: in three of four instances, the time delay of executing the gambit has worked in my favor as the FX rate has drifted a bit to my advantage.

2nd-ranked post of 2025: TD versus iShares all-in-ones

TD versus iShares: XEQT/XGRO/XBAL versus TEQT/TGRO/TBAL

I’m a fan of all-in-ones (and am a little sad https://moneyengineer.ca/2025/01/21/why-you-can-fire-your-advisor-asset-allocation-etfs/ didn’t crack the top five last year). I am genuinely puzzled why people seem to get so wound up about which family of all-in-ones to choose3. I examined TD’s only because their cost to own is a bit cheaper than iShares (who I use primarily), and I’m a cheapskate. (I studied the cost of owning an all-in-one here.) Anyway, in the end, the biggest difference is visible in TGRO versus XGRO because TGRO, unlike any other GRO ETF, uses 10% bond allocation and not 20%. This gooses its return a bit, at the cost of additional volatility. Otherwise, it’s a case of tomato/tomahto. Pick one, or pick them all, it doesn’t matter much.

Top ranked post of 2025: Mini-Review of Optiml.ca

Mini-Review: Optiml.ca

This was, as the title implied, a quick review of a made-in-Canada tool to help craft a retirement plan. And again, my DIY neighbour gave me a heads-up about it4. It got a lot of interest, probably because the kind folks at Optiml linked to my review from their website ;-). I was impressed by the completeness of the tool during my test drive, and it seems like a good and fairly priced way for a DIYer to do some validation of their retirement plan. Having validation of my plan was one of the ways I knew I could retire.

Looking forward to seeing what the 2026 list might look like! Got a topic or question? Send it along to comments@moneyengineer.ca, or comment below!

  1. RRIF minimum withdrawals are never subject to spousal attribution ↩︎
  2. Courtesy Pexels free photos, built into WordPress’ editor. ↩︎
  3. iShares, TD, BMO, Vanguard, Global X…. ↩︎
  4. Thinking he should write his own blog, maybe. ↩︎