Options Delta

Delta measures option price sensitivity to underlying price changes.

Syntax

=mxls.opt_Delta(CurrentStockPrice, MarketOptionPrice, ExpiryDate, OptionType, StrikePrice, [RiskFreeRate], [ImpliedVolatility])
Excel Online (Mac & Windows)

Examples

=mxls.opt_Delta(150, 5, DATE(2024,6,21), "Call", 155)

When to Use

  • Hedge ratios
  • Directional exposure

When NOT to Use

Scenario Use Instead
Time decay opt_Theta()

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Options Delta and Other Financial Formulas
How does MarketXLS work?