Strikes Dynamic
Returns the list of available option strike prices for the symbol (spilled array that fills adjacent cells automatically).
Syntax
=mxls.StrikesDynamic(Symbol, [Expire], [Money], [CallPutFlag])Parameters
SymbolstringRequired
Expirestring
Moneystring
CallPutFlagstring
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
▶
How does MarketXLS work?