Russell 2000 Reconstitution Tracker Excel: June 2026 Rebalance Screener for Adds, Deletes, and Promotions

Russell 2000 reconstitution tracker Excel is the workbook you want open the morning FTSE Russell releases its preliminary additions and deletions list, because the next five weeks rewrite the cap structure of the entire US small-cap universe. The 2026 rebalance is the largest scheduled passive-flow event of the year for stocks priced below ten billion dollars, and the order book leading into reconstitution day usually behaves nothing like the rest of the calendar. This guide walks through the methodology, the dates, the screener logic, and a downloadable Excel template that uses live MarketXLS formulas to flag candidates before the official list hits the wire.

Russell 2000 Reconstitution Tracker Excel: Why It Matters in June 2026

Russell 2000 reconstitution tracker Excel files exist for one reason: the annual June rebalance moves billions of dollars of passive index AUM into a tightly defined set of stocks over a single trading session. iShares Russell 2000 ETF alone manages tens of billions tracking the index, and that does not count the Vanguard Russell 2000 funds, the institutional separate accounts, or the dozens of factor strategies that benchmark against IWM. When FTSE Russell announces additions, those funds become forced buyers on reconstitution day. When deletions hit the tape, the same funds become forced sellers.

The 2026 rank-day snapshot was taken on April 30, which means cap rankings are already locked. What changes between now and June 27 is the public's understanding of who is in and who is out, plus the float adjustments and country-of-incorporation tests that move at the margins. This is why a Russell 2000 reconstitution tracker Excel built on live MarketXLS data has an edge over static spreadsheets: market cap, float, and price all drift between rank day and reconstitution day, and the workbook updates with them.

Key Reconstitution Dates for June 2026

Track these dates carefully. The biggest dispersion between an actual reconstitution outcome and a pre-rank-day forecast usually happens during Updates 1 and 2, when float-share figures get revised based on insider holdings, lockup expirations, and recent secondary offerings.

What the Russell 2000 Reconstitution Tracker Excel Does

The downloadable workbook structures the universe of probable adds, deletes, and promotions across six worksheets so you can move from initial screen to position sizing without leaving Excel. Each sheet pulls live data through MarketXLS formulas in the template version, or shows pre-filled sample data with formula references in the static version.

Inside the Workbook

Every yellow cell with a thick border is a user input. Plug in your portfolio size, your reconstitution cap thresholds, and your long/short ratio, and the rest of the workbook recalculates downstream.

Russell Index Reconstitution Methodology, in Plain English

FTSE Russell uses total market capitalization (price multiplied by total outstanding shares) on rank day to sort the 4,000 largest US-listed stocks. The cuts are simple in concept and brutally mechanical in execution.

• Ranks 1 through 1,000 form the Russell 1000, capturing roughly 92 percent of US equity market value.
• Ranks 1,001 through 3,000 form the Russell 2000, the canonical US small-cap benchmark.
• Ranks 2,001 through 4,000 form the Russell Microcap, which overlaps the lower half of the Russell 2000.

A stock that ranked 800 last year but slid to rank 1,150 this year leaves the Russell 1000 and joins the Russell 2000. A stock that ranked 1,800 last year but climbed to rank 950 leaves the Russell 2000 and joins the Russell 1000. Names that fall below the microcap floor exit the indexes entirely.

The float adjustment is where the methodology becomes nuanced. Even if a stock has a $4 billion total market cap, its index weight is determined by free-float capitalization. Restricted shares, insider holdings above a threshold, and government holdings all reduce the float-adjusted weight. A Russell 2000 reconstitution tracker Excel that ignores float will systematically misprice IPO-class candidates, where lockups and founder stakes can shrink the effective float by 40 to 60 percent.

Why Free Float Matters for Index Arbitrage

The index funds tracking IWM size positions by float-adjusted weight, not by total cap. A stock with $3 billion in market cap and only $400 million in float gets a much smaller passive allocation than a stock with $2 billion in market cap and $1.7 billion in float. This is why the screener uses =FLOATSHARES(symbol) alongside =MARKETCAPITALIZATION(symbol) to flag low-float promotions, where the buying pressure on reconstitution day will be muted relative to a naive cap-only model.

