Gamma measures the rate of change in Delta per $1 move in the underlying stock.

Syntax

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

Examples

=opt_Gamma(150, 5, DATE(2024,6,21), "Call", 155)

When to Use

  • Delta hedging frequency
  • Risk management

When NOT to Use

Scenario Use Instead
Price sensitivity opt_Delta()

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 Gamma and Other Financial Formulas
How does MarketXLS work?