Historical Option Chain
Returns the full options chain data (calls and puts) for a symbol as of a historical date.
Syntax
=mxls.opt_HistoricalOptionChain(Symbol, Date)Examples
=mxls.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
▶
How does MarketXLS work?