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

Examples

=QM_GetOptionChainWeeklies("AAPL")
Weekly options for Apple
=QM_GetOptionChainWeeklies("SPY")
Weekly options for SPY
=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

Q: Not all stocks have weeklies. Why? A: Weekly options are only available on liquid stocks and ETFs. Less liquid stocks only have monthly expirations.

Q: When do weeklies expire? A: Weekly options typically expire on Fridays at market close (4:00 PM ET). Some index options may have different rules.

Q: Why are weeklies riskier? A: Shorter time to expiration means higher gamma (larger price swings) and faster time decay.

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