QM Get Option Chain Monthlies Dynamic
Returns the monthly-expiration options from the option chain for the symbol (spilled array that fills adjacent cells automatically).
Syntax
=mxls.QM_GetOptionChainMonthliesDynamic(Symbol)Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- QM Get Option Chain Near Term Dynamic
- QM Get Option Chain Out Of The Money Dynamic
- QM Get Option Chain Quarterlies Dynamic
- QM Get Option Chain Weeklies Dynamic
- QM Get Option Expire Maximum Dynamic
- QM Get Option Expire Minimum Dynamic
- QM Get Option Market Stats Dynamic
- QM Get Option Quotes And Greeks Dynamic
See QM_GetOptionChainMonthliesDynamic used in a complete workbook: Options Profit Calculator: Excel-Based Options P&L Analysis With Real-Time Data
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?