The Complete List of TSX 60 Stocks [Free Excel Download] Sure Dividend

Sure Dividend

High Quality Dividend Stocks, Long-Term Plan
Newsletters & CoursesMember's Area

The Complete List of TSX 60 Stocks


Published on January 26th, 2018

The TSX 60 Index is a stock market index of the 60 largest companies that trade on the Toronto Stock Exchange.

Because the Canadian stock market is heavily weighted towards large financial institutions and energy companies, the TSX is a reasonable benchmark for Canadian equities performance. It is also a great place to look for investment ideas.

You can download a database of the companies within the TSX 60 below:
 

The TSX 60 Stocks List available for download above contains the following information for every security within the index:

All of the financial data in the database are listed in Canadian Dollars. Keep reading this article to learn more about maximizing the power of the TSX 60 Stocks List

How To Use The TSX 60 Stocks List To Find Investment Ideas

Having an Excel document that contains the names, tickers, and financial data for every stock within the TSX 60 Index can be extremely useful.

This document becomes even more powerful when combined with a fundamental knowledge of how to use Microsoft Excel to implement rudimentary investing screens.

With that in mind, the following tutorial will show you how to implement two useful investing screens to the TSX 60 Stocks List.

The first screen we’ll implement is for TSX 60 stocks with price-to-earnings ratios below 20 and dividend yields above 2%.

Screen 1: Price-to-Earnings Ratios below 20 and Dividend Yields Above 2%

Step 1: Download the TSX 60 Stocks List by clicking here.

Step 2: Click the filter icon at the top of the price-to-earnings ratio column, as shown below.

TSX 60 Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Less Than” and input 20 into the field beside it, as shown below. This will filter for TSX 60 stocks with price-to-earnings ratios less than 20.

TSX 60 Stocks Excel Tutorial 2

Step 4: Close out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Then, click the filter icon at the top of the dividend yield column, as shown below.

TSX 60 Stocks Excel Tutorial 3

Step 5: Change the filter setting to “Greater Than” and input 0.02 into the field beside it. This will filter for stocks within the TSX 60 Index with dividend yields above 2%.

TSX 60 Stocks Excel Tutorial 4

The remaining stocks in this spreadsheet are TSX 60 Index constituents with price-to-earnings ratios below 20 and dividend yields above 2%.

The next screen that we’ll implement is for TSX 60 stocks with market capitalizations above $30 billion and returns on equity exceeding 15%.

Screen 2: Market Capitalizations above $30 billion and Returns on Equity above 15%

Step 1: Download the TSX 60 Stocks List by clicking here.

Step 2: Click on the filter icon at the top of the market capitalization column, as shown below.

TSX 60 Stocks Excel Tutorial 5

Step 3: Change the filter setting to “Greater Than” and input 30000 into the field beside it. This will filter for TSX 60 Index constituents with market capitalizations exceeding $30 billion.

TSX 60 Stocks Excel Tutorial 6

Step 4: Exit out of the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner). Then, click on the filter icon at the top of the return on equity column, as shown below.

TSX 60 Stocks Excel Tutorial 7

Step 5: Change the filter setting to “Greater Than” and input 0.15 into the field beside it. This will filter for TSX 60 Index constituents with returns on equity exceeding 15%.

TSX 60 Stocks Excel Tutorial 8

The remaining stocks in this spreadsheet are members of the TSX 60 Index that have market capitalizations above $30 billion and returns on equity above 15%.

You now have a solid understanding of how to use the TSX 60 Stocks List to implement insightful investing screens.

To conclude this article, we’ll share other Sure Dividend resources that you can use to enhance the quality of your investing due diligence.

Final Thoughts: Other Dividend Growth Investing Resources

The TSX 60 Index contains the 60 largest companies that trade on the Toronto Stock Exchange. Because of its exclusivity, it does not contain all of the Canadian stocks.

For investors interested in achieving some Canadian exposure within their investment portfolios, we recommended sifting through the broader S&P/TSX Composite Index, which you can access below:

Sure Dividend also maintains several databases of other international stock market indices. These resources are accessible below:

Alternatively, you may search through these databases and determine that investing in international stocks is not for you. Sure Dividend provides a number of databases of domestic-only stock market indices. You can access each of these databases below:

Sure Dividend has also created databases of domestic stocks by sector, which we update monthly. These sector-specific stock market resources can be accessed below:

Our last group of stock market databases contains securities that meet certain requirements when it comes to dividend payout schedules, dividend yields, corporate history, or legal structure. Consider this a catch-all for the Sure Dividend databases that do not group nicely with our other resources:

Thanks for reading this article. Please send any feedback, corrections, or questions to support@suredividend.com.


More from sure dividend
Newsletters & CoursesMember's Area