Sometimes the simplest information is the hardest to find.
Investors used to have to wait until the annual Beating the TSX update in The Canadian MoneySaver to have access to the portfolio. Now you can find it here any time.
But what if you want the complete list of TSX 60 stocks organized by dividend yield? Perhaps you want to build a portfolio of more than ten stocks? Or maybe you just need a starting point to investigate large cap Canadian equities with characteristics other than high yield (dividend growth rate, other sectors, market cap, etc.). It would be handy to have an up to date spreadsheet to refer to, especially one that you could copy and paste into your own software.
Alas, what should be readily available to DIY investors has been irritatingly hard to find.
- TMX Money has the list of TSX 60 constituents, but lacks dividend data
- Sure Dividend has a list, but it’s out of date and requires you to give your email and download a file
- Dividendyields.org has a list which is also out of date, containing stocks that are no longer part of the TSX 60
- The Globe and Mail used to have a TSX 60 table, but stopped updating it last year
Time to fix this problem. As of today, you will be able to access the complete list of TSX 60 stocks by dividend yield right on this website from the navigation bar. Here is what I did (feel free to make your own, or just keep coming back here):
The method – updated
1.Compiled the entire TSX 60 index as a portfolio in Yahoo Finance
2.Edited the columns to include the relevant data
3. Copy and pasted this data into Google Sheets and changed the ticker symbols to the Google format: “TSE:BCE” (for example). Then made it look nice with some colours.
4. Use the following command to pull real time prices:
5. Use the following command for 52 week low:
6. Use the following formula for Change from low:
=(last price – 52w low)/(52w low)
7. Used the following command to calculate dividend yield:
=annual div/last price
8. Use the following command to pull real time market cap:
9. Used the following command to pull real PE ratio:
10. Use the following command to pull real time beta:
11. Sort the data based on dividend yield by highlighting a cell in the dividend yield column and using the “Data – Sort” function:
That’s all! It’s not rocket surgery, but no one else seems to be doing it.
Please note: This data is pulled from Google Finance and may be delayed by about 20 minutes. Also the feed may be temporarily interrupted on occasion – if it is, check back later.
Also, note that the actual dividend amounts are entered manually (unfortunately, there is no way to pull this data from Google Finance). I will endeavor to be on top of dividend raises and cuts, but if you are using this data to make investment decisions, please (as always) double check this information.