S&P/TSX Composite Index Stocks [Free Excel Download] Sure Dividend

Sure Dividend

High Quality Dividend Stocks, Long-Term Plan
See 400+ Stocks Ranked in the Sure Analysis Database Premium Newsletters & CoursesMember's Area

The Complete List of S&P/TSX Composite Index Stocks


Updated on August 28th, 2018

The S&P/TSX Composite Index represents approximately 70% of the total market capitalization of the Toronto Stock Exchange despite only containing about 250 stocks.

For this reason, it is the most widely-used benchmark for Canadian equities performance. It is also an interesting place to search for investment ideas.

You can download a spreadsheet of all the stocks within the S&P/TSX Composite Index below:

 

The downloadable spreadsheet above contains the following metrics for each stock in the index:

You can view a preview of our S&P/TSX Composite Index spreadsheet below:

All figures in the spreadsheet are in Canadian dollars. Keep reading this article to learn more about how to use the S&P/TSX Composite Index to find dividend investment ideas.

How To Use The S&P/TSX Composite Index to Find Investment Ideas

Having a database that contains every security in the S&P/TSX Composite Index along with important investing metrics can be extremely powerful.

This document becomes even more useful when combined with a working knowledge of Microsoft Excel.

With that in mind, this tutorial will show you how to implement two insightful screens to the stocks within the S&P/TSX Composite Index.

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

Screen 1: Stocks With P/E Ratios Below 20 and Dividend Yields Above 2%

Step 1: Download the S&P/TSX Composite Index database by clicking here.

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

S&P TSX Composite Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Less Than” and input 20 into the field beside it, as shown below.

S&P TSX Composite Stocks Excel Tutorial 2

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

S&P TSX Composite 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 S&P/TSX Composite Index that have dividend yields above 2%.

S&P TSX Composite Stocks Excel Tutorial 4

The remaining stocks in this spreadsheet are members of the S&P/TSX Composite Index with price-to-earnings ratios below 20 and dividend yields above 2%.

The next screen that we’ll implement is for S&P/TSX Composite Index stocks with market capitalizations above $30 billion and returns on equity exceeding 15%.

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

Step 1: Download the S&P/TSX Composite Index database by clicking here.

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

S&P TSX Composite Stocks Excel Tutorial 5

Step 3: Change the filter setting to “Greater Than” and input 30000 into the field beside it. Since market capitalization is measured in millions of dollars in this spreadsheet, this will screen for S&P/Composite Index constituents with market capitalizations above $30 billion.

S&P TSX Composite Stocks Excel Tutorial 6

Step 4: Exit 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 return on equity column, as shown below.

S&P TSX Composite 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 members of the S&P/TSX Composite Index with returns on equity exceeding 15%.

S&P TSX Composite Stocks Excel Tutorial 8

The remaining stocks in this Excel sheet are members of the S&P/TSX Composite Index with market capitalizations above $30 billion and returns on equity exceeding 15%.

You now have a solid understanding of how to use the S&P/TSX Composite Index database to find investment ideas.

To conclude this article, more useful Sure Dividend investing resources will be presented to help you improve your due diligence of common stocks.

Final Thoughts

As the widest benchmark of performance for Canadian equities, the S&P/TSX Composite Index is perhaps the best place to look for investment ideas north of the Canadian-U.S. border.

With that said, this index is certainly not the only place where investors should look for international investment ideas.

If overseas exposure is something you’re looking for, the following stock market indices and databases will prove useful:

Alternatively, you may want to look within our domestic stock market indices. Sure Dividend maintains the following databases for United States securities:

We also maintain lists of companies based on their dividend characteristics. If finding high-quality dividend growth stocks is appealing to you, we recommend looking at the following databases:

You may also be interested in studying stocks from a particular sector of the stock market. Sure Dividend maintains monthly databases on the stocks in every sector of the stock market. You can access these databases below:

Lastly, you may be looking for stocks with other unique financial characteristics or corporate structures. If that’s the case, consider browsing through the following Sure Dividend databases:

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


More from sure dividend
See 400+ Stocks Ranked in the Sure Analysis Database Premium Newsletters & CoursesMember's Area