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:
 

Click here to download your TSX 60 Index stocks list now.

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

  • Stock Price
  • Dividend Yield
  • Market Capitalization
  • Price-to-Earnings Ratio
  • Price-to-Book Ratio
  • Beta
  • Return on Equity
  • 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.

    Print Friendly, PDF & Email