Russell 2000 Reconstitution Tracker Excel: Screener Logic

The Main Dashboard sheet classifies each candidate into one of five buckets based on cap thresholds the user supplies in the input panel. Here is the logic in plain Excel syntax, simplified from the template:

=IF(MarketCap > R1K_Ceiling, "PROMOTE",
 IF(MarketCap < R2K_Floor, "DELETE",
  IF(AND(MarketCap >= R2K_Floor, MarketCap <= R1K_Ceiling,
         Volume * Price >= MinADV,
         Float >= MinFloat),
     "HOLD", "REVIEW")))

The cap ceiling for Russell 1000 inclusion sits around $4 billion as of the 2026 rank-day estimates. The cap floor for the Russell 2000 sits near $300 million on the lower end. Names below that floor get carved out into the Microcap-only band and lose Russell 2000 inclusion.

MarketXLS Functions That Power the Screener

Every cell in the live template uses verified MarketXLS functions. No invented formulas, no scraped data, no manual updates.

=QM_LAST("ALAB")                       Current price
=MARKETCAPITALIZATION("RDDT")          Market capitalization
=FLOATSHARES("DUOL")                   Free float shares
=VOLUME("CAVA")                        Today's trading volume
=FIFTYTWOWEEKHIGH("BIRK")              52-week high
=FIFTYTWOWEEKLOW("BLNK")               52-week low
=PERCENTBELOWFIFTYTWOWEEKHIGH("KVYO")  Distance from 52-week high
=RSI("TOST")                           Relative Strength Index
=BETA("WBD")                           Beta versus market
=PERATIO("INST")                       Price-to-earnings ratio (TTM)
=SECTOR("PARA")                        GICS sector
=SIMPLEMOVINGAVERAGE("DUOL",50)        50-day simple moving average

You can paste any of these into a fresh worksheet and the MarketXLS add-in will refresh them on every recalculation. For the full function library, see the MarketXLS functions page.

Candidate Universe in the Template

The workbook ships with 26 representative names spread across four reconstitution categories. These are illustrative rather than predictive, because the final list depends on rank-day cap data that FTSE Russell controls. The point is to show how the screener separates each bucket so you can replace these tickers with your own watchlist.

Likely Russell 1000 Promotions (Leaving Russell 2000)

These names have rallied hard enough since rank day that their total cap probably puts them above the Russell 1000 floor, which means they migrate up out of the Russell 2000.

• ALAB (Astera Labs) - AI connectivity chips, cap above $14B after the 2024 IPO ramp
• RDDT (Reddit) - communication services, joined R2K after IPO, now scaling up
• BIRK (Birkenstock) - consumer discretionary, listed in late 2023 and migrating up
• KVYO (Klaviyo) - marketing software, right at the R1K/R2K boundary
• DUOL (Duolingo) - learning platform, cap near $19B after the multi-year rally
• CART (Maplebear / Instacart) - delivery platform, climbed above the R1K floor

Likely Russell 2000 New Additions

These names either IPO'd into the eligibility window or migrated down from the Russell 1000 because of a cap decline.

• PRME (Prime Medicine) - clinical-stage biotech, crossed the microcap floor
• CAVA (Cava Group) - restaurant operator, sits below R1K floor and lands in the R2K upper band
• FOUR (Shift4 Payments) - payments technology, share class change drops it into R2K
• WBD (Warner Bros Discovery) - large-cap media name where a cap decline could move it down
• PARA (Paramount Global) - similar migration story across the R1K/R2K boundary
• PYCR (Paycor HCM) - HR software graduate from the IPO class

Likely Russell 2000 Deletions

Names below the Russell 2000 floor get either carved into the Microcap-only band or eliminated entirely.

• BLNK (Blink Charging) - EV charging operator at distressed levels
• HYLN (Hyliion Holdings) - electrified truck powertrains, well below the floor
• RVNC (Revance Therapeutics) - specialty pharma, sub-$500M cap
• VLN (Valens Semiconductor) - chips, microcap range
• BTBT (Bit Digital) - crypto miner trading below floor
• MARK (Remark Holdings) - communication services, penny-stock band

Likely Russell 2000 Holds

These names sit comfortably inside the R2K cap band and the screener flags them as Hold rather than Add or Delete.

