Menu
sharewise sharewise
Log in
Sign up
Log in
Sign up
Microsoft strongly encourages users to switch to a different browser than Internet Explorer as it no longer meets modern web and security standards. Therefore we cannot guarantee that our site fully works in Internet Explorer. You can use Chrome or Firefox instead.

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

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

Published on January 26, 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:

 

Click here to download your S&P/TSX Composite Index stocks list now.

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

  • Name
  • Ticker
  • Stock Price
  • Dividend Yield
  • Market Capitalization
  • Price-to-Earnings Ratio
  • Price-to-Book Ratio
  • Return on Equity

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:


Source: suredividend

Like: 0
Uncategorized
Share

Comments

Not a member yet? Sign up for free!