MarketXLS

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)
Excel Online (Mac & Windows)

Parameters

symbolstringRequired

Underlying stock ticker symbol

Returns

array

Structured option chain data

Examples

=mxls.QM_GetOptionChainStructured("AAPL")
Structured chain for Apple
=mxls.QM_GetOptionChainStructured("SPY")
Structured chain for SPY
=mxls.QM_GetOptionChainStructured(A1)
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

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.

Related Formulas

More MarketXLS Options formulas you can use in the same worksheet:

See QM_GetOptionChainStructured used in a complete workbook: Google Finance Formulas: Complete Guide to GOOGLEFINANCE Function and Better Alternatives (2026)

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

Related Functions