Article up to date on November seventh, 2024 by Bob Ciura

Spreadsheet information up to date each day

The NASDAQ-100 Index is a market capitalization-weighted index of the 100 largest non-financial firms that commerce on the NASDAQ inventory trade.

As a result of the index relies on the inventory trade on which an organization trades, it’s completely 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 may obtain a free spreadsheet of all of the shares within the NASDAQ-100 (together with related monetary metrics resembling dividend yields and price-to-earnings ratios) by clicking on the hyperlink beneath:

 

The NASDAQ 100 Shares Checklist obtainable for obtain above incorporates the next info for every firm within the Index:

Inventory Worth
Dividend Yield
Market Capitalization
Worth-to-Earnings Ratio

Preserve studying this text to be taught extra about investing within the NASDAQ-100 Index.

How To Use The NASDAQ-100 Shares Checklist To Discover Funding Concepts

Having an Excel doc containing the names, tickers, and monetary info of each firm within the NASDAQ 100 Index might 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 how one can use Microsoft Excel to use attention-grabbing inventory screens to the NASDAQ 100 Checklist.

The primary display we’ll implement is for firms with low price-to-earnings ratios.

Display 1: Low Worth-to-Earnings Ratios

Step 1: Obtain the NASDAQ 100 Shares Checklist by clicking right here.

Step 2: Click on on the filter icon on the prime of the price-to-earnings ratio column, as proven beneath.

NADAQ 100 Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Much less Than” and enter 15 into the sphere beside it. This may filter for firms inside the NASDAQ 100 which have price-to-earnings ratios beneath 15.

The subsequent display that we’ll implement is for shares with price-to-earnings ratios beneath 20 and dividend yields above 2%.

Display 2: Cheap Worth-to-Earnings Ratios, Above-Common Dividend Yields

Step 1: Obtain the NASDAQ 100 Shares Checklist.

Step 2: Click on on the filter icon on the prime of the price-to-earnings ratio column, as proven beneath.

Step 3: Change the filter setting to “Much less Than” and enter 20 into the sphere beside it, as proven beneath.

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 beneath.

Step 5: Change the filter setting to “Higher Than” and enter 0.02 into the sphere beside it, as proven beneath. This may 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 beneath 20 and dividend yields above 2%.

Ultimate Ideas

The NASDAQ-100 incorporates many high-quality firms. With that mentioned, because of its reliance on the NASDAQ Inventory Alternate 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 Alternate and different inventory exchanges.

Positive Dividend maintains a lot of investing databases that permit you to discover funding alternatives outdoors of the NASDAQ inventory trade.

Should you’re searching for shares with sturdy prospects of accelerating their dividends within the years to return, we advocate contemplating the next databases:

You might also be looking for dividend shares inside a selected sector of the inventory market. If that’s the case, contemplate the next Positive Dividend databases:

You might also be interested by looking for 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 preserve 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 interested by customizing their funding portfolio to satisfy sure quantitative standards:

Thanks for studying this text. Please ship any suggestions, corrections, or inquiries to assist@suredividend.com.

Source link

Leave A Reply

Company

Bitcoin (BTC)

$ 95,342.00

Ethereum (ETH)

$ 3,291.83

BNB (BNB)

$ 661.86

Solana (SOL)

$ 181.41
Exit mobile version