MarketXLS

Option Chain Near Term

Returns only near-term expiration options from the option chain using QuoteMedia's data service.

What is Near-Term?

Near-term options typically include:

  • Options expiring within the next 30 days
  • Front-month expirations
  • The most actively traded 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

  • Focuses on liquid, near-term options
  • Smaller dataset than full chain
  • Most relevant for short-term trading

Syntax

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

Parameters

symbolstringRequired

Underlying stock ticker symbol

Returns

array

Near-term option chain data

Examples

=mxls.QM_GetOptionChainNearTerm("AAPL")
Near-term options for Apple
=mxls.QM_GetOptionChainNearTerm("SPY")
Near-term options for SPY
=mxls.QM_GetOptionChainNearTerm(A1)
Symbol from cell reference

When to Use

  • Short-term options strategies
  • Weekly income trading
  • Event-driven trades
  • Most liquid options

When NOT to Use

Scenario Use Instead
Need weekly options only QM_GetOptionChainWeeklies()
Need monthly options QM_GetOptionChainMonthlies()
Need full chain QM_GetOptionChain()
Need longer-dated LEAPS QM_GetOptionChainQuarterlies()

Common Issues & FAQ

What's the exact cutoff for near-term?

Typically options expiring within 30 days, but this may vary based on data provider settings.

How is this different from weeklies?

Near-term includes ALL options expiring soon (both weekly and monthly), while weeklies only includes weekly expirations.

Why focus on near-term?

Near-term options are usually the most liquid and actively traded.

Related Formulas

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

See QM_GetOptionChainNearTerm 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 Near Term and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions