← Back to Templates


Option Chain Filtering Function in Excel using MarketXLS
Description

This is an Excel function that efficiently filters a comprehensive options chain based on designated strike prices and expiration dates. After processing, the function yields a list of options custom-fit to match specified conditions. The function is as follows: =QM_OptionChainFilter("MSFT","strike_min","strike_min","expiration_min","expiration_max") example =QM_OptionChainFilter("MSFT",250,350,"2023-11-24","2023-12-25") for example This targeted filtering system enables retrieval of Option Chain information, including symbol string, changes in performance, percentages of change, opening, high, low, previous close figures, ask, bid size, ask size, contract volume, and dates for last trade and last quote.
Template Screenshots

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo