MarketXLS

Option Chain Weeklies

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

What are Weekly Options?

Weekly options (weeklies) expire every Friday (except for holidays) and are listed each week. They offer:

  • Higher gamma (more sensitive to price changes)
  • Faster time decay
  • Lower premium cost
  • More precise timing

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

  • Weekly options expire on Fridays
  • Higher risk/reward than monthly options
  • Popular for short-term strategies

Syntax

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

Parameters

symbolstringRequired

Underlying stock ticker symbol

Returns

array

Weekly expiration option chain data

Examples

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

When to Use

  • Short-term trading strategies
  • Weekly income strategies
  • Event-driven trades (earnings, etc.)
  • Lower capital requirements

When NOT to Use

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

Common Issues & FAQ

Not all stocks have weeklies. Why?

Weekly options are only available on liquid stocks and ETFs. Less liquid stocks only have monthly expirations.

When do weeklies expire?

Weekly options typically expire on Fridays at market close (4:00 PM ET). Some index options may have different rules.

Why are weeklies riskier?

Shorter time to expiration means higher gamma (larger price swings) and faster time decay.

Related Formulas

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

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

Related Functions