MarketXLS

Option Filter

Returns a filtered option chain based on option type (calls/puts) and expiration date range using QuoteMedia's data service.

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
CallsOrPuts String Yes "Calls", "Puts", or "Both"
StartDate Date Yes Start of expiration range
EndDate Date No End of expiration range

Notes

  • Flexible filtering for option chains
  • Useful for custom screening
  • Can filter by type and date simultaneously

Syntax

=QM_OptionFilter(Symbol, CallsOrPuts, StartDate, [EndDate])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Underlying stock ticker symbol

callsOrPutsstringRequired

Filter for calls or puts

startDatedateRequired

Start date for expiration range

endDatedate

End date for expiration range

Returns

array

Filtered option chain data

Examples

=QM_OptionFilter("AAPL", "Calls", DATE(2024,3,1))
All AAPL calls from March
=QM_OptionFilter("SPY", "Puts", DATE(2024,3,1), DATE(2024,6,30))
SPY puts Mar-Jun
=QM_OptionFilter("TSLA", "Both", TODAY())
All TSLA options from today
=QM_OptionFilter(A1, B1, C1, D1)
Parameters from cells

When to Use

  • Custom option screening
  • Specific type filtering (calls only or puts only)
  • Date range filtering
  • Building custom analysis

When NOT to Use

Scenario Use Instead
Need full chain QM_GetOptionChain()
Need ITM only QM_GetOptionChainInTheMoney()
Need OTM only QM_GetOptionChainOutOfTheMoney()
Need weeklies only QM_GetOptionChainWeeklies()

Common Issues & FAQ

What values can I use for CallsOrPuts?

Use "Calls" for call options only, "Puts" for put options only, or "Both" for all options.

Is EndDate required?

No. If omitted, returns all options expiring on or after StartDate.

What date format should I use?

Use Excel's DATE() function: DATE(2024,3,15) for March 15, 2024.

Related Formulas

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

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

Related Functions