Option Chain

Returns the complete option chain for an underlying stock using QuoteMedia's data service. The data is returned as a table that can spill into multiple cells.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ, IWM

Parameters

Parameter Type Required Description
Symbol String Yes Underlying stock ticker

Output Columns

The option chain typically includes:

  • Option symbol
  • Expiration date
  • Strike price
  • Call/Put type
  • Bid/Ask prices
  • Last price
  • Volume
  • Open Interest
  • Implied Volatility

Notes

  • This is an array formula that spills into multiple cells
  • Large option chains may take longer to load
  • Data includes all available expirations and strikes

Examples

=QM_GetOptionChain("AAPL")
Full option chain for Apple
=QM_GetOptionChain("SPY")
Full option chain for SPY ETF
=QM_GetOptionChain("TSLA")
Full option chain for Tesla
=QM_GetOptionChain(A1)
Symbol from cell reference

When to Use

  • View all available options for a stock
  • Options trading analysis
  • Build custom option screeners
  • Research available strikes and expirations

When NOT to Use

Scenario Use Instead
Need only ITM options QM_GetOptionChainInTheMoney()
Need only OTM options QM_GetOptionChainOutOfTheMoney()
Need weekly options QM_GetOptionChainWeeklies()
Need monthly options QM_GetOptionChainMonthlies()
Need near-term only QM_GetOptionChainNearTerm()
Need with Greeks QM_GetOptionQuotesAndGreeks()

Common Issues & FAQ

Q: Why is the data taking long to load? A: Large option chains (like SPY) have hundreds of contracts. Consider using filtered versions like QM_GetOptionChainNearTerm().

Q: How do I filter by expiration or strike? A: Use specialized functions like QM_GetOptionChainWeeklies() or QM_OptionFilter() for filtered data.

Q: The data is cutting off. What do I do? A: Ensure you have enough empty cells below and to the right for the data to spill into.

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

Related Functions