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

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

Q: What makes OI "unusual" at contract level? A: Contracts are flagged when their OI significantly exceeds historical norms for similar strikes/expirations.

Q: When is this data available? A: This is an end-of-day scan. Data updates after market close when OI is calculated.

Q: Why filter by calls or puts? A: Filtering helps identify directional sentiment. Unusual call OI may indicate bullish positioning, unusual put OI may indicate bearish or hedging activity.

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