Nasdaq-100 Up 33% in H1 2026 — But the Mag 7 Lagged. How to See Your Real Nasdaq Exposure in One Sheet
The index rallied from a March low near 22,953 to a record above 30,660 in ten weeks. The Magnificent Seven returned just 5.4% and trailed the S&P 500. The story of the first half is that the AI trade broadened — and that matters more than the headline number.
The First Half in One Table
| Nasdaq-100 H1 2026 Return | ~33% (March low to mid-June record) |
| March 2026 Low | ~22,953 ("Liberation Day" selloff) |
| Mid-June 2026 High | >30,660 (fresh record) |
| 50-Day Moving Average | ~28,149 |
| 200-Day Moving Average | ~25,733 |
| Magnificent Seven H1 Return | 5.4% (lagged the S&P 500) |
| S&P 500 H1 Return | 7.9% |
| Mag 7 Profit Growth | ~18% (slowest since 2022) |
The headline number — a 33% rally in ten weeks off the March low — is not the story. The story is what the headline number conceals. The Magnificent Seven, the same group that carried the index through 2023, 2024, and 2025, returned less than the broader market in the first half of 2026. That has not happened in several years. The AI trade is alive, but it is no longer concentrated in seven names.
The Trade Broadened, and That Is the Real Story
The Magnificent Seven returned 5.4% in the first half. The S&P 500 returned 7.9%. The rest of the Nasdaq-100 returned more than both. Combined profit growth across the seven slowed to roughly 18% — the weakest pace since 2022, and barely ahead of the 13% projected for the rest of the index. Investor sentiment shifted from rewarding AI exposure unconditionally to demanding evidence of AI return on investment rather than just AI spending. The same shift that punished Microsoft after its $190 billion capex guide in April rewarded semiconductor equipment suppliers, data centre infrastructure builders, cybersecurity firms, and automation companies throughout the spring.
Performance within the group diverged sharply. Alphabet and Nvidia were the standouts. Microsoft and Tesla were clear laggards. Meta’s setback came in late 2025 when capex guidance spiked to $72 billion, and the market has not yet decided whether to forgive the spending. Wall Street’s consensus 12-month price targets imply roughly 29% upside across the group, with Nvidia, Microsoft, and Meta as the clearest winners and Tesla as the most conservatively rated. The narrowing of the gap — the seven trailing the broader market — is what reduces the concentration risk that made earlier rallies fragile.
The AI capex supercycle shows no clear signs of deceleration. Cloud services, chipmakers, and software companies continue to post double-digit revenue growth, even as the breakneck pace of 2024 and 2025 moderates. The companies with the strongest balance sheets are using the spending cycle to widen their moats against weaker rivals. That is a regime in which index-level exposure beats stock-picking, and concentration risk at the index level is genuinely lower than it was a year ago.
How to See Your Real Nasdaq-100 Exposure
The Nasdaq-100 is a market-cap-weighted index, and even though the H1 2026 story is one of broadening, the top ten names still drive an outsized share of the return. That is the structural feature the index has had for a decade, and the lower Mag 7 return does not change it. If you own QQQ or QQQM in your IRA, ONEQ in your taxable brokerage, and a tech-sector ETF in your 401(k), you are exposed to the same handful of names three times. Each brokerage app shows you its slice in isolation. None of them tells you that the “three positions” are really one.
The fix is to put every account in one sheet and let formulas do the aggregation. InvestSheet syncs Fidelity, Schwab, Robinhood, and 30+ other brokerages into a single Google Sheet, and exposes them through one set of built-in functions. The relevant ones for a Nasdaq-100 audit are IVS_BROKERAGE for per-ticker values across all linked accounts, and a manual cross-reference of the QQQ top-10 holdings against your other positions. A typical layout:
From there, the math is yours. Add up how much of your net worth is allocated to each underlying name across all accounts. Flag any single ticker that crosses 5% of your portfolio, and any single sector that crosses 30%. The numbers will not match what any single brokerage app is showing, and that is precisely the point. The first half of 2026 rewarded investors who knew what they actually owned, regardless of how many wrappers the same bet was hidden inside.
Frequently Asked Questions
How much did the Nasdaq-100 return in the first half of 2026?
The Nasdaq-100 rallied roughly 33% in the ten weeks between the March 2026 low near 22,953 and the record high above 30,660 reached in mid-June. The index ended the first half comfortably above both its 50-day moving average near 28,149 and its 200-day moving average near 25,733, with the Relative Strength Index between 60 and 70 — momentum that is sustained but not yet extreme.
Did the Magnificent Seven lead the Nasdaq-100 higher in 2026?
No — and that is the surprise. Through the first half of 2026, the Magnificent Seven (Nvidia, Apple, Microsoft, Amazon, Alphabet, Meta, Tesla) returned just 5.4%, lagging the S&P 500 at 7.9%. It is the first time in several years that the group has meaningfully trailed the broader market. Combined profit growth across the seven slowed to roughly 18% — the weakest pace since 2022 — and the rally broadened out to semiconductor equipment suppliers, data centre infrastructure builders, cybersecurity firms, and automation companies.
How can I track my Nasdaq-100 exposure across multiple brokerages in Google Sheets?
List every Nasdaq-100 fund you own across Fidelity, Schwab, Robinhood, and any other account in one sheet — typical tickers are QQQ, QQQM, ONEQ, QQQJ, and similar. Pull the value of each holding using InvestSheet’s built-in IVS_BROKERAGE formulas, which return the aggregated value of any ticker across every linked account. Then list the top 10 holdings of the Invesco QQQ Trust and search for each name in your other non-Nasdaq accounts too. A position that shows up in QQQM plus a tech ETF plus a growth fund is not three positions. It is one, repeated.
See your real Nasdaq-100 exposure in one sheet
14-day free trial. $9.99/mo or $7.99/mo annual. Sync 35+ brokerages — including Fidelity, Schwab, and Robinhood — into a single Google Sheet with live formulas for overlap, sector weight, and concentration across every account at once.
Install InvestSheet