OPT Max Pain
Maximum pain strike price.
Syntax
=mxls.OPT_MaxPain(symbol, expirationDate)Parameters
symbolstringRequired
expirationDatestringRequired
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- OPT Moneyness
- OPT Open Interest
- Opt SABR Delta
- Opt SABR Gamma
- Opt SABR Implied Vol
- OPT SABR PRICE
- Opt SABR Rho
- Opt SABR Theta
See OPT_MaxPain used in a complete workbook: Quad Witching Tracker Excel: June 2026 Options Expiration Dashboard
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?