Russell Reconstitution Tracker Excel: The June 2026 Index Rebalance Dashboard for Advisors

Russell reconstitution tracker Excel - if you are an advisor or self-directed investor trying to make sense of the June 26, 2026 FTSE Russell rebalance, you came to the right place. This guide unpacks the annual reconstitution event, walks through a professional-grade Excel dashboard built to track promotions, demotions, new adds, and style flips, and shows the exact MarketXLS formulas that keep every cell live. Download both the static sample and the live formula version at the bottom of this post.

The Russell reconstitution is the single biggest passive flow event 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

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: Friday, May 29, 2026 - the snapshot used to rank the eligible US universe by total market capitalization.
• Preliminary lists published: Friday, June 5, 2026 - the first official look at the proposed adds and deletes.
• Subsequent updates: Friday, June 12 and Friday, June 19, 2026 - revisions to the preliminary lists as FTSE Russell processes corporate actions and free float adjustments.
• 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 June 5 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, rules-based, and reconstructed once a year. Every eligible US-listed common stock gets ranked by total market capitalization on the last trading day of May. 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 is happening into a market that has rallied for most of the first half. AI infrastructure names (RKLB, SMR, IONQ, ASTS) have run hard. Several fintech names (HOOD, AFRM, DKNG) have crossed into Russell 1000 territory after multi-year recoveries. Legacy media and retail names (WBA, PARA, WBD) have continued to derate. That combination means a heavier-than-typical migration calendar - which is exactly why a dashboard-style tracker earns its keep.

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())

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())

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:

1. Portfolio size ($) - your total dollar value to allocate.
2. Rebalance sleeve weight (%) - the share of the portfolio you are committing to the reconstitution trade. Most advisors run this between 3% and 15%.
3. 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). Rank day is the last trading day of May. The preliminary additions and deletions list is published the first Friday of June, with weekly updates through mid-June. The reconstitution becomes effective at the open of trading the trading day 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 on June 5 and updates it twice more 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 one of the most predictable passive flow events of the year. 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.