IV Rank Screener Excel: June 2026 High Implied Volatility Premium Selling Dashboard

IV Rank Screener Excel - if you are an options seller staring at a low-VIX June tape and trying to figure out which 30 names actually have premium worth collecting before the Q2 2026 reporting cycle kicks off in mid-July, this guide and the matching MarketXLS templates were built for exactly that workflow. Realized volatility across the S&P 500 has compressed through the spring, but single-name implied volatility is still scattered, with mega-cap tech, biotech, retail, and a handful of cyclicals showing elevated IV Rank readings into earnings windows. The screener below ranks 30 liquid optionable names by IVRANK1YEAR, layers in IV percentile and 30-day implied vol, ties each row to its next earnings date, and feeds the results into a short-strangle IV-crush scenario engine and a portfolio sizing sheet that respects your account constraints.

IV Rank Screener Excel: June 2026 Setup at a Glance

The table below is the headline view from the workbook. Sample values are shown for illustration; the companion MarketXLS template recalculates every figure with live formulas the moment you open it.

Values approximate as of June 16, 2026. The MarketXLS template version pulls live IV, prices, and earnings dates the moment you open it in Excel.

IV Rank Screener Excel: Why Rank Beats Raw IV

Raw implied volatility on its own is a noisy signal. A 35% IV on Nike is rich; a 35% IV on Tesla is sleepy. IV Rank fixes that by re-scoring every name on a 0 to 100 ladder against its OWN trailing-year IV range:

• IV Rank = 0 means current 30-day IV is sitting at the LOWEST point of the last 12 months
• IV Rank = 100 means current 30-day IV is sitting at the HIGHEST point of the last 12 months
• IV Rank = 50 means current IV is at the midpoint of the prior year's range

Premium sellers care about IV Rank because mean reversion in IV is one of the most well-documented patterns in options markets. A name with an IV Rank above 70 is, by definition, sitting near the top of its own IV history. The base rate for "vol mean-reverts lower" is meaningfully higher than for "vol breaks out higher and stays there," especially after the elevated catalyst that drove the spike (an earnings report, an FDA decision, a guidance shock) clears.

The MarketXLS function that delivers this is a single call:

=IVRANK1YEAR("NVDA")

Pair it with IMPLIEDVOLATILITYPCT1Y for the percentile cousin (it asks the slightly different question of "what fraction of the prior year's IV observations are below current?") and IMPLIEDVOLATILITY30D for the raw 30-day reading, and you can stop guessing whether premium is actually rich.

The June 2026 Vol Backdrop

A few things make this an interesting moment to run an IV Rank screen, and they are the reason the workbook is dated to mid-June 2026.

The macro tape is quiet, but single names are not. Index vol (VIX in the low-to-mid teens through early June) is suppressed by carry trades, mechanical vol sellers, and a tape that has spent the spring grinding higher with shallow pullbacks. That makes index premium thin and pushes premium-selling activity DOWN the cap stack into single names where idiosyncratic catalysts still produce IV expansion.

Q2 2026 reporting season is the next big vol event. Big banks lead off the week of July 14 (JPM, GS, MS). Mega-cap tech reports the final week of July (MSFT, META, AAPL on July 29-31; GOOGL July 23). Semis report in early August (AMD July 29, NVDA traditionally late August). Healthcare and consumer staples stretch through mid-August. Every single name with an earnings date in the next 30 to 60 days carries a vol-of-vol premium that the screener flags.

Q2 guides are unusually consequential. With the Fed meeting on June 17 and 18 and the dot plot revising rate expectations into year-end, every Q2 earnings call will be parsed for forward guidance more than usual. That keeps single-name IV elevated even when the index sits still.

Pre-earnings IV drift is back. The classic pattern - IV builds in the 30 days before a print, then collapses post-event - is alive and well across the optionable universe in 2026. The screener identifies the names where that drift is already underway.

How the IV Rank Screener Excel Workbook is Structured

The companion workbook ships with six sheets so you can move from "find a candidate" to "size the trade" in a single file.

1. How To Use

A tutorial page that walks through the workbook, explains every input cell, and lists the MarketXLS functions powering the screener. The sample version also includes the static data date so you know when the figures were captured.

2. Main Dashboard

The headline IV Rank screener. Five yellow input cells (Portfolio Size, Risk Per Trade, Minimum IV Rank, Target DTE, Strikes Width) drive every downstream calculation. Five KPI tiles summarize the universe (average IV Rank, count of names above 70, count above 60, average 30-day IV, names with earnings in the next 30 days). Below the tiles, the 30-name screener table ranks every ticker with a color-scaled IV Rank column, data bars on IV 30d and IV 60d, and a Verdict column that returns "Strong Sell Premium," "Sell Premium," or "Wait" based on the IV Rank cutoff in your input panel.

3. Scenario Analysis

A short-strangle IV crush model. Pick an underlying, enter spot price and current IV, and the table walks through seven scenarios (pre-earnings, +20% IV expansion, post-earnings -30% crush, post-earnings -50% crush, vol re-expansion, realized-vol drift) and shows what the strangle is worth in each one. The Open P&L column compares each scenario against the opening credit so you can see exactly how much of the premium you have captured. Methodology notes spell out that the model is a simplified Black-Scholes approximation and that real fills depend on skew, term structure, and live mid quotes.

4. Strategy Map

A decision matrix that pairs each IV Rank band with the right premium-selling structure. Iron condors and short strangles dominate the rich and very-rich bands (60+ and 80+). Bull put spreads and cash-secured puts fit the normal band (40 to 59). Calendars and diagonals win in the quiet band (20 to 39). Long premium structures finally make sense when IV Rank slips below 20. A separate Earnings Window section explains how to adjust the rule when EARNINGS_DATE sits inside 7 days, 8 to 30 days, or beyond 60 days.

5. Portfolio Allocation

Position sizing for defined-risk credit spreads. The sheet pulls Portfolio Size and Risk Per Trade from the Main Dashboard, computes Capital at Risk and Max Loss per spread from your strike-width input, and recommends contract counts and buying-power usage for eight high-IV-Rank candidates. A concentration rules-of-thumb panel keeps you honest about not stacking premium-selling buying power above 30 to 40% of net liquidation value.

6. Sector Correlation

Aggregates IV Rank by GICS sector with averages, max, min, dispersion, and a heat-mapped Hottest / Warm / Neutral / Cool column. When two sectors light up Hottest at the same time, it is usually a regime change, not idiosyncratic noise - the panel explains exactly what to do when that happens.

MarketXLS Implementation: The Formulas That Power It

Every cell in the template that touches data is a verified MarketXLS function. The screener leans on a compact set:

=IVRANK1YEAR("NVDA")              => IV Rank, scaled 0-100, trailing 1 year
=IMPLIEDVOLATILITYPCT1Y("NVDA")   => IV Percentile, trailing 1 year
=IMPLIEDVOLATILITY30D("NVDA")     => 30-day interpolated IV
=IMPLIEDVOLATILITY60D("NVDA")     => 60-day interpolated IV
=EARNINGS_DATE("NVDA")            => Next scheduled earnings report
=QM_Last("NVDA")                  => Current last-trade price
=Sector("NVDA")                   => GICS sector classification
=Beta("NVDA")                     => Beta vs the broad market
=MarketCapitalization("NVDA")     => Market cap for liquidity check

Want to add a name to the universe? Drop the ticker into the next empty row and copy the formula columns down. The KPI tiles, sector aggregates, and scenario engine all read from the Screener sheet, so they update automatically.

Filtering the Screener Live

Native Excel filtering plays nicely on top of the MarketXLS columns. Two filters worth knowing:

• Liquidity gate: Add a helper column with =MarketCapitalization("NVDA") and filter for >= 20,000,000,000. Tight bid-ask spreads matter more for short-premium structures than for buying a single contract, and a $20B cap floor is a sensible starting point.
• Earnings window: Filter the EARNINGS_DATE column for dates within the next 21 days. That subset is where pre-earnings IV drift is most pronounced.

Pulling Live Option Chains for Strike Selection

Once a candidate clears the screen, the next decision is which strikes to short. MarketXLS hands you the chain on demand:

=QM_GetOptionChainActive("NVDA")

That returns the active chain in a spillover range with bid, ask, mid, volume, open interest, and delta. Sort the table by absolute delta, target the 15 to 20 delta short legs for a high-probability iron condor, and confirm OI is at least 10x your intended contract count before sending the order.

Strategy Hypothesis: Selling Premium Into IV Rank > 70 Names

The educational hypothesis the workbook supports is straightforward: in a low-VIX, narrow-range tape with high single-name IV dispersion (which is exactly the June 2026 setup), the highest-expected-value premium-selling trades sit on the small subset of names with IV Rank above 70 AND a near-term earnings catalyst.

The intuition has three parts:

1. IV Rank > 70 means mean reversion is likely. The base rate favors lower IV from these levels, even if the path is bumpy.
2. The earnings catalyst means the IV crush event has a fixed, knowable date. You are not selling premium against an unbounded waiting game.
3. Single-name IV dispersion is wider than index IV. You collect more premium per unit of buying power on the right single name than on a comparable SPY iron condor.

The workbook is not a recommendation to sell premium on these names. It is a research tool that surfaces the candidates, shows you the IV-crush math, and helps you size the trade against your account. The "Strong Sell Premium" verdict in column J is a screener verdict on relative IV, not a stock recommendation. Always validate liquidity, news flow, and your own risk tolerance before opening any short-premium position. Options strategies can produce losses larger than the initial premium collected, especially undefined-risk structures like short strangles.

What the Sector Heat Map Tells You in June 2026

Running the sector aggregate against the sample universe lights up a recognizable pattern: Consumer Discretionary (RH, LULU, ULTA, TSLA, NKE) and Healthcare (MRNA, PFE, LLY, UNH) tend to lead average IV Rank in June, driven by retail earnings clustering in late August and biotech catalyst risk. Technology shows the widest dispersion because mega-caps (AAPL, MSFT) sit at moderate IV Rank while pre-earnings semis (MU, NVDA, AMD) and high-growth software (CRWD, SNOW, PLTR) sit at the rich end of the band. Financials are typically the lowest of the major sectors because their IV deflates fast after the mid-July earnings sweep.

Read across to the Spread (Max-Min) column to find sectors where one or two outliers are dragging the average up. Those are usually the most actionable names because the rest of the sector is normal-vol and the outlier is the one with the catalyst.

Risk Management Built Into the Template

Premium selling has an asymmetric payoff. You collect a small known credit and are exposed to a larger (or, for naked short strangles, unbounded) loss. The workbook bakes three guardrails into the design:

• The Risk Per Trade input is set to 2% of portfolio size by default. That converts cleanly into a Max Loss per spread that the Portfolio Allocation sheet uses to compute contract counts.
• The Sector Correlation panel discourages stacking buying power into a single sector by surfacing average IV per sector. If three of your eight positions are in Consumer Discretionary you can see the concentration before you size up.
• The Strategy Map steers you toward DEFINED-risk structures (iron condors, credit spreads) at the rich end of the IV Rank band where the temptation to sell naked strangles is highest. The matrix is opinionated on purpose.

Use the inputs to make the workbook honest to your account. A 250,000 dollar portfolio risking 2% per trade can absorb a 5,000 dollar max loss per spread. A 50,000 dollar account at the same risk percentage cannot, and the contract-count cell will tell you so by returning a small whole number or zero. The spreadsheet will not save you from a bad trade, but it will stop you from sizing a trade too large for the account.

Combining the Screener with Earnings Calendar Discipline

The single biggest mistake new premium sellers make is selling premium on the wrong side of an earnings event. The workbook builds the calendar in for a reason.

Selling premium INTO an earnings print (last 7 days before the report) captures the maximum IV crush but accepts binary gap risk. Only do this with strictly defined-risk structures (iron condors, credit spreads) sized so the max loss is genuinely something you can absorb.

Selling premium 30 to 45 days OUT of an earnings print is the sweet spot. You pick up the pre-earnings IV build as the date approaches, then close at 50% max profit either before the print or shortly after. The 30 DTE default in the Main Dashboard input panel is calibrated for exactly this rhythm.

Selling premium when EARNINGS_DATE is beyond 60 days or in the past is a pure regime trade. Track the VIX, the sector ETF IV, and the macro calendar (FOMC, CPI, jobs) alongside the single name. The screener still flags rich premium, but you are no longer harvesting a knowable catalyst.

Download the Templates

Download both files (free):

• - pre-filled with June 16, 2026 illustrative values so you can preview every sheet
• - live IVRANK1YEAR, IMPLIEDVOLATILITY30D, EARNINGS_DATE and QM_Last formulas across all 30 universe names

Both workbooks include the full six-sheet layout (How To Use, Main Dashboard, Scenario Analysis, Strategy Map, Portfolio Allocation, Sector Correlation) and a hidden Screener helper sheet that powers the KPI tiles and sector aggregates.

IV Rank Screener Excel: Frequently Asked Questions

What is a good IV Rank to sell premium?

Most premium-selling frameworks treat IV Rank above 50 as the minimum threshold, with the strongest setups in the 70 to 100 band. Below 50, raw premium is usually too thin to compensate for the tail risk. The Main Dashboard input cell defaults to 60 so the screener returns a manageable shortlist; lower it to 50 for a broader watchlist or raise it to 80 to focus on only the richest names.

How is IV Rank different from IV Percentile?

IV Rank scales current IV against the trailing-year range using only the high and low values: (Current IV - 52w Low IV) / (52w High IV - 52w Low IV). IV Percentile asks "what fraction of the trailing-year IV observations are LOWER than current?" Both land in a 0 to 100 scale but they answer slightly different questions. The workbook reports both via IVRANK1YEAR and IMPLIEDVOLATILITYPCT1Y so you can sanity-check each name with two independent reads.

Which MarketXLS functions does the IV Rank screener use?

The screener uses IVRANK1YEAR, IMPLIEDVOLATILITYPCT1Y, IMPLIEDVOLATILITY30D, IMPLIEDVOLATILITY60D, EARNINGS_DATE, QM_Last, Sector, Beta, and MarketCapitalization. Each function is documented in the MarketXLS function library and verified against the live add-in before the template ships. See the MarketXLS feature library for the full function reference.

Can I add more tickers to the screener?

Yes. Drop a ticker into the next empty row of the Main Dashboard or Screener sheet and copy the formula columns down. The KPI tiles, sector aggregates, and scenario engine read from the Screener sheet, so they pick up new rows automatically. We sized the default universe at 30 names because that fits on one screen, not because the formulas care.

Does the workbook tell me which strikes to short?

The strategy map points you toward the right structure for the current IV Rank band, but specific strike selection happens in the live option chain. Use =QM_GetOptionChainActive("NVDA") (or whichever ticker) in a fresh sheet, sort by absolute delta, and target 15 to 20 delta short legs for high-probability iron condors. Always confirm bid-ask spreads and open interest before sending the order.

How often should I rerun the screener?

For premium-selling, weekly is plenty. IV Rank moves slowly because the 52-week range only updates a fraction at a time. Running the screen every Monday morning, then again the day before any new earnings date enters the 30-day window, keeps you on top of the universe without overtrading.

Does this workbook work in Google Sheets?

No. MarketXLS functions run inside Microsoft Excel via the MarketXLS add-in. The sample (static) version opens anywhere, but the live formulas require Excel with the add-in enabled. See MarketXLS pricing for plan options or book a demo to see the live add-in.

The Bottom Line

The IV Rank Screener Excel workbook turns a sprawling options universe into a one-screen view of where premium is rich, where the earnings catalyst is, and how to size the trade. In a June 2026 tape where the VIX is sleeping but single-name IV is scattered, that focus is the difference between collecting meaningful credit and chasing thin premium across too many positions.

The combination of IVRANK1YEAR for the screen, IMPLIEDVOLATILITY30D for the regime check, EARNINGS_DATE for the catalyst window, and the strategy map for structure selection is everything most premium sellers actually need in one workbook. Layer the Portfolio Allocation sizing on top and you have a research-to-execution flow that respects both the math and your account.

Download the sample to see the layout, download the template to run it live, and visit marketxls.com for the rest of the MarketXLS function library. If you would rather see the workbook walked through live, book a demo and we will show you how IV Rank, IV Percentile, and the option-chain functions fit together for a complete premium-selling workflow.

Educational use only. Nothing in this post is investment advice. Options trading involves substantial risk of loss and is not suitable for every investor. Always do your own due diligence and consult a qualified professional before opening any position.