Open Interest

Returns the open interest (number of open contracts) for an option or futures symbol.

Parameters

Parameter Type Required Description
Symbol string Yes Option or futures symbol

Examples

=OpenInterest("AAPL240315C00170000")
Apple call OI
=OpenInterest(OptionSymbol("AAPL",DATE(2024,3,15),"Call",170))
Using OptionSymbol

When to Use

  • Options analysis
  • Liquidity assessment
  • Market sentiment

When NOT to Use

Scenario Use Instead
Historical OI Open_Interest_Historical()

Common Issues & FAQ

Q: What is open interest? A: Total number of outstanding contracts not yet settled.

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 Open Interest and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions