A Russell reconstitution tracker in Excel lists the stocks expected to move between Russell indexes at the June 2026 rebalance (promotions from the Russell 2000 to the Russell 1000, demotions, new adds, and style flips) and estimates the passive buying or selling each one faces at the closing auction on Friday, June 26, 2026. The template in this guide pulls price, market cap, returns, beta, and short-interest context with MarketXLS formulas such as =QM_Last("HOOD") and =MarketCapitalization("HOOD"), and computes a days-to-clear figure from average dollar volume. Both a static sample and a live formula version are linked at the bottom of this post.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
The Russell reconstitution is one of the largest passive flow events of the year. ETF trackers like IWB (iShares Russell 1000), IWM (iShares Russell 2000), and IWR (iShares Russell Midcap) collectively hold hundreds of billions in assets, and they all have to rebalance into the new index composition at the closing auction on the rebalance date. Names that move up from Russell 2000 to Russell 1000 see passive selling pressure in the small-cap tracker and buying pressure in the large-cap tracker. Names that move the other direction see the mirror effect. New adds from Russell Microcap or recent IPOs frequently print their largest one-day volume of the year on rebalance day. None of this is mysterious - but it is hard to track without a structured tool. That is what this template is for.
Russell reconstitution tracker Excel: the key data at a glance
| Category | What it captures | Example tickers | Typical passive flow direction |
|---|---|---|---|
| PROMOTE | Russell 2000 -> Russell 1000 | HOOD, AFRM, DKNG, COIN, RBLX | Buy IWB, sell IWM |
| DEMOTE | Russell 1000 -> Russell 2000 | WBA, PARA, LUMN, WBD | Sell IWB, buy IWM |
| ADD | New Russell 2000 addition (from Microcap or IPO) | RKLB, ASTS, ACHR, IONQ, SMR | Buy IWM |
| STYLE | Stays in same index but Value ↔ Growth bucket flips | RIOT, MARA, DOCN, UPST | Buy IWO/IWN |
| BORDER | On the bubble; inclusion depends on final preliminary list | LCID, RIVN, PLUG, JOBY | Monitor only |
The template covers 24 representative reconstitution candidates across all five categories. The dashboard sorts and scores them so you can see at a glance which names look most exposed to forced flows on June 26, 2026.
The 2026 reconstitution calendar
FTSE Russell follows the same schedule every year. The 2026 edition lands on these dates:
- Rank Day: the snapshot date FTSE Russell uses to rank the eligible US universe by total market capitalization.
- Preliminary lists published: the first official look at the proposed adds and deletes, followed by weekly updates as FTSE Russell processes corporate actions and free float adjustments.
Confirm the exact 2026 rank day and list dates on FTSE Russell's published reconstitution calendar, and check whether any additional reconstitution dates apply.
- Final reconstitution effective: open of trading on Monday, June 29, 2026 (the rebalance date itself is the prior Friday close - June 26, 2026 - because that is when index buyside trades go through the closing auction).
For advisors, the window between the preliminary list and June 26 is the one that matters. The preliminary list is when the market starts pricing in the rebalance flow. By the closing auction on June 26, most of the easy alpha has been arbed away - but the rebalance close still routinely produces some of the highest single-day volumes of the year in the affected names. The template is built to make that window structured and trackable.
What is index reconstitution and why does it matter
The Russell US equity indexes are mechanical and rules-based, with the main reconstitution each June. Every eligible US-listed common stock is ranked by total market capitalization on rank day. The top 1,000 form the Russell 1000 (large cap). The next 2,000 form the Russell 2000 (small cap). Together they make up the Russell 3000, which captures roughly 96% to 98% of US public equity market cap. The Russell Midcap is a subset of the Russell 1000 covering positions 201 through 1,000.
This sounds dry, but the practical consequence is real money. Every fund that tracks one of those indexes - including the iShares ETF family that anchors most passive small-cap and large-cap allocations - must rebalance to the new composition. When a stock moves from Russell 2000 to Russell 1000, IWM has to sell it. IWB has to buy it. That trade routes through the closing auction on rebalance day, which is why volumes are so concentrated.
Academic research has documented a measurable price drift in index addition candidates during the run-up window. Madhavan (2003) and Chen, Noronha, and Singal (2004) both found statistically significant excess returns in the days between the rank day and the rebalance effective date. The size of that effect has compressed over time as more capital arbs the trade - it was 5% to 8% in the early 2000s, now closer to 1% to 3% on average - but a positive drift in additions and a negative drift in deletions is still observed in most years.
The 2026 reconstitution follows a first half in which AI infrastructure names (RKLB, SMR, IONQ, ASTS) rallied, several fintech names (HOOD, AFRM, DKNG) grew toward Russell 1000 size, and legacy media and retail names (WBA, PARA, WBD) derated. Those moves make the migration list worth tracking closely. Check each name against the official preliminary list, since index membership in the template is illustrative.
What's inside the template
The premium template ships with 10 sheets, each one purpose-built for a specific job. This is not a screener with a single big table. It is a designed workbook meant to look presentation-ready on first open.
- Cover. Branded title page with workbook name, edition, rebalance date, table of contents, and a credit line. Hidden gridlines. Navy banner block with gold accent type.
- How To Use. Step-by-step tutorial covering all eight workflow steps from setting inputs through reading correlations. Every formula referenced elsewhere is documented here.
- Dashboard. The headline sheet. Five KPI tiles across the top - Promotions, Demotions, New Adds, Style Flips, and Net Passive Flow. Below the tiles, a screener with all 24 candidates and conditional formatting (color scales on the Score column, data bars on the YTD and 1Y return columns, arrow icons on the Direction column). Two embedded native Excel charts: a category bar chart and a sector pie chart.
- Inputs & Controls. Dedicated input sheet. Yellow-highlighted cells with thick gold borders, data validation dropdowns for Scenario (Conservative / Base / Aggressive) and Risk Tolerance (1 to 5). Includes a watchlist toggle for each candidate.
- Migration Analysis. Per-name deep dive. Current index, projected index after rebalance, current weight, projected weight, weight delta in basis points, projected passive flow in dollars, and a days-to-clear estimate based on average daily dollar volume. Color-scaled flow column.
- Rebalance Strategy. Actionable playbook per category. Entry price (T-20 trading days), target, stop, break-even (slippage-adjusted), hold days, risk per share, reward per share, and reward-to-risk ratio. R:R column is color-scaled.
- Portfolio Allocation. Position sizing tied to the Inputs sheet. Equal weight, conviction weight, dollar allocation, share count, direction, and pre vs post-slippage notional. Totals row at the bottom.
- Sector Correlation. Matrix of 30-day rolling correlations between each candidate and IWB, IWM, IWR, SPY, QQQ, IWO, IWN, and VXF. Three-color heatmap (red / amber / green) across the entire matrix.
- Methodology. One page explainer covering rank day mechanics, eligibility, free float adjustment, style classification, cap tiers, the reconstitution date sequence, quarterly IPO additions, passive flow mechanics, the historic outperformance window, and limitations.
- Glossary & Disclaimer. Definitions for every term in the workbook plus the educational-only disclaimer.
Every sheet has a footer block listing the exact MarketXLS formulas it uses, with one-line descriptions, so you know which functions to lift if you want to build something similar from scratch.
Russell reconstitution tracker Excel: dashboard walk-through
Open the file. The Cover sheet greets you with the navy banner and the table of contents. Click the Dashboard tab. The top of the sheet is dominated by five KPI tiles. Each tile shows a big number in 24-point bold navy, a label above in muted gray small caps, and a small colored delta below. The Net Flow tile aggregates the total estimated passive flow across all 24 candidates - if it is positive, the consensus migration adds more dollars to small caps than it removes; if it is negative, the opposite.
Beneath the tiles sits the screener. Eighteen columns: ticker, name, sector, category, price, market cap, current index, projected index, current style, projected style, YTD return, 1Y return, beta, price-to-book, short interest, projected passive flow, direction (arrow icon), and score. The score is a composite of passive flow, one-year momentum, short interest, and direction. Higher is more attractive on the long side; lower is more attractive on the short side. The score column uses a three-color scale, so the green names at the top jump out instantly.
Below the screener you will find the two embedded charts. The bar chart counts candidates by category - promote, demote, add, style flip, border. The pie chart shows the sector mix. Both are styled to match the workbook palette (MarketXLS blue and supporting accents). Hidden gridlines and a set print area keep the sheet looking clean when you export.
The MarketXLS implementation
The template version of the file uses only verified MarketXLS formulas. No invented function names. Here is a representative slice of what powers the live edition:
=IFERROR(QM_Last("HOOD"),NA())
=IFERROR(MarketCapitalization("HOOD")/1000000000,NA())
=IFERROR(Name("HOOD"),"Robinhood Markets Inc.")
=IFERROR(Sector("HOOD"),"Financials")
=IFERROR(Industry("HOOD"),"Capital Markets")
=IFERROR(Beta("HOOD"),NA())
=IFERROR(PriceToBook("HOOD"),NA())
=IFERROR(StockReturnOneYear("HOOD"),NA())
=IFERROR(StockReturnSixMonths("HOOD"),NA())
=IFERROR(StockReturnThreeMonths("HOOD"),NA())
=IFERROR(FiftyTwoWeekHigh("HOOD"),NA())
=IFERROR(FiftyTwoWeekLow("HOOD"),NA())
=IFERROR(ReturnOnEquity("HOOD"),NA())
=IFERROR(OperatingMargin("HOOD"),NA())
=IFERROR(DividendYield("HOOD"),NA())
=IFERROR(StockReturnCorrelation("HOOD","IWM",30),NA())
Formula documentation: QM_Last, MarketCapitalization, Name, Sector, Industry, Beta, PriceToBook, StockReturnOneYear, StockReturnSixMonths, StockReturnThreeMonths, FiftyTwoWeekHigh, FiftyTwoWeekLow, ReturnOnEquity, OperatingMargin, DividendYield
Each formula is wrapped in an IFERROR so the workbook stays presentation-ready even if a ticker is briefly unavailable. The sample edition of the file pre-fills static values from the June 14, 2026 snapshot and adds a comment to each data cell showing the exact MarketXLS formula that would have produced it. That way users can lift the formula into their own spreadsheets without having to retype it.
The Migration Analysis sheet computes a Days to Clear column from average daily dollar volume:
=IFERROR(ABS(PassiveFlow)/MAX(AvgVol*QM_Last("HOOD"),1),NA())
Formula documentation: QM_Last
That number tells you how many days of typical trading it would take to absorb the rebalance flow at the closing auction. Names with very low days-to-clear are likely to print outsized prints on rebalance day. Names with multi-day clearance numbers may bleed pressure across the entire reconstitution window.
The Sector Correlation sheet uses StockReturnCorrelation against eight reference tickers. You can swap any of those references for your own benchmark by editing a single ticker in the column header. The whole matrix recalculates.
Russell reconstitution tracker Excel: how to use the scenario controls
The Inputs & Controls sheet is the brain of the workbook. Three controls drive almost everything downstream:
- Portfolio size ($) - your total dollar value to allocate.
- Rebalance sleeve weight (%) - the share of the portfolio you are committing to the reconstitution trade. Most advisors run this between 3% and 15%.
- Scenario dropdown - Conservative / Base / Aggressive. The scenario drives the conviction multipliers on the Portfolio Allocation sheet and tilts the target and stop levels on the Rebalance Strategy sheet.
The risk tolerance slider (1 through 5) and the conviction multipliers for PROMOTE and DEMOTE categories let you fine-tune how aggressively you size into directional names. A risk tolerance of 1 caps individual position weight tightly and keeps the sleeve close to equal weight. A risk tolerance of 5 lets the conviction multiplier push high-conviction names up to the per-name cap.
A practical workflow: pick a base scenario, set the sleeve weight to 5% to 10%, set risk tolerance to 3, and let the conviction multiplier do the work. The Portfolio Allocation sheet will tell you how many shares of each candidate to buy or short, plus the pre and post-slippage notional. The slippage assumption defaults to 30 basis points round trip; tune it to your execution quality.
Why a dashboard-style template for this trade
Most index reconstitution analysis lives in screenshot PDFs from sellside research or in academic papers. Neither is quick to use during the actual rebalance window. A dashboard-style Excel workbook is a better fit for the job for three reasons:
First, the variables that matter are mechanical. Market cap rank, free float, current weight, projected weight, average volume, short interest. None of these need narrative analysis to be useful - they just need to be visible and comparable. A KPI tile row and a conditional-formatted screener show all of them in one view.
Second, the time horizon is short. The actionable window is roughly three weeks (preliminary list to rebalance close). Building a model from scratch under that constraint is a waste of time. A workbook that already has the structure, the formulas, the scenarios, and the position sizing lets you focus on the candidates themselves.
Third, the trade is repeatable. The 2026 reconstitution is one of dozens. If you build a structure once, you can reuse it every June. The Methodology and Glossary sheets are deliberately written so the workbook stays useful for the 2027 and 2028 reconstitutions with minimal rework.
What about the IPO add window
FTSE Russell adds eligible IPOs quarterly - in March, June, September, and December - if they meet the cap and float thresholds. The June quarterly add coincides with the annual reconstitution, so most new IPOs of the prior twelve months that meet the thresholds get added on June 26, 2026.
For 2026, the recent IPO calendar has been narrow. The candidates worth tracking are the names that crossed the size threshold via secondary offerings rather than fresh IPOs - including several AI infrastructure and quantum computing names. The template covers six of those in the ADD category.
How the template handles style flips
Style flips are the weakest signal of the four categories. A stock that moves from Russell 2000 Value to Russell 2000 Growth (or vice versa) stays in the same headline index. The only forced flow comes from the smaller style ETFs - IWO (Russell 2000 Growth) and IWN (Russell 2000 Value) for the small-cap style buckets, and the IWF / IWD pair for the large-cap style buckets.
Because the style ETFs hold a fraction of what IWM and IWB hold, the dollar volume of the forced flow is smaller. The template flags style flips as "PAIR" trades on the Rebalance Strategy sheet, with tighter targets (1% to 2%) and tighter stops. The expected hold is shorter, and the right execution is typically a pair trade against the receiving style ETF rather than an outright directional bet.
FAQ
What is the Russell reconstitution and when does it happen each year? The Russell reconstitution is the annual rebalance of the FTSE Russell US equity indexes (Russell 1000, Russell 2000, Russell 3000, Russell Midcap). FTSE Russell ranks the universe on rank day, publishes preliminary additions and deletions lists, and updates them weekly. The reconstitution becomes effective at the open of trading after the last Friday in June. For 2026 the effective date is the open on Monday, June 29 - which means the rebalance close happens at the closing auction on Friday, June 26, 2026.
Why do Russell reconstitution candidates move on the rebalance date? ETFs and mutual funds that track the Russell indexes must rebalance to the new composition. The largest demand to buy and sell goes through the closing auction on rebalance day. Names that are added to a large index (IWB) typically see passive buying; names that are removed see passive selling. The effect can be material in small caps with thin liquidity, especially new adds.
Can I predict which stocks will be added to the Russell 2000 in 2026? Predicting individual additions before the official preliminary list (early June) involves judgment about the precise cap and float cutoffs. The thresholds move year to year based on the overall market cap distribution. Several quantitative shops publish projected lists; FTSE Russell publishes the official preliminary list and updates it before the rebalance. Use the template as a structure to track the published preliminary list, not as a forecast.
How can advisors use a Russell reconstitution tracker Excel template? Advisors use the template to (1) communicate the rebalance event to clients ahead of the date, (2) frame any tactical trades around the closing auction window, (3) avoid surprise volatility in names already in the client's portfolio that happen to be reconstitution candidates, and (4) calibrate cash flow needs around the rebalance close. The dashboard-style format keeps the conversation visual and quick.
Does the Russell reconstitution still offer alpha? The classic Russell reconstitution arbitrage (long additions, short deletions in the run-up window) has compressed over time as more capital trades the strategy. Academic research documented 5% to 8% excess returns in the early 2000s; current studies put it closer to 1% to 3% on average, with high dispersion. The template treats the trade as educational - not as a recommendation - and the Rebalance Strategy sheet uses scenario-based targets rather than promised returns.
Which MarketXLS formulas does the template rely on?
The headline formulas are QM_Last, MarketCapitalization, Name, Sector, Industry, Beta, PriceToBook, StockReturnOneYear, StockReturnSixMonths, StockReturnThreeMonths, FiftyTwoWeekHigh, FiftyTwoWeekLow, ReturnOnEquity, OperatingMargin, DividendYield, and StockReturnCorrelation. Every formula is wrapped in IFERROR for graceful fallback. The full list with descriptions is in the footer of every sheet.
Download the templates
Download the full premium template free. Both editions are professional-grade, designed to be presentation-ready on first open, and free to share with clients and colleagues.
- - Pre-filled with snapshot data from June 14, 2026. Every data cell has a comment showing the MarketXLS formula that would produce it.
- - All numbers are live MarketXLS formulas. Open in Excel with the MarketXLS add-in installed and the workbook recalculates on demand.
Both files ship with the same 10-sheet structure, the same KPI dashboard, the same conditional formatting, and the same scenario controls.
The bottom line
The 2026 Russell reconstitution is a predictable passive flow event. The mechanics are public, the calendar is fixed, and the forced buying and selling at the rebalance close are real. A dashboard-style Excel tracker built around MarketXLS formulas gives advisors and self-directed investors a structured way to watch the migration, frame the position sizing, and explain the event to clients without reinventing the wheel every year.
The template is educational. It is not a forecast and it is not investment advice. Read the Methodology sheet, read the Glossary & Disclaimer sheet, and treat the candidate list as a starting point for your own research.
If you want to see how the live formula edition behaves with the MarketXLS add-in installed, head to marketxls.com or book a demo and we will walk you through the workbook in fifteen minutes.
Markets keep moving. Templates like this exist so advisors and self-directed investors can move with them - without spending the night before rebalance day rebuilding a spreadsheet from scratch.
