Article up to date on December eleventh, 2024 by Bob Ciura
Spreadsheet knowledge up to date day by day
The TSX 60 Index is a inventory market index of the 60 largest firms that commerce on the Toronto Inventory Alternate.
As a result of the Canadian inventory market is closely weighted in direction of massive monetary establishments and vitality firms, the TSX is an affordable benchmark for Canadian equities efficiency. It’s also a terrific place to search for funding concepts.
You may obtain a database of the businesses throughout the TSX 60 (together with related monetary metrics equivalent to dividend yields and price-to-earnings ratios) by clicking on the hyperlink beneath:
The TSX 60 Shares Record out there for obtain above comprises the next data for each safety throughout the index:
Inventory Value
Dividend Yield
Market Capitalization
Value-to-Earnings Ratio
All the monetary knowledge within the database are listed in Canadian {dollars}. Hold studying this text to be taught extra about maximizing the ability of the TSX 60 Shares Record.
How To Use The TSX 60 Shares Record To Discover Funding Concepts
Having an Excel doc that comprises the names, tickers, and monetary knowledge for each inventory throughout the TSX 60 Index will be extraordinarily helpful.
This doc turns into much more highly effective when mixed with a basic data of find out how to use Microsoft Excel to implement rudimentary investing screens.
With that in thoughts, the next tutorial will present you find out how to implement a helpful investing display for the TSX 60 Shares Record.
Excel Spreadsheet Display Tutorial: TSX 60 Shares With P/Es < 20 and Dividend Yields > 2%
Step 1: Obtain the TSX 60 Shares Record by clicking right here.
Step 2: Set the spreadsheet’s columns to filter.
Step 3: Change the filter setting for P/E Ratio to search out securities with P/E ratios between 0 and 20. It will display out detrimental P/E’ ratio shares which are a results of detrimental earnings, in addition to shares with P/E ratios of 20 or extra.
Step 4: Change the filter setting for Dividend Yield to search out securities with dividend yields larger than 2%.
The remaining shares on this spreadsheet are TSX 60 Index constituents with price-to-earnings ratios beneath 20 and dividend yields above 2%.
To conclude this text, we’ll share different Certain Dividend sources that you should utilize to reinforce the standard of your investing due diligence.
Closing Ideas: Different Dividend Progress Investing Assets
The TSX 60 Index comprises the 60 largest firms that commerce on the Toronto Inventory Alternate. Due to its exclusivity, it doesn’t include all of the Canadian shares.
For buyers excited by attaining some Canadian publicity inside their funding portfolios, we beneficial sifting by the broader S&P/TSX Composite Index.
As well as, we have now lined a number of completely different elements of investing within the Canadian market within the articles beneath:
Alternatively, you might search by these databases and decide that investing in worldwide shares shouldn’t be for you.
Certain Dividend has additionally created databases of home shares by sector, which we replace weekly. These sector-specific inventory market sources will be accessed beneath:
Our final group of inventory market databases comprises securities that meet sure necessities with regards to dividend payout schedules, dividend yields, company historical past, or authorized construction.
Take into account this a catch-all for the Certain Dividend databases that don’t group properly with our different sources:
Thanks for studying this text. Please ship any suggestions, corrections, or inquiries to help@suredividend.com.
