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
Examples
=QM_GetOptionChainStructured("AAPL")=QM_GetOptionChainStructured("SPY")Symbol from cell reference
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
Q: How is structured different from regular? A: Structured provides better organized output with calls and puts paired by strike, making visual analysis easier.
Q: Can I get dynamic updates?
A: Yes, use QM_GetOptionChainStructuredDynamic() for auto-updating data.
Q: Is the data the same as QM_GetOptionChain? A: 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?