Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd
Search
Shrewd'm.com Merry shrewd investors
Search
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd


The week's question
In December 2024, in the thread "Re: BRK: Why Not XOM?", BreckHutHigh asked the members: "What about the long road trips with kids?" This week it is put to everyone again. The button below opens the small thread re-asking it - read what others have said so far, then give your own answer as an ordinary reply.
Answer this questionContinue to Shrewd'mThis note won't appear again
Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (70) |
Author: musselmant 🐝  😊 😞
Number: of 6131 
Subject: Re: NDX 100 Momentum Strategy - Code Repository
Date: 04/17/26 8:54 AM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 10
1. Koyfin (free tier – very good) build a Nasdaq-100 watchlist, display custom performance periods
You can choose:
9 months,10 months,any custom start date
Create a Nasdaq-100 watchlist.
Add the metric Performance since date.
Choose a start date (for example 270 days ago ≈ 9 months).
Sort the column.
professional-quality interface
customizable analytics.

2. TradingView custom watchlists (e.g., Nasdaq-100),sorting by performance since a date
You can manually set the start date to 9 months ago.

This is probably the easiest free tool for ranking stocks by a custom date range.

How to do it:

Open the Stock Screener.
Filter Index → NASDAQ-100.
Add the column Performance %.
Click the column menu and choose Performance since date.
Set the start date to about 9 or 10 months ago.
Sort descending.

This instantly gives a momentum ranking of the entire Nasdaq-100.

Pros:

completely free
adjustable period
sortable table.

3. StockCharts technical indicator called Rate of Change (ROC). Example: ROC(200) ≈ 10-month return,ROC(189) ≈ 9-month return
You can scan for top values.

4. download Nasdaq-100 prices from **Nasdaq or **Yahoo Finance and compute the return from 189 or 210 trading days ago
Sort the list. This takes about 5 seconds in Excel once set up.

5. Google Sheets momentum spreadsheet (automatic prices)

This is the simplest method and costs nothing.

Step-by-step setup

1. List the Nasdaq-100 tickers
Example column:

AAPL
MSFT
NVDA
AMZN
META Google Sheets has a built-in function:

=GOOGLEFINANCE(A2,"price")

This updates automatically.Pull historical price

For a 9-month momentum calculation, use about 189 trading days.

Example:

=INDEX(GOOGLEFINANCE(A2,"price",TODAY()-270,TODAY()),2,2)

(270 calendar days ≈ 9 months)

You can copy the list from the Nasdaq website
Calculate momentum

Example formula:

=current_price / past_price - 1
Sort the column

Sort descending and you instantly get:

Rank 1 momentum
Rank 2
Rank 3
...

6. Yahoo Finance download method

From Yahoo Finance you can:

create a Nasdaq-100 watchlist
download prices to Excel
compute the 9-month return.

7. Nasdaq Data Link

Yes — this usually means the entire historical price series available for that dataset.

Typical behavior:

you request a dataset (for example a stock or index)
you download a CSV containing all available dates
the file includes daily data such as
Date
Open
High
Low
Close
Volume
Adjusted Close

Most datasets allow you to:

download the whole history
or specify a date range via the API.

For example, a dataset might contain prices from:

1990 → present

You download the entire table in one file.

8. Kaggle stock datasets contain:

Date
Ticker
Open
High
Low
Close
Volume

for many stocks in one table.

Example structure:

Date Ticker Close
2010-01-04 AAPL 30.57
2010-01-04 MSFT 21.45
2010-01-04 AMZN 133.90

Advantages:

all tickers together
easy for Python, Excel, or R
good for momentum calculations.

But Kaggle datasets may:

stop at a certain year
not update automatically.

sites for membership:

1. Nasdaq (official source)

The Nasdaq website publishes the current constituents of the Nasdaq-100 index.

Typical page features:

full ticker list
company names
sector
weighting information

This is the most reliable source for the current membership.

Example page:
nasdaq.com - Nasdaq ndx

However, the official site does not provide an easy historical membership database.

2. Wikipedia

The Nasdaq-100 page on Wikipedia actually maintains a historical table of additions and removals.

It lists:

the company added
the company removed
the date

That makes it surprisingly useful for reconstructing membership changes.

Example section:
“Changes in NDX components.”

Many quants use this page as a quick reference.

3. ETF.com

Because the ETF Invesco QQQ Trust tracks the Nasdaq-100, ETF sites show the current holdings of QQQ.

These pages update frequently and include:

ticker list
weights
sector exposure

It’s another convenient way to get the current list of stocks.

4. Koyfin

Koyfin lets you view index membership lists directly.

You can open the Nasdaq-100 index page and export the full list into a spreadsheet for your momentum calculations.
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to musselmant here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,115 posts about Mechanical Investing. The article-length ones it recommended most:
Dividend investing · 52 recs · 2025
Non-Mag7 screen · 34 recs · 2025
OT - Div yields and returns · 32 recs · 2024
Using AI to generate backtesting programs · 30 recs · 2025
Rankings for 19Dec2022 · 29 recs · 2022
Unthreaded | Threaded | Whole Thread (70) |


Announcements
Mechanical Investing FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds | Open Questions | Moving a community