Apple WWDC stock tracker excel - if that is the search that brought you here, you are in good company. The week leading into the Worldwide Developers Conference is the single most important software event on the Apple calendar, and for the supplier ecosystem it is often the single most consequential trading window of Q2. WWDC 2026 opens at Apple Park on Monday June 8, 2026, with the keynote live-streamed at 10:00 PT. This guide walks through a working Apple WWDC stock tracker built in Excel, powered by the MarketXLS add-in, with a 25-name supplier watchlist, a WWDC AI Exposure Score, five outcome scenarios, options structures keyed off the post-keynote expiration, and a position-sizing sleeve. Both files are free to download below.
The setup matters because the iPhone refresh cycle is no longer just a hardware story. The reveal at WWDC 2026 is expected to focus on the next generation of Apple Intelligence, the on-device LLM stack first introduced in 2024, and how it threads through iOS 19, macOS Tahoe, and a refreshed App Intents framework. That single keynote sets the demand backdrop for every silicon, sensor, memory, foundry, and AI-infrastructure name in the supplier base. This template is built so you can watch all of them on one Excel surface, with live data, before, during, and after the catalyst.
Quick Reference: What Is In The Tracker
| Sheet | Purpose |
|---|---|
| Main Dashboard | 25 names with price, valuation, momentum, and WWDC AI Exposure Score |
| Scenario Analysis | Five WWDC keynote outcomes mapped to AAPL price targets |
| Strategy & Options | Pre and post-keynote option structures with breakeven and bias |
| Portfolio & Allocation | Position sizing across the 25-name basket from your inputs |
| Comparison Matrix | Valuation, margin, ROE, EV/EBITDA across all 25 names |
The watchlist is built around five segments of the Apple supply chain: silicon and modems, memory, foundry and equipment, sensors and materials, and AI infrastructure. Every name in the template earns its place because a meaningful share of its revenue, design pipeline, or capacity commitments are tied to Apple end-market demand or to the AI build-out that supports Apple Intelligence private compute.
Why The WWDC 2026 Keynote Matters For The Supplier Base
Apple WWDC has always been a software event. The hardware announcements that move the supplier base tend to land at the iPhone keynote in September. But the WWDC keynote sets the narrative for the year, and that narrative is what gets priced into supplier multiples between June and the iPhone reveal. Three reasons that has become more important in 2026:
First, Apple Intelligence is now the primary differentiator on the iPhone roadmap. The on-device LLM, the private compute cloud, and the App Intents integration are what Apple is asking developers to build around. The deeper the integration, the larger the bill of materials. Larger BOM means more SoC content for the foundry, more memory per device, more sensors, and more high-bandwidth networking inside the Apple iCloud back end. The WWDC keynote is the first concrete signal each year of how aggressive that direction will be.
Second, the iPhone 18 lineup that will ship in September 2026 is the first generation designed end to end around Apple Intelligence. WWDC software previews are the most reliable hint of what hardware Apple believes the software will require. If the keynote previews on-device features that need more RAM, more neural compute, or new sensor modalities, the supplier base reads through almost immediately.
Third, the supplier base itself is now structurally tighter. TSMC is the only foundry that can run the leading-edge A-series and M-series silicon at scale, memory is in its strongest pricing position since 2023, and the equipment vendors are sold out at the EUV nodes. Every incremental pull from Apple compounds across that supply base. A small upside surprise can ripple visibly through prices in the days after the keynote, and a small downside surprise can drain risk premium out of the same names just as fast.
The 25-Name Apple WWDC Watchlist
The Main Dashboard sheet is the heart of the workbook. It contains 25 large and mid-cap names that have material exposure to the Apple iPhone, Mac, Vision, or services revenue base, plus the AI infrastructure that supports Apple Intelligence private compute. The basket is divided into seven segments:
- OEM: Apple Inc. (AAPL) - the anchor name.
- Silicon and modems: Broadcom (AVGO), Qualcomm (QCOM), Skyworks (SWKS), Qorvo (QRVO), Cirrus Logic (CRUS), STMicroelectronics (STM), Texas Instruments (TXN), NXP Semiconductors (NXPI), ON Semiconductor (ON), Synaptics (SYNA), Marvell (MRVL).
- Foundry: Taiwan Semiconductor Manufacturing (TSM).
- Memory: Micron Technology (MU).
- Equipment: Lam Research (LRCX), Applied Materials (AMAT), KLA Corporation (KLAC), ASML Holding (ASML), Teradyne (TER).
- Materials and services: Corning (GLW), Jabil (JBL), Lumentum (LITE).
- AI infrastructure: NVIDIA (NVDA), Arista Networks (ANET), Arm Holdings (ARM).
Each row has a WWDC AI Exposure Score from 1 to 5 in the rightmost column. The score is qualitative, captures how directly the name benefits from a positive WWDC AI catalyst, and feeds into the Portfolio sheet to drive position weight.
Key Columns On The Dashboard
| Column | What It Measures | MarketXLS Formula |
|---|---|---|
| Price | Live last trade price | =Last("AAPL") |
| Market Cap | Total market capitalization | =MarketCapitalization("AAPL") |
| P/E | Trailing twelve-month earnings multiple | =PERatio("AAPL") |
| Fwd P/E | Forward earnings multiple | =ForwardPE("AAPL") |
| Div Yld % | Indicated dividend yield | =DividendYield("AAPL") |
| Beta | Sensitivity to the broad market | =Beta("AAPL") |
| RSI | 14-period Relative Strength Index | =RSI("AAPL") |
| 50d SMA | 50-day simple moving average | =SimpleMovingAverage("AAPL",50) |
| 200d SMA | 200-day simple moving average | =SimpleMovingAverage("AAPL",200) |
| YTD % | Year-to-date price change | =ChangePercentYTD("AAPL") |
| Op Mgn % | Operating margin | =OperatingMargin("AAPL") |
The RSI column, the YTD column, and the Exposure column all carry color scales so you can see at a glance which names are extended, which are still washed out, and which carry the highest catalyst weight inside the basket.
The Apple WWDC AI Exposure Score
The Exposure column on the Main Dashboard is the analytical core of the tracker. It is a five-point qualitative score that tries to answer one question for each name: how much of the next 12 months of earnings is tied to a successful WWDC 2026 AI catalyst?
A score of 5 means the company is materially leveraged to a positive Apple Intelligence reveal. AAPL, AVGO, QCOM, TSM, and ARM sit here. AAPL because it is the OEM. AVGO because it supplies the custom Apple SoC for the AirPods and the next generation of networking content, and is one of the few names with disclosed multi-billion-dollar Apple revenue. QCOM because the modem roadmap and the 5G platform are still core to the iPhone 18 family. TSM because every leading-edge die runs through Hsinchu. ARM because the architecture royalty is paid on every A-series and M-series chip Apple ships.
A score of 4 captures names where Apple is a meaningful but not dominant customer, and where a positive Apple Intelligence reveal would still drive an upgrade cycle through their product. SWKS, QRVO, CRUS, MU, LITE, GLW, JBL, ANET, NVDA sit here. SWKS and QRVO benefit from RF content per phone. CRUS is the audio codec and haptics name. MU sees direct read-through to higher memory content per device. LITE provides the VCSEL lasers for FaceID and any LiDAR upgrade. GLW supplies the Ceramic Shield cover glass. JBL handles a slice of contract manufacturing. ANET supplies data center switching for the iCloud back end. NVDA provides the AI compute for the private cloud that backs Apple Intelligence inference.
A score of 3 captures names where Apple is a secondary or diversified customer and where the read-through is real but less direct. STM, TXN, NXPI, ON, LRCX, AMAT, KLAC, ASML, TER, SYNA, MRVL sit here. The equipment names benefit through the multi-year capex cycle that supports Apple silicon at TSMC. The analog and power-management names benefit through broad device exposure rather than any single design win.
If you want to model your own Exposure Score, the column is editable. Adjust it for any name you cover differently, and the Portfolio sheet will reweight automatically.
Scenario Analysis: Five WWDC Outcomes
The Scenario Analysis sheet maps five possible WWDC keynote outcomes to a mechanical AAPL price target. The math is intentionally simple: a base 12-month EPS estimate, a base forward P/E multiple, and two multipliers per scenario - one on EPS, one on the multiple. The product is the modeled AAPL price, and the percent move from the live price is the expected return.
| Scenario | Probability % | EPS x | P/E x | Reaction Read |
|---|---|---|---|---|
| Apple Intelligence 2.0 with on-device LLM upgrade across iPhone 18 | 15 | 1.10 | 1.10 | Silicon and memory rip |
| Steady Apple Intelligence update + M5 Mac silicon | 35 | 1.05 | 1.02 | Suppliers in line, mild bid |
| Software-only release, no major hardware roadmap | 25 | 1.00 | 0.97 | Suppliers fade modestly |
| Disappointing AI demo, perceived Siri or LLM gap | 15 | 0.95 | 0.90 | Risk-off across high-beta names |
| Regulatory or App Store policy shock on top of soft features | 10 | 0.93 | 0.85 | Multiple compression basket-wide |
A probability-weighted average sits at the bottom of the table and rolls up into a single AAPL target and expected percent move. Yellow cells are inputs. If you think the probability of a strong Apple Intelligence reveal is closer to 25%, type it in and the expected value updates instantly.
The point of running scenarios in advance of a known event is not to predict the keynote. It is to know in advance what your reaction should be if Apple delivers any of the five outcomes. That discipline is what separates a process from a guess.
Options Structures Around June 20, 2026 Expiration
WWDC tends to land with an implied volatility crush. AAPL options carry a noticeable bid into the keynote and a noticeable offer in the 24 hours after. The Strategy & Options sheet collects five sample structures keyed off the June 20, 2026 monthly expiration so you have a frame of reference for what defined-risk and undefined-risk trades look like around the event.
| # | Structure | Bias | Max Loss |
|---|---|---|---|
| 1 | Long call (bullish AI catalyst) | Bullish | Premium paid |
| 2 | Bull call spread | Bullish | Net debit |
| 3 | Bear put spread | Bearish | Net debit |
| 4 | Iron condor (range-bound) | Neutral | Width minus credit |
| 5 | Long straddle (volatility event) | Vol long | Net debit |
A long call is the simplest bullish structure if your view is that Apple delivers something the market reads as a beat. A bull call spread caps the upside but defines the risk, which is often the right trade if implied volatility is rich. A bear put spread hedges a long AAPL or basket position into the keynote. An iron condor expresses a range-bound thesis - the bet is that the keynote does not move AAPL outside a defined band. A long straddle is the cleanest expression of a long-volatility view if you think the magnitude of the move matters more than the direction.
To pull a live AAPL chain into Excel, use the MarketXLS streaming option chain function:
=QM_GetOptionChainActive("AAPL")
That single call returns the full active chain, strikes, bids, asks, implied vol, and Greeks. From there you can size the structures, calculate breakevens, and compare to the spot anchor in cell D4.
Position Sizing The Apple Ecosystem
The Portfolio & Allocation sheet takes the qualitative Exposure Score and turns it into a quantitative weight. The math:
- Sum the Exposure Score across all 25 names. In this version that sum is 92.
- Each name receives a raw weight equal to its Exposure Score divided by the total.
- The raw weight is multiplied by a sleeve percentage (default 25% of the total portfolio) so the basket does not consume the whole account.
- The result is capped at a per-name limit (default 8% of the portfolio).
- Dollar allocation equals the weight multiplied by your portfolio size input.
- Share count is dollar allocation divided by live price, rounded down by the sheet.
You change four inputs - portfolio size, per-name cap, sleeve percentage, and the Exposure Score itself - and the whole sheet recomputes. If you would rather equal-weight the basket, set every Exposure Score to 1. If you would rather concentrate, raise the score on AAPL, AVGO, TSM, ARM, and QCOM to a 6 and lower the per-name cap to 5%.
The MarketXLS functions doing the work are unchanged from the dashboard: =Last("ticker") for the live price and =MarketCapitalization("ticker") if you want to switch the basket to a market-cap-weighted scheme.
Comparison Matrix: Best Of Breed By Segment
The Comparison Matrix sheet ranks all 25 names on six factor columns: P/E, Forward P/E, Price-to-Sales, Net Profit Margin, Return on Equity, and EV/EBITDA. Two color scales help you spot the outliers. The valuation columns are green at low values and red at high values. The margin and ROE columns are green at high values and red at low values.
At the bottom of the sheet is a short best-of-breed table. It picks one leader from each of seven segments, with a short note on why it earns the slot. The table is editable - if your screening view says a different name is the leader, change it.
The functions used here:
=PERatio("AAPL")
=ForwardPE("AAPL")
=PriceToSales("AAPL")
=NetProfitMargin("AAPL")
=ReturnOnEquity("AAPL")
=EnterpriseValueToEBITDA("AAPL")
Every one of these returns the value the MarketXLS data engine has on file for the ticker. If you want to anchor a screen to a specific date instead of live, swap to one of the historical-fundamental variants that the MarketXLS add-in exposes (the HF prefixed functions).
What To Watch In The Apple Intelligence Roadmap
Two specific items will shape how the supplier base trades in the days after the WWDC keynote. The first is whether Apple announces an upgrade to the on-device model that requires more RAM or more neural cores. If yes, the read-through to MU is immediate and AAPL's own M-series silicon margins come back into focus. If no, the supplier base looks for evidence in the iPhone 18 hardware roadmap instead.
The second is whether Apple expands the App Intents framework to handle new modalities such as live visual recognition or longer-context voice. If yes, image sensors (ON, STM), audio codecs (CRUS), and AI infrastructure (NVDA, ANET) all carry a multiplier. If no, the silicon names without sensor exposure carry more of the upside on their own.
Use the tracker as a way to anchor your reading of the keynote in the data. Watch which segments respond and by how much. Compare the move to the Exposure Score you assigned. Adjust the scoring next year based on what actually mattered.
How To Build The Apple WWDC Stock Tracker From Scratch
If you want to reproduce the workbook in your own spreadsheet rather than download the template, the build sequence is:
- Set up the watchlist in column A and B - 25 tickers and company names. The companies listed above are a starting set; adjust for your view.
- Wire the price column using
=Last("ticker"). Drag down the column to populate every row. - Add the valuation columns:
=PERatio(),=ForwardPE(),=PriceToSales(). These return the trailing twelve-month, forward, and sales multiples respectively. - Add the momentum columns:
=RSI(),=SimpleMovingAverage("ticker",50),=SimpleMovingAverage("ticker",200), and=ChangePercentYTD(). The momentum view tells you whether a name has already discounted the catalyst. - Add the profitability columns:
=OperatingMargin(),=NetProfitMargin(),=ReturnOnEquity(). These are slow-moving but tell you who has the operating leverage if Apple pulls more units. - Add the Exposure Score column as a manual 1-to-5 rating. This is the only column that is qualitative; everything else is data.
- Wire the Portfolio sheet using the math described above. The weighting formula is
=MIN(per_name_cap, (score / total_score) * sleeve_pct). - Wire the Scenario sheet using base EPS, base forward P/E, and the two multipliers per scenario. The modeled price formula is
=base_eps * eps_multiplier * base_pe * pe_multiplier.
The whole workbook should refresh in seconds with the MarketXLS add-in installed. If a QM_ prefixed formula returns an error, it is usually because the QuoteMedia session token has expired. Sign back into the MarketXLS add-in and the streaming feed picks back up.
Download The Templates
Download the Apple WWDC stock tracker excel templates:
- - Pre-filled with representative June 5, 2026 figures. Every cell shows the MarketXLS formula that powers it in the live version.
- - Refreshes on every Excel calculation with the MarketXLS add-in installed.
Both files are free. The live template requires the MarketXLS add-in to pull data; you can install it from the MarketXLS download page or book a live demo.
FAQ
What is an Apple WWDC stock tracker?
An Apple WWDC stock tracker is a spreadsheet that monitors Apple Inc. and its supplier ecosystem in the run-up to and aftermath of Apple's Worldwide Developers Conference. The keynote sets the software and AI narrative for the year, and the supplier base reads through almost immediately based on what is announced. A good tracker combines a watchlist of relevant names with live data, a way to score AI exposure, and scenarios for how each outcome would map to AAPL and ecosystem reactions.
Why does WWDC matter for AAPL and its suppliers?
WWDC is the software event that frames the upcoming hardware refresh cycle. Apple Intelligence has become the primary differentiator on the iPhone roadmap, and the suppliers who provide the silicon, memory, sensors, and AI compute behind it benefit when the keynote shows aggressive new capability. Conversely, if the keynote underwhelms relative to peers, the supplier base sees multiples compress quickly. This is why having a tracker ready for the keynote week, rather than scrambling to build one after, is useful.
Which formulas does the template use?
The template uses verified MarketXLS functions including =Last(), =MarketCapitalization(), =PERatio(), =ForwardPE(), =DividendYield(), =Beta(), =RSI(), =SimpleMovingAverage(), =ChangePercentYTD(), =OperatingMargin(), =NetProfitMargin(), =ReturnOnEquity(), =PriceToSales(), =EnterpriseValueToEBITDA(), and =QM_GetOptionChainActive(). Every formula in the template has been confirmed against the MarketXLS function reference.
Do I need the MarketXLS add-in to use it?
The Sample file works in any Excel installation - it is pre-filled with static numbers so you can see what the live version looks like. The Template file requires the MarketXLS add-in to refresh live data from the formulas. You can install MarketXLS from the main product page or book a live demo before installing.
Can I change the 25-name watchlist?
Yes. Both files are unlocked. To add a name, copy any row in the Main Dashboard sheet and replace the ticker. The formulas reference the ticker cell, so once you change the cell every formula in that row updates. The Portfolio sheet will reweight automatically because the weighting formula references the Exposure Score column.
How is the Exposure Score calculated?
The Exposure Score is a manual 1-to-5 rating that captures how directly a name benefits from a positive WWDC AI catalyst. A 5 means the name is heavily levered to Apple Intelligence adoption (AAPL, AVGO, QCOM, TSM, ARM). A 4 means meaningful read-through (SWKS, QRVO, CRUS, MU, LITE, GLW, JBL, ANET, NVDA). A 3 means broad or secondary exposure through Apple silicon capex or analog content (equipment names, STM, TXN, NXPI, ON, SYNA, MRVL). The Portfolio sheet uses the score to drive weight inside a sleeve.
Is this investment advice?
No. The template is an educational tool. Nothing in this post or in the workbook constitutes financial advice or a recommendation to buy, sell, or hold any security. Always do your own research and consult a qualified financial advisor before making investment decisions.
The Bottom Line
The Apple WWDC stock tracker excel template gives you a single Excel surface for the most important software event of Apple's year. Twenty-five suppliers, foundries, equipment makers, and AI-infrastructure names with live MarketXLS formulas, a scoring system for AI exposure, five outcome scenarios for the keynote, sample option structures around the June 20 expiration, and a position-sizing sleeve you can dial in to your own portfolio.
WWDC 2026 opens at Apple Park on Monday June 8 at 10:00 PT. The fastest way to get ready for the keynote is to have your watchlist live, your scenarios pre-built, and your sizing rules clear before the headlines start rolling. The template does all three.
To install the MarketXLS add-in or see the full library of stock and options functions, visit marketxls.com. To get a live walkthrough of the platform from an analyst on the team, book a demo.
