Historical Open Interest (Options)

Returns open interest data for a historical date. Useful for analyzing how options positioning has changed over time.

Parameters

Parameter Required Description
Underlying Yes Stock ticker symbol
PastDate Yes Historical date (YYYY-MM-DD)
Direction Yes 'put' or 'call'

Examples

=opt_TotalOpenInterestOptionsHistorical("AAPL", "2024-01-15", "put")
Historical put OI
=opt_TotalOpenInterestOptionsHistorical("SPY", DATE(2024,1,10), "call")
Historical call OI

When to Use

  • Analyzing OI changes over time
  • Tracking positioning shifts
  • Historical options analysis

When NOT to Use

Scenario Use Instead
Need current OI opt_TotalOpenInterestOptions()
Need current volume opt_TotalVolumeOptions()

Common Issues & FAQ

Q: How far back is historical data available? A: Typically 1-2 years of historical OI data is available.

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 Put Interest (Specific Expiry) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions