MarketXLS

Unusual Option OI Scan EOD

Scans the entire options market for individual contracts with unusual open interest levels. This end-of-day scan identifies specific strikes and expirations with notable positioning.

Parameters

Parameter Required Description
NumberOfRecords Yes Number of results to return
OptionType No All, Call, or Put (default: All)
Country No Country filter (default: US)
InstrumentType No All, Stock, or ETF (default: All)

What This Scans For

  • Individual contracts with unusually high OI
  • Contracts with significant OI changes
  • Specific strike/expiration combinations
  • Potential key levels and hedging activity

Output Information

Returns specific option contracts including:

  • Full option symbol
  • Open interest level
  • OI change
  • Related metrics

Notes

  • EOD scan runs after market close
  • Identifies specific contracts, not just underlying
  • Can filter by calls or puts

Syntax

=opt_UnusualOptionOIScanEOD(NumberOfRecords, [OptionType], [Country], [InstrumentType])
Excel Desktop (Windows)

Parameters

numberOfRecordsnumberRequired
optionTypestring
countrystring
instrumentTypestring

Returns

array

Array of option contracts with unusual open interest

Examples

=opt_UnusualOptionOIScanEOD(10)
Top 10 unusual OI contracts
=opt_UnusualOptionOIScanEOD(10, "Call")
Calls only
=opt_UnusualOptionOIScanEOD(10, "Put")
Puts only
=opt_UnusualOptionOIScanEOD(5, "All", "US", "Stock")
Stocks only
=opt_UnusualOptionOIScanEOD(5, "All", "US", "ETF")
ETFs only

When to Use

  • Find specific contracts with unusual positioning
  • Identify key strike prices with high OI
  • Analyze hedging and institutional activity
  • Discover potential support/resistance levels
  • Screen for contract-level opportunities

When NOT to Use

Scenario Use Instead
Need underlying-level activity opt_UnusualStockOptionsActivity()
Need unusual volume scan opt_UnusualOptionVolScanEOD()
Need OI leaders by stock opt_OptionsOILeaders()
Need OI change leaders opt_OptionsChangeInOILeaders()

Common Issues & FAQ

What makes OI "unusual" at contract level?

Contracts are flagged when their OI significantly exceeds historical norms for similar strikes/expirations.

When is this data available?

This is an end-of-day scan. Data updates after market close when OI is calculated.

Why filter by calls or puts?

Filtering helps identify directional sentiment. Unusual call OI may indicate bullish positioning, unusual put OI may indicate bearish or hedging activity.

Excel Templates Using Unusual Option OI Scan EOD

These ready-made MarketXLS templates call opt_UnusualOptionOIScanEOD() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Options formulas you can use in the same worksheet:

See opt_UnusualOptionOIScanEOD used in a complete workbook: MCP Options Order Flow Server: Read Options Flow in Claude and Excel (2026)

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Unusual Option OI Scan EOD and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions