Returns the full options chain data (calls and puts) for a symbol as of a historical date.

Examples

=opt_HistoricalOptionChain("AAPL", DATE(2024,1,15))

When to Use

  • Historical options analysis
  • Backtesting strategies

When NOT to Use

Scenario Use Instead
Current chain opt_OptionChain()

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 Historical Option Chain and Other Financial Formulas
How does MarketXLS work?

Related Functions