Thursday, July 10, 2025
  • Login
Euro Times
No Result
View All Result
  • Home
  • Finance
  • Business
  • World
  • Politics
  • Markets
  • Stock Market
  • Cryptocurrency
  • Investing
  • Health
  • Technology
  • Home
  • Finance
  • Business
  • World
  • Politics
  • Markets
  • Stock Market
  • Cryptocurrency
  • Investing
  • Health
  • Technology
Euro Times
No Result
View All Result

2022 NASDAQ 100 Stocks List Spreadsheet

by Nicholas McCullum
November 22, 2022
in Investing
Reading Time: 7 mins read
A A
0
Home Investing
Share on FacebookShare on Twitter


Article updated on November 21st, 2022 by Bob Ciura

Spreadsheet data updated daily

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

Because the index depends on the stock exchange on which a company trades, it is different than either the S&P 500 or the Dow Jones Industrial Average. It is 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 on the link below:

 

The NASDAQ 100 Stocks List available for download above contains the following information for each company in the Index:

  • Stock Price
  • Dividend Yield
  • Market Capitalization
  • Price-to-Earnings Ratio

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

How To Use The NASDAQ-100 Stocks List To Find Investment Ideas

Having an Excel document containing the names, tickers, and financial information of every company in the NASDAQ 100 Index can be very useful.

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

With that in mind, this section of this article will provide a step-by-step tutorial on how to use Microsoft Excel to apply interesting stock screens to the NASDAQ 100 List.

The first screen we’ll implement is for companies with low price-to-earnings ratio and reasonable price-to-book ratios.

Screen 1: Low Price-to-Earnings Ratios and Reasonable Price-to-Book Ratios

Step 1: Download the NASDAQ 100 Stocks List by clicking here.

Step 2: Click on the filter icon at the top of the price-to-earnings ratio column, as shown below.

NADAQ 100 Stocks Excel Tutorial 1

Step 3: Change the filter setting to “Less Than” and input 15 into the field beside it. This will filter for companies within the NASDAQ 100 that have price-to-earnings ratios below 15.

NASDAQ 100 Stocks Excel Tutorial 2

Step 4: Exit the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right corner of the window). Then, click on the filter icon at the top of the price-to-book value column, as shown below.

NASDAQ 100 Stocks Excel Tutorial 3

Step 5: Change the filter setting to “Less Than” and input 3 into the field beside it. This will filter for stocks within the NASDAQ 100 Index with price-to-book ratios below 3.

NASDAQ 100 Stocks Excel Tutorial 4

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

The next screen that we’ll implement is for stocks with price-to-earnings ratios below 20 and dividend yields above 2%.

Screen 2: Reasonable Price-to-Earnings Ratios, Above-Average Dividend Yields

Step 1: Download the NASDAQ 100 Stocks List by clicking here.

Step 2: Click on the filter icon at the top of the price-to-earnings ratio column, as shown below.

NASDAQ 100 Stocks Excel Tutorial 9

Step 3: Change the filter setting to “Less Than” and input 20 into the field beside it, as shown below.

NASDAQ 100 Stocks Excel Tutorial 10

Step 4: Exit the filter window (by clicking the exit button, not by clicking the “Clear Filter” button in the bottom right). Then, click the filter icon at the top of the dividend yield column, as shown below.

NASDAQ 100 Stocks Excel Tutorial 11

Step 5: Change the filter setting to “Greater Than” and input 0.02 into the field beside it, as shown below. This will filter for stocks within the NASDAQ 100 Index with dividend yields above 2%.

NASDAQ 100 Stocks Excel Tutorial 12

The remaining stocks in this spreadsheet are members of the NASDAQ 100 Index with price-to-earnings ratios below 20 and dividend yields above 2 percent.

Final Thoughts

The NASDAQ-100 contains many high-quality companies. With that said, due to its reliance on the NASDAQ Stock Exchange it is heavily weighted toward certain sectors (primarily technology). It also excludes all of the businesses (including the appealing ones) that trade on the New York Stock Exchange and other stock exchanges.

Sure Dividend maintains a number of investing databases that allow you to find investment opportunities outside of the NASDAQ stock exchange. If you’re looking for stocks with strong prospects of increasing their dividends in the years to come, we recommend considering the following databases:

You may also be searching for dividend stocks within a particular sector of the stock market. If that’s the case, consider the following Sure Dividend databases:

You may also be interested in searching for investment opportunities within other major stock market indices (outside of the S&P 500). If that is indeed the case, the following domestic stock market database could prove useful:

We also maintain databases that characterize dividend stocks by their financial characteristics, dividend yields, performance metrics, and payout schedules. The following four Sure Dividend databases are powerful for the investor interested in customizing their investment portfolio to meet certain quantitative criteria:

Thanks for reading this article. Please send any feedback, corrections, or questions to [email protected].





Source link

Tags: listNasdaqSpreadsheetstocks
Previous Post

Robeco – The Cross-Section of Stock Returns before 1926 (and beyond) (The Best Investment Writing Volume 6) – Meb Faber Research

Next Post

Budget 2023: Infra sector seeks rationalisation of GST, easier bank credit

Related Posts

Mind the Inflation Gap: Hedging with Real Assets

Mind the Inflation Gap: Hedging with Real Assets

by David Blanchett, PhD, CFA, CFP
July 10, 2025
0

Inflation expectations are skyrocketing. The College of Michigan Survey of Shoppers exhibits that median forecasts jumped to six.5% in April...

Dividend Kings In Focus: Genuine Parts

Dividend Kings In Focus: Genuine Parts

by Bob Ciura
July 9, 2025
0

Up to date on July ninth, 2025 by Nathan Parsh An organization will need to have an extended observe report...

10 Safest High Dividend Stocks Now

10 Safest High Dividend Stocks Now

by Robert Ciura
July 8, 2025
0

Printed on July eighth, 2025 by Bob Ciura Excessive dividend shares are shares with a dividend yield effectively in extra of...

Dividend Kings In Focus: Johnson & Johnson

Dividend Kings In Focus: Johnson & Johnson

by Nate Parsh
July 8, 2025
0

Up to date on July eighth, 2025 by Nathan Parsh Solely one of the best firms can improve dividends by...

Book Review: Cheaper Faster Better: How We’ll Win the Climate War

Book Review: Cheaper Faster Better: How We’ll Win the Climate War

by Mark K. Bhasin, CFA
July 8, 2025
0

Cheaper, Sooner Higher: How We’ll Win the Local weather Battle. 2024. Tom Steyer. Spiegel & Grau. In Cheaper Sooner Higher,...

10 High Dividend Tech Stocks For Growth And Income

10 High Dividend Tech Stocks For Growth And Income

by Robert Ciura
July 7, 2025
0

Printed on July seventh, 2025 by Bob Ciura The expertise business is among the most fun areas of the inventory...

Next Post
Budget 2023: Infra sector seeks rationalisation of GST, easier bank credit

Budget 2023: Infra sector seeks rationalisation of GST, easier bank credit

Italy’s Cucinelli and EssilorLuxottica sign eyewear license accord By Reuters

Italy's Cucinelli and EssilorLuxottica sign eyewear license accord By Reuters

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

“Calling All Crypto Transactions Externalization Would Be Very Limiting,” Warns FMAS:25 Panel

“Calling All Crypto Transactions Externalization Would Be Very Limiting,” Warns FMAS:25 Panel

July 10, 2025
Why Is Every Natural Disaster Being Politicized?

Why Is Every Natural Disaster Being Politicized?

July 10, 2025
Court in Moldova Extends House Arrest of Gagauzia Head Gutsul for 30 Days

Court in Moldova Extends House Arrest of Gagauzia Head Gutsul for 30 Days

July 10, 2025
Pentagon to become largest shareholder in rare earth magnet maker MP Materials

Pentagon to become largest shareholder in rare earth magnet maker MP Materials

July 10, 2025
Saratoga Investment Q1: ROE Beating The BDC Industry Average (NYSE:SAR)

Saratoga Investment Q1: ROE Beating The BDC Industry Average (NYSE:SAR)

July 10, 2025
The Emptiness of AI Ethics

The Emptiness of AI Ethics

July 10, 2025
Euro Times

Get the latest news and follow the coverage of Business & Financial News, Stock Market Updates, Analysis, and more from the trusted sources.

CATEGORIES

  • Business
  • Cryptocurrency
  • Finance
  • Health
  • Investing
  • Markets
  • Politics
  • Stock Market
  • Technology
  • Uncategorized
  • World

LATEST UPDATES

“Calling All Crypto Transactions Externalization Would Be Very Limiting,” Warns FMAS:25 Panel

Why Is Every Natural Disaster Being Politicized?

  • Disclaimer
  • Privacy Policy
  • DMCA
  • Cookie Privacy Policy
  • Terms and Conditions
  • Contact us

Copyright © 2022 - Euro Times.
Euro Times is not responsible for the content of external sites.

No Result
View All Result
  • Home
  • Finance
  • Business
  • World
  • Politics
  • Markets
  • Stock Market
  • Cryptocurrency
  • Investing
  • Health
  • Technology

Copyright © 2022 - Euro Times.
Euro Times is not responsible for the content of external sites.

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In