MarketXLS

Option Chain Monthlies

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

What are Monthly Options?

Monthly options (also called "standard" options) expire on the third Friday of each month. These are the traditional option expirations:

  • More liquidity than weeklies for most stocks
  • Standard settlement procedures
  • Available on virtually all optionable stocks

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

  • Monthly options expire on 3rd Friday
  • Usually most liquid standard expirations
  • Available on all optionable stocks

Syntax

=mxls.QM_GetOptionChainMonthlies(Symbol)
Excel Online (Mac & Windows)

Parameters

symbolstringRequired

Underlying stock ticker symbol

Returns

array

Monthly expiration option chain data

Examples

=mxls.QM_GetOptionChainMonthlies("AAPL")
Monthly options for Apple
=mxls.QM_GetOptionChainMonthlies("SPY")
Monthly options for SPY
=mxls.QM_GetOptionChainMonthlies(A1)
Symbol from cell reference

When to Use

  • Standard options trading
  • Monthly income strategies
  • Traditional options analysis
  • Stocks without weekly options

When NOT to Use

Scenario Use Instead
Need weekly options QM_GetOptionChainWeeklies()
Need quarterly LEAPS QM_GetOptionChainQuarterlies()
Need full chain QM_GetOptionChain()
Need near-term only QM_GetOptionChainNearTerm()

Common Issues & FAQ

When exactly do monthly options expire?

Monthly options expire on the third Friday of the month at market close (4:00 PM ET).

Are monthly options more liquid than weeklies?

Generally yes, especially for less actively traded stocks. Weekly options are only available on highly liquid symbols.

What if the third Friday is a holiday?

If Friday is a holiday, options expire on the Thursday before.

Related Formulas

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

See QM_GetOptionChainMonthlies used in a complete workbook: Live Option Chain Data in Google Sheets: What GOOGLEFINANCE Covers and Where MarketXLS Picks Up

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

Related Functions