• DIY Investments

How to Calculate Your Rate of Return at Questrade

There’s that saying: time is money. It’s usually true … except, of course, when we financial eggheads whip out our Sharpies® and start blathering on about time-weighted versus money-weighted rates of return. (Speaking of “The Big Bang Theory,” check out this Dimensional Fund Advisors article about how the show’s executive producer got wise with his own assets.)

Without getting too down and dirty, money-weighted rates of return show what YOU have earned after accounting for the size and timing of your cash flows, which is probably why we advisor types are required to report them to you for each of your accounts. Your own returns could be very different from an ETF’s returns if you bought or sold your positions in an ETF at particularly good or bad times, or you’re regularly transferring assets in and out along the way.

Time-weighted returns are the kind fund managers typically report in places like their fund prospectuses and (when the numbers are pretty enough) in their advertisements. It’s how the fund performed over a specified time, such as 1, 3, 5 or 10 years. It’s also the best way to determine how your whole portfolio is doing, relative to a suitable benchmark. The problem is, you need daily portfolio values in order to calculate it, and most DIY investors do not have access to these.

For a “good enough” solution to benchmarking your portfolio’s return, there’s the Modified Dietz method. I know, the name is wonky, but it’s basically a combination of the two returns above (and it only requires month-end, not daily, portfolio values). As long as there haven’t been relatively large contributions or withdrawals to or from the portfolio (combined with volatile stock market returns during the year), the monthly Modified Dietz return should closely approximate your portfolio’s time-weighted rate of return.

 

Calculating Your Modified Dietz Rate of Return at Questrade

Fortunately, I’m here for you, with a step-by-step tutorial on how to calculate your Modified Dietz Rate of Return at Questrade. And now, you’ve got two choices for your learning pleasure: You can continue reading this blog, or check out my video of the same.

 

Ready to get started? I’ve broken it into six steps.

 

Step 1:  Download Our Free Calculator

First, visit canadianportfoliomanagerblog.com to download my free rate of return calculator. Hover over the DIY Investor’s Toolkit tab at the top right of the screen, and then click on Calculators.

Click on the Download Calculator button underneath the Modified Dietz Rate of Return Calculator description. You can also save the file to your desktop or another location.

 

Step 2:  Fill in the Desired Timeframe

Under the Year column, we’ll enter 2016 in the empty cell to the right of the first December month-end. We’ll then enter 2017 into any remaining unlocked cells in the Year column. (Of course you’d adjust these timeframes if you’re doing this in, say, 2021.)

 

Step 3:  Enter Your Monthly Account Balances Into the Calculator

Next, log into the Questrade online platform. From the Accounts section, hover over the Reports tab and click on Statements.

Using the drop-down menu, select the first account for which you would like to calculate a rate of return. In our example, this will be the RRSP account.

Next, using the arrows located at the left and right of the screen, locate the December statement for the year prior to the year you want to calculate. For example, since we are calculating the 2017 rate of return, we will scroll to the December 2016 statement. Click on the calendar box, and then on the download icon to the right.

In the top-right corner of the statement, you’ll find the month-end December balance, which is $5,000 in our example.

Enter this amount into our Rate of Return Calculator. It goes into the Portfolio Value column of the December 2016 month-end row.

 

Step 4:  Aggregate All Your Account Balances

Now, if your portfolio includes more than one account, add together the month-end balances of all your accounts, and include this total figure in this same cell. For example, if you have an RRSP account and a TFSA account each worth $5,000 at the end of December 2016, enter $10,000 into this cell.

Repeat this process for the next 12 monthly statements.

 

Step 5:  Add Your Cash Flows

Once you’ve entered all of the month-end portfolio values into the spreadsheet, you may notice that your year-to-date return looks awesome. In our example, it’s 134.11%. Don’t get too excited, though. This is because we haven’t yet entered any portfolio cash flows into the calculator. We’ll do that now.

Hover over the Reports tab again, this time clicking on Account activity.

Using the Date range tool, select the one-year time frame you’re measuring. In our example, this will be January 1st to December 31st, 2017.

Next, ensure that only the Deposits and Withdrawals icons are selected as Activity types, since these are the only transactions you need to input into the calculator. (The icons will be filled in with colour if they’ve been selected.) When you’ve completed this, click on Export to Excel.

We’ll be using three data columns from the Excel download: Transaction Date, Net Amount, and Activity Type. Starting from the bottom row in our example, note that the first transaction occurred on January 16th, 2017. The net amount of this transaction was $500 and the activity type was a deposit, so we’ll enter this into the calculator as a positive value. Enter any account withdrawals as negative values.

The calculator allows for up to five cash flow events each month. If you’ve got more than that, consider switching all of your account deposits or withdrawals to the same day, so you can enter the total net amount into a single cash flow cell.

So, we’ll enter the $500 deposit as a positive value in the first Cash Flow column, and in the same row as the January 2017 month-end, and use the drop-down menu to select January 16th (the day the transaction occurred). Then, we’ll repeat the same process for the 11 remaining monthly deposits.

 

Step 6:  Voila … You’ve Just Calculated Your Portfolio-Wide Return!

Now that you’ve completed all your inputs, the calculator provides you with your accurate return over the timeframe you’ve specified. In our example, our portfolio returned 8.94% for 2017.

That’s nice. But how does it compare to the “suitable benchmark” I mentioned at the outset? In my next blog/video combo, I’ll show you how to benchmark your Modified Dietz Rate of Return to a portfolio of suitable ETFs, so you can determine whether your own portfolio is a rock star or just humming along.

 

 

By | 2018-04-16T14:20:46+00:00 April 16th, 2018|Categories: Uncategorized|8 Comments

8 Comments

  1. Rob32 April 17, 2018 at 7:14 pm - Reply

    “The problem is, you need daily portfolio values in order to calculate it, and most DIY investors do not have access to these.”

    I use RBC’s Direct Investing, which updates portfolio values daily. Surprised this is not standard practice.

    • Justin April 17, 2018 at 8:06 pm - Reply

      @Rob32: I should have been more clear. To calculate their time-weighted rate of return, DIY investors would need the ability to generate their portfolio value on any historical day.

      They could login to their online access whenever they make a contribution or withdrawal to their portfolio (and keep a record of their portfolio value after the contribution or withdrawal has been made), but this is not a practical solution.

  2. CG April 17, 2018 at 5:31 pm - Reply

    Excellent! This is so useful thanks for posting!

    • Justin April 17, 2018 at 5:34 pm - Reply

      @CG: Of course – it was my pleasure!

  3. Bruno April 17, 2018 at 4:37 pm - Reply

    I love these step-by-step videos. They are so useful! Thank you for sharing your knowledge, Justin.

    • Justin April 17, 2018 at 4:40 pm - Reply

      @Bruno: You’re very welcome! We have a few more videos that are almost complete – they should be released over the next month or so.

  4. Bjorn April 17, 2018 at 2:52 pm - Reply

    Your spreadsheet for this is great. I fill it in every month and keep track of things along the way.

    • Justin April 17, 2018 at 2:53 pm - Reply

      @Bjorn: I’m so glad you find it useful 🙂

Leave A Comment