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

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?