Option Chain Quarterlies

Returns only quarterly expiration options from the option chain using QuoteMedia's data service.

What are Quarterly Options?

Quarterly options expire on the last trading day of each calendar quarter:

  • March (Q1)
  • June (Q2)
  • September (Q3)
  • December (Q4)

These are often LEAPS (Long-Term Equity Anticipation Securities) for longer-dated options.

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

Notes

  • Longer-dated options
  • Lower gamma (less sensitive to price)
  • Lower theta (slower time decay)

Examples

=QM_GetOptionChainQuarterlies("AAPL")
Quarterly options for Apple
=QM_GetOptionChainQuarterlies("SPY")
Quarterly options for SPY
=QM_GetOptionChainQuarterlies(A1)
Symbol from cell reference

When to Use

  • Long-term options strategies
  • LEAPS investing
  • Lower premium decay strategies
  • Quarter-end expiration analysis

When NOT to Use

Scenario Use Instead
Need weekly options QM_GetOptionChainWeeklies()
Need monthly options QM_GetOptionChainMonthlies()
Need full chain QM_GetOptionChain()
Need near-term QM_GetOptionChainNearTerm()

Common Issues & FAQ

Q: What's the benefit of quarterly options? A: Quarterly options have more time, so they experience slower time decay and are less volatile (lower gamma).

Q: Are these the same as LEAPS? A: LEAPS often expire quarterly. However, not all quarterly options are LEAPS - LEAPS specifically refers to options with 1+ year to expiration.

Q: Why are quarterly options more expensive? A: More time to expiration means more time value (extrinsic value) in the option premium.

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

Related Functions