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
Syntax
=QM_GetOptionChain(Symbol)Examples
=QM_GetOptionChain("AAPL")=QM_GetOptionChain("SPY")=QM_GetOptionChain("TSLA")=QM_GetOptionChain(A1)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
Why is the data taking long to load?
Large option chains (like SPY) have hundreds of contracts. Consider using filtered versions like QM_GetOptionChainNearTerm().
How do I filter by expiration or strike?
Use specialized functions like QM_GetOptionChainWeeklies() or QM_OptionFilter() for filtered data.
The data is cutting off. What do I do?
Ensure you have enough empty cells below and to the right for the data to spill into.
Related Formulas
More MarketXLS Price Quotes formulas you can use in the same worksheet:
- Percent Change (On Demand)
- Percent Change From Previous Day
- Previous Close
- Previous Close (On Demand)
- Price Change (On Demand)
- Price Range Current Day
- QM Ask Size
- QM Get Recent Option Stats Dynamic
See QM_GetOptionChain used in a complete workbook: NSE Option Chain Data: How to Get, Analyze, and Use Indian Option Chains in Excel
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?