Article up to date on December ninth, 2024 by Bob Ciura
Spreadsheet information up to date day by day
The NASDAQ-100 Index is a market capitalization-weighted index of the 100 largest non-financial corporations that commerce on the NASDAQ inventory trade.
As a result of the index will depend on the inventory trade on which an organization trades, it’s totally different than both the S&P 500 or the Dow Jones Industrial Common. Additionally it is a helpful place to seek out funding concepts.
You possibly can obtain a free spreadsheet of all of the shares within the NASDAQ-100 (together with related monetary metrics reminiscent of dividend yields and price-to-earnings ratios) by clicking on the hyperlink under:
The NASDAQ 100 Shares Listing obtainable for obtain above accommodates the next data for every firm within the Index:
Inventory Value
Dividend Yield
Market Capitalization
Value-to-Earnings Ratio
Preserve studying this text to study extra about investing within the NASDAQ-100 Index.
How To Use The NASDAQ-100 Shares Listing To Discover Funding Concepts
Having an Excel doc containing the names, tickers, and monetary data of each firm within the NASDAQ 100 Index will be very helpful.
This doc turns into much more highly effective when mixed with a working information of Microsoft Excel.
With that in thoughts, this part of this text will present a step-by-step tutorial on learn how to use Microsoft Excel to use fascinating inventory screens to the NASDAQ 100 Listing.
The primary display screen we’ll implement is for corporations with low price-to-earnings ratios.
Display 1: Low Value-to-Earnings Ratios
Step 1: Obtain the NASDAQ 100 Shares Listing by clicking right here.
Step 2: Click on on the filter icon on the prime of the price-to-earnings ratio column, as proven under.
Step 3: Change the filter setting to “Much less Than” and enter 15 into the sphere beside it. It will filter for corporations inside the NASDAQ 100 which have price-to-earnings ratios under 15.
The subsequent display screen that we’ll implement is for shares with price-to-earnings ratios under 20 and dividend yields above 2%.
Display 2: Affordable Value-to-Earnings Ratios, Above-Common Dividend Yields
Step 1: Obtain the NASDAQ 100 Shares Listing.
Step 2: Click on on the filter icon on the prime of the price-to-earnings ratio column, as proven under.
Step 3: Change the filter setting to “Much less Than” and enter 20 into the sphere beside it, as proven under.
Step 4: Exit the filter window (by clicking the exit button, not by clicking the “Clear Filter” button within the backside proper). Then, click on the filter icon on the prime of the dividend yield column, as proven under.
Step 5: Change the filter setting to “Higher Than” and enter 0.02 into the sphere beside it, as proven under. It will filter for shares inside the NASDAQ 100 Index with dividend yields above 2%.
The remaining shares on this spreadsheet are members of the NASDAQ 100 Index with price-to-earnings ratios under 20 and dividend yields above 2%.
Remaining Ideas
The NASDAQ-100 accommodates many high-quality corporations. With that stated, as a consequence of its reliance on the NASDAQ Inventory Change it’s closely weighted towards sure sectors (primarily expertise).
It additionally excludes the entire companies (together with the interesting ones) that commerce on the New York Inventory Change and different inventory exchanges.
Positive Dividend maintains a lot of investing databases that mean you can discover funding alternatives outdoors of the NASDAQ inventory trade.
Should you’re on the lookout for shares with sturdy prospects of accelerating their dividends within the years to return, we suggest contemplating the next databases:
You might also be trying to find dividend shares inside a selected sector of the inventory market. If that’s the case, take into account the next Positive Dividend databases:
You might also be taken with trying to find funding alternatives inside different main inventory market indices (outdoors of the S&P 500). If that’s certainly the case, the next home inventory market database may show helpful:
We additionally keep databases that characterize dividend shares by their monetary traits, dividend yields, efficiency metrics, and payout schedules.
The next 4 Positive Dividend databases are highly effective for the investor taken with customizing their funding portfolio to satisfy sure quantitative standards:
Thanks for studying this text. Please ship any suggestions, corrections, or inquiries to help@suredividend.com.
