Article updated April 22, 2021 by Bob Ciura

The spreadsheet data is updated daily

The NASDAQ-100 Index is a market capitalization weighted index of the 100 largest non-financial companies listed on the NASDAQ stock exchange.

Because the index depends on the exchange a company is trading on, it is different from either the S&P 500 or the Dow Jones Industrial Average. It’s also a useful place to find investment ideas.

You can download a free spreadsheet of all the stocks in the NASDAQ-100 (including relevant financial metrics such as dividend yields and price-to-earnings ratios) by clicking the link below:

The NASDAQ 100 stock listing available for download above contains the following information for each company in the index:

  • Stock price
  • Dividend yield
  • Market capitalization
  • Price-performance ratio

Keep reading this article to learn more about investing in the NASDAQ 100 index.

How to Use the NASDAQ 100 Stock List to Find Investment Ideas

An Excel sheet with the names, tickers, and financial information of all the companies in the NASDAQ 100 index can be very useful.

This document becomes even more powerful when combined with a basic knowledge of Microsoft Excel.

With that in mind, this section of this article provides a step-by-step guide on how to use Microsoft Excel to apply interesting inventory screens to the NASDAQ 100 list.

The first screen we are implementing is for businesses that are low in value and reasonably priced.

Screen 1: Low value for money and reasonable value for money

Step 1: Download the NASDAQ 100 stock listing by clicking here.

Step 2: Click the filter icon at the top of the Price / Earnings Ratio column (see below).

NADAQ 100 Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Less than” and enter 15 in the field next to it. This will filter for companies within the NASDAQ 100 that have a value for money below 15.

NASDAQ 100 Stocks Excel Tutorial 2

Step 4: Exit the filters window (by clicking the “Exit” button, not the “Clear Filters” button in the lower right corner of the window). Then click the filter icon at the top of the Price-Book Value column as shown below.

NASDAQ 100 Stocks Excel Tutorial 3

Step 5: Change the filter setting to “Less than” and enter 3 in the field next to it. This filters for stocks within the NASDAQ 100 index with a price-to-book ratio below 3.

NASDAQ 100 Stocks Excel Tutorial 4

The remaining stocks in this table are NASDAQ 100 stocks with price-to-earnings ratios below 15 and price-to-book ratios below 3.

The next screen we’ll implement is for stocks with P / E ratios below 20 and dividend yields above 2%.

Screen 2: Reasonable value for money, above-average dividend yields

Step 1: Download the NASDAQ 100 stock listing by clicking here.

Step 2: Click the filter icon at the top of the Price / Earnings Ratio column (see below).

NASDAQ 100 Stocks Excel Tutorial 9

Step 3: Change the filter setting to Less Than and enter 20 in the field next to it as shown below.

NASDAQ 100 Stocks Excel Tutorial 10

Step 4: Exit the filter window (by clicking the exit button. Not by clicking on the “Clear filter” button at the bottom right). Then click the filter icon in the Dividend Yield column at the top (see screenshot below).

NASDAQ 100 Stocks Excel Tutorial 11

Step 5: Change the filter setting to “Greater than” and enter 0.02 in the field next to it as shown below. This filters for stocks within the NASDAQ 100 index with dividend yields above 2%.

NASDAQ 100 Stocks Excel Tutorial 12

The remaining stocks in this table are members of the NASDAQ 100 Index with a price / earnings ratio of less than 20 and a dividend yield of over 2 percent.

Final thoughts

The NASDAQ-100 contains many high quality companies. However, due to its reliance on the NASDAQ Stock Exchange, the company is heavily focused on specific sectors (mostly technology). Also excluded are all companies (including the appealing ones) that are traded on the New York Stock Exchange and other stock exchanges.

Sure Dividend maintains a number of investment databases that you can use to find investment opportunities outside of the NASDAQ exchange. If you are looking for stocks that have a good chance of growing their dividends in the years to come, we recommend you consider the following databases:

You may also be looking for dividend stocks in a specific sector of the stock market. If so, consider the following Sure Dividend databases:

You may also want to look for investment opportunities in other major stock market indices (outside of the S&P 500). In this case, the following domestic stock exchange databases will come in handy:

Alternatively, Sure Dividend also maintains databases on certain international stock market indices, which are available for download below:

We also maintain databases that characterize dividend stocks based on their financial characteristics, dividend yields, performance metrics, and payout schedules. The following four Sure Dividend databases are of great importance for investors who wish to tailor their investment portfolio to specific quantitative criteria:

Thank you for reading this article. Please send feedback, corrections, or questions to support@suredividend.com.



LEAVE A REPLY

Please enter your comment!
Please enter your name here