• TOST, INST, OLO, ZIP, XPEL, SHOO, CRCT, YETI

Russell 2000 Reconstitution Tracker Excel: Scenario Analysis

The Scenario Analysis sheet stress-tests the screener under different cap-floor assumptions. Three macro regimes are modeled:

• Bear case - small caps sell off into rank day, the cap floor compresses, deletion list expands
• Base case - flat tape, roughly balanced adds and deletes
• Bull case - small caps rally, more names qualify, deletion list shrinks

The Net Flow column is an educational estimate of passive index dollars rebalancing into adds minus deletions. The historical pattern is that adds outperform the benchmark over the four to six weeks leading into reconstitution while deletes underperform, although the trade has been crowded enough in recent years that the absolute basis-point advantage has compressed.

Russell 2000 Reconstitution Tracker Excel: Strategy Sheet

The Strategy tab translates the screener into actual trade setups, with the assumption that you take a long basket of adds and promotes against a short basket of deletes. The workbook calculates stop levels at 8 percent against the entry and targets at 12 percent in the direction of the position, with notes on each setup.

Sample Trade Table from the Template

These are educational scenarios meant to show how the workbook flows from screen to setup. Real-world execution carries borrow costs on shorts, single-name concentration risk, gap risk into pre-reconstitution catalysts, and the possibility of the screener flagging a candidate that FTSE Russell ultimately excludes for float or country-of-incorporation reasons.

Russell 2000 Reconstitution Tracker Excel: Portfolio Allocation

The Portfolio Allocation sheet handles position sizing once the trade list is finalized. It takes five user inputs:

• Total portfolio value in dollars
• Allocation to the index arbitrage sleeve (percent of book)
• Long sleeve weight (percent of sleeve)
• Short sleeve weight (percent of sleeve)
• Maximum per-name position size (percent of book)

The workbook then computes basket capital for longs and shorts, applies the per-name cap, and outputs notional, beta-adjusted notional, share counts, and percent of book for each ticker. Beta adjustment uses =BETA(symbol) so a high-beta delete is allocated less notional than a low-beta one, keeping the net exposure closer to dollar-neutral.

Beta-Adjusted Sizing Example

If your short basket has a weighted average beta of 1.5 and your long basket has a weighted average beta of 1.1, the workbook automatically allocates less notional to the short side per dollar of intended exposure, so the basket does not run a hidden negative beta into a low-vol regime. The math is straightforward: notional dollars divided by beta, summed across the sleeve.

Russell 2000 Reconstitution Tracker Excel: Cap Tier Comparison

The Cap Tier Comparison sheet rounds out the workbook with index ETF proxies and a tier band guide so you can see how the small-cap universe is layered.

The same MarketXLS formulas drive this sheet: =QM_LAST("IWM") for the current price of the iShares Russell 2000 ETF, =FIFTYTWOWEEKHIGH("IWC") for the microcap proxy, and =BETA("IWO") for the small-cap growth tilt.

Download the Russell 2000 Reconstitution Tracker Excel

Download the templates:

• - Pre-filled with sample data and formula references for each cell
• - Live MarketXLS formulas that refresh with real-time data

The sample version is useful as a reference workbook, showing exactly which formulas drive each data cell. The template version requires a MarketXLS subscription to refresh the live data, with full documentation in the MarketXLS knowledge base.

Russell 2000 Reconstitution Tracker Excel: How To Use The Workbook

1. Open both files side by side. The sample shows the reference data; the template shows the live formulas.
2. Edit the Main Dashboard inputs. Set your R1K cap ceiling, R2K cap floor, minimum average daily volume, and minimum float thresholds. The Status column reclassifies automatically.
3. Add your own tickers. Replace any of the 26 sample tickers with names from your watchlist. Every formula references the row's ticker, so the dashboard recalculates instantly.
4. Stress-test on Scenario Analysis. Flex the bear, base, and bull cap-floor assumptions to see how the deletion list expands or contracts.
5. Set up the trade list on Strategy. The sheet auto-fills entry prices, 50-day SMA, RSI, stop, and target levels. Adjust the 8 percent stop and 12 percent target if your risk tolerance differs.
6. Size positions on Portfolio Allocation. Enter your portfolio value, allocation percent, long-short ratio, and max position size. The workbook computes notional and share counts for every name.
7. Cross-check with the official FTSE Russell list when it drops. The May 23 preliminary list is the first hard data point; the June 13 update is near-final.

FAQ: Russell 2000 Reconstitution Tracker Excel

What is Russell 2000 reconstitution?

Russell 2000 reconstitution is the annual rebalancing of the Russell US equity indexes by FTSE Russell. The largest 4,000 US-listed stocks are ranked by total market capitalization on rank day, and the index methodology then sorts those names into the Russell 1000, Russell 2000, and Russell Microcap indexes. Reconstitution effective day is the last Friday of June, and any index fund or ETF that tracks a Russell benchmark rebalances to match the new composition.

When is the 2026 Russell reconstitution effective date?

The 2026 Russell reconstitution effective date is June 27, 2026, at the close of trade. The preliminary additions and deletions list publishes on May 23, with updates on May 30, June 6, and June 13.

What is the difference between Russell 1000 and Russell 2000?

The Russell 1000 contains ranks 1 through 1,000 by total market capitalization (large and mid-cap), while the Russell 2000 contains ranks 1,001 through 3,000 (small-cap). The Russell 3000 combines both. A stock can migrate between the two indexes on reconstitution day if its rank crosses the boundary.

How does an index arbitrage strategy work around Russell reconstitution?

Index arbitrage around Russell reconstitution exploits the forced buying and selling pressure that index funds create on the rebalance date. Traders sometimes go long names that will be added to the Russell 2000 and short names that will be deleted, holding the basket from the preliminary list release in late May through the reconstitution effective date in late June. The trade has historically generated a small positive return, although the basis points captured have compressed as the strategy has become more widely known.

Why does free float matter in Russell index reconstitution?

Free float matters because FTSE Russell uses float-adjusted market capitalization to set index weights, not total market capitalization. A stock with a $3 billion total cap but only $400 million in free float gets a much smaller passive index weight than a stock with $2 billion in total cap and $1.7 billion in float. Reconstitution flows are therefore proportional to float, which is why the workbook surfaces =FLOATSHARES(symbol) alongside =MARKETCAPITALIZATION(symbol).

What tools does the Russell 2000 reconstitution tracker Excel use?

The Russell 2000 reconstitution tracker Excel uses verified MarketXLS functions including =QM_LAST for price, =MARKETCAPITALIZATION for cap, =FLOATSHARES for float, =VOLUME for liquidity, =SECTOR for classification, =BETA for risk-weighted sizing, and =SIMPLEMOVINGAVERAGE for trend filters. Every formula is verified against the MarketXLS function library before being included in the template.

Can I customize the candidate list in the workbook?

Yes. The 26 names in the workbook are illustrative. Replace any ticker in the Main Dashboard sheet with your own watchlist symbol, and every downstream sheet (Scenario Analysis, Strategy, Portfolio Allocation, Cap Tier Comparison) recalculates automatically because each cell references the row's ticker via MarketXLS formulas.

The Bottom Line

Russell 2000 reconstitution tracker Excel workbooks are how serious small-cap traders prepare for the largest passive-flow event on the equity calendar. The 2026 rebalance hits June 27, the preliminary list publishes May 23, and the cap rankings were already locked on April 30. Between now and reconstitution day, the only variables that change are float adjustments, share-class technicalities, and the spread between rank-day cap and current cap. This workbook captures all three on a live MarketXLS data feed.

The screener separates candidates into Promote, Add, Hold, and Delete buckets using cap thresholds you control. The strategy sheet turns the screen into trade setups with stop and target levels. The portfolio allocation sheet sizes the basket against your book size with beta adjustments. And the cap tier comparison ties everything back to IWB, IWM, and IWC so you can see the ETF flows behind the names.

For the full MarketXLS function library and more workbook templates, visit marketxls.com. To see how MarketXLS handles index reconstitution research, options analytics, and portfolio modeling in one Excel add-in, book a demo.

Educational use only. This workbook is a hypothesis tool, not investment advice. Index reconstitution outcomes depend on FTSE Russell's official methodology, and actual additions and deletions are confirmed only on the preliminary list release date and subsequent update dates.