OPT Intrinsic Value
Intrinsic value of the option.
Syntax
=mxls.OPT_IntrinsicValue(optionSymbol, stockPrice)Parameters
optionSymbolstringRequired
stockPricenumberRequired
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- OPT Last
- OPT Max Pain
- OPT Moneyness
- OPT Open Interest
- Opt SABR Delta
- Opt SABR Gamma
- Opt SABR Implied Vol
- OPT SABR PRICE
See OPT_IntrinsicValue used in a complete workbook: Bull Call Spread Calculator: Strike Width, Breakeven and Real Fill Prices in Excel (2026)
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?