It’s finally here! I’m releasing my TD e-Series Excel Portfolio Tracker! When it comes to software, applications, or even spreadsheets to track your TD e-Series investments, I’ve found there is very little support on the web. I used to use Google Finance to track my portfolio, but they shut down that functionality unfortunately. Over time, I realized that the solution I was looking for to track my portfolio wasn’t out there – so I decided to make my own. After requests from many of you, I’m releasing it for download!
Version update history:
- Version 1.0 – initial release
- Version 1.1 – updated error where Canadian Index Price didn’t update properly from web
- Version 1.2 – fixed error calculating RRSP book values, added value of change of funds in 24 hours, updated error messaging on return values of holdings over time, if user hasn’t held asset for long enough
- Version 1.3 – updated parse error that was causing incorrect data to be copied to the ‘TD e-Series Price List’ sheet when automatically downloading index fund prices
- Version 1.4 – Unhid ‘Data from web’ sheet to fix Macro error, updated parse error that was causing incorrect data to be copied to the ‘TD e-Series Price Lost’ sheet when automatically downloading index fund prices.
- Version 1.5 – Updated macro to detect if there is a parse issue, and remove the extra data from the ‘TD e-Series Price List’ sheet if it starts with incorrect data.
- Version 1.6 – Updated macro to fix price list updating.
What TD e-Series Excel spreadsheet does
The excel spreadsheet I created allows you to track all of your TD e-Series transactions in both your TFSA and RRSP accounts, pull recent fund price data from the web, store information about the value of your portfolio on any given day, and show the return of your portfolio over a given period of time! The spreadsheet uses Macro’s to run a lot of it’s functionality – that’s why it is an .XLSM file extension, and that’s why you’ll need to Enable Content for the spreadsheet to work properly.
It can be a little nerve wracking enabling content on an excel file you download from the internet, but I assure you there is no funny busy with this file – all it does in the background is calculations, and connect to the web to download current fund prices.
Track your transactions
Insert all of your TD e-Series fund portfolio transactions, and the spreadsheet will calculate your total portfolio, value, and return over certain time periods:
And the spreadsheet will calculate the rest (if you’ve downloaded the most recent price data):
Display 1 or 2 accounts
You may have your TD e-Series portfolio stored in a TFSA, an RRSP, or maybe both. Use this option to select which of your accounts that you want to look at:
Download most recent price data from web with 1 click
Click the “Download recent price data” button to get price data from the last 60 days for the following funds:
- TD Canadian Index-e
- TD U.S. Index Fund – e
- TD International Index Fund -e
- TD Canadian Bond Index Fund -e
The tracker will download the data, parse the information, and add it to the overall TD e-Series price list history. This function will take a little bit of time, and will cycle through the different sheets of the excel file while it is working. You will get a message when it is all done.
Adding price data manually
If you need to add data older than the last 60 days, or just want to manually update data instead of automatically downloading it from the web – insert your own data in the TD e-Series Price List sheet, and short by date:
Disclaimers
I just want to put out a few disclaimers for those who want to use this excel sheet:
- It was built and designed in both Microsoft Excel 2013 and 2016 for Windows. I haven’t tried it in older versions of Excel or on Mac compatible version – so don’t know how well it will work if you are using those versions.
- It holds a lot of data and does a lot of calculations, so it’s not the fastest running spreadsheet. If it goes too slow for you, you can turn off “Automatic Calculations” (in the Formulas Ribbon) and only run calculations manually (Calculate Now option) when you add in new data.
- I can’t confirm that all data calculated is always correct. Price data may be inaccurate at times, and not all of the calculations and formulas have been verified. Use the data as a guide, but it may not always be 100% accurate (although it should be close).
- Please don’t re-distribute the file yourself – send friends and peers to the site to download. This gives me a better idea of how many people use it, and whether I should put more time into making it better.
- Please let me know if you have any feedback!!! Does something not work? Do you wish it calculated something that it doesn’t? This will hopefully be the first version of many!