Options Gamma
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])Parameters
currentStockPricenumberRequired
marketOptionPricenumberRequired
expiryDatedateRequired
optionTypestringRequired
strikePricenumberRequired
riskFreeRatenumber
impliedVolatilitynumber
Examples
=mxls.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() |
Excel Templates Using Options Gamma
These ready-made MarketXLS templates call opt_Gamma() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- Options OI Leaders
- Options Total Volume Historical
- Options Volume Leaders
- Put Interest (Specific Expiry)
- QM Get Option Chain Active Dynamic
- QM Get Option Chain At The Money Dynamic
- QM Get Option Chain Dynamic
- QM Get Option Chain In The Money Dynamic
See opt_Gamma used in a complete workbook: Options Data in ChatGPT with MarketXLS: Live Chains, Greeks, and Sentiment via MCP
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?