Option Chain Structured
Returns the option chain in a structured, organized format using QuoteMedia's data service. This provides a cleaner layout compared to the raw option chain.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Underlying stock ticker |
Structure
The structured format typically organizes options by:
- Expiration date
- Call/Put pairs at each strike
- Clean column alignment
Notes
- Better organized than raw chain
- Easier to analyze visually
- Data spills into multiple cells
Syntax
=mxls.QM_GetOptionChainStructured(Symbol)Examples
=mxls.QM_GetOptionChainStructured("AAPL")=mxls.QM_GetOptionChainStructured("SPY")=mxls.QM_GetOptionChainStructured(A1)When to Use
- Clean option chain analysis
- Visual inspection of options
- Building options dashboards
- Organized data presentation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need auto-updating | QM_GetOptionChainStructuredDynamic() |
| Need raw data | QM_GetOptionChain() |
| Need with Greeks | QM_GetOptionQuotesAndGreeks() |
| Need filtered data | Use specific chain filter functions |
Common Issues & FAQ
How is structured different from regular?
Structured provides better organized output with calls and puts paired by strike, making visual analysis easier.
Can I get dynamic updates?
Yes, use QM_GetOptionChainStructuredDynamic() for auto-updating data.
Is the data the same as QM_GetOptionChain?
Yes, same data but formatted differently for easier analysis.
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?