Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
← Back to Templates

Option Chain Filtering Function in Excel using MarketXLS

Description

Option Chain Filtering Function in Excel using MarketXLS thumbnail

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

Option Chain Filtering Function in Excel using MarketXLS screenshot 1

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?
How does MarketXLS work? Watch Demo

Similar Templates

Related Formulas