Start with Sections 1–5 for definitions and signs. Follow Sections 6–9 for one consistent, fully priced BSM example. Use the four Excel illustrations for contract scaling, then Section 12 for detailed futures desk caselets. Section 13 explains the exact Excel functions and dividend adjustment.
Two stated futures conventions: the four Excel illustrations use delta 100 per futures contract; Section 12 uses delta 101. These are separate hypothetical inputs. In either case use nF = −remaining spot delta ÷ futures spot delta per contract. Never transfer a quantity between examples without recalculating it.
LEARNING SECTION 01
Why do traders need Options Greeks?
A trader who sells an option receives a premium today but takes on a changing obligation. Its value responds to the share price, implied volatility, time and interest rates. Greeks translate these drivers into measurable sensitivities that can be aggregated across a book.
This guide follows the accompanying Option Greeks handout and workbook: understand the inputs, hedge delta, add gamma protection, then neutralise gamma and vega jointly before fixing the remaining delta.
| Greek | Question it answers | Usual tool |
|---|---|---|
| Delta Δ | How much does value change for a ₹1 spot move? | Shares or appropriately scaled futures |
| Gamma Γ | How quickly does delta change as spot moves? | Options |
| Vega ν | How much does value change when implied volatility moves? | Options with suitable strike and maturity |
| Theta Θ | What is the model effect of time passing? | Monitor carry and the gamma–theta trade-off |
| Rho ρ | What is the effect of interest-rate changes? | Rate-sensitive instruments or portfolio hedges |
A precise meaning for each Greek
| Greek | Definition and unit | Small-change interpretation |
|---|---|---|
| Delta Δ | ∂V/∂S; ₹ of option value per ₹1 spot move | ΔV ≈ Δ × change in spot |
| Gamma Γ | ∂²V/∂S²; change in delta per ₹1 spot move | New delta ≈ old delta + Γ × change in spot |
| Vega ν | ∂V/∂σ; raw derivative or /100 per volatility point | 20% to 21% is +1 point, or +0.01 in decimal σ |
| Theta Θ | ∂V/∂t for elapsed calendar time; specify ₹/day or ₹/year | One day passing reduces remaining maturity T |
| Rho ρ | ∂V/∂r; raw derivative or /100 per percentage point | 5% to 5.25% is +0.25 percentage point = +25 bp |
Hold other inputs fixed. A Greek isolates one sensitivity. Actual daily profit or loss combines spot, volatility, time, rates, cross-effects and trading costs. Portfolio Greeks are signed sums of each holding’s sensitivities; a weighted-average per-unit Greek alone is not the total exposure.
LEARNING SECTION 02
The common example and model assumptions
We use European calls on a non-dividend-paying share. Spot S = ₹100, continuously compounded risk-free rate r = 5%, volatility σ = 20%. The desk is short 1,000 units of option A. Each option unit covers one share.
| Input / Greek | Option A | Option B | Option C |
|---|---|---|---|
| Role | Written option | Hedge option 1 | Hedge option 2 |
| Strike K | 100 | 105 | 95 |
| Time T (years) | 0.50 | 0.25 | 1.00 |
| Call value (₹) | 6.8887 | 2.4779 | 13.3465 |
| Delta | 0.597734 | 0.377178 | 0.727897 |
| Gamma | 0.0273587 | 0.0379883 | 0.0165964 |
| Vega per 1 vol point (₹) | 0.273587 | 0.189941 | 0.331927 |
d₂ = d₁ − σ√T
Call = S N(d₁) − K e−rTN(d₂)
N(·) is the standard normal cumulative distribution. φ(·) is its density. The model assumes constant volatility and rates, continuous hedging and frictionless trading. Actual execution involves discrete quantities, spreads, margin and funding.
Contract scaling: position Greek = signed contracts × contract multiplier × Greek per unit. All quantities below are theoretical units; convert to tradable lots, round, then recalculate the residual exposure.
LEARNING SECTION 03
Delta: how much underlying exposure do I have?
Delta is ∂V/∂S. A call delta of 0.5977 means a small ₹1 rise in the share price increases its model value by approximately ₹0.5977, with other inputs unchanged.
Portfolio Δ = Σ(quantity × per-unit delta)
| Position | Delta sign | Gamma sign | Vega sign |
|---|---|---|---|
| Long call | Positive | Positive | Positive |
| Short call | Negative | Negative | Negative |
| Long put | Negative | Positive | Positive |
| Short put | Positive | Negative | Negative |
| Long share | +1 | 0 | 0 |
Worked hedge: short 1,000 calls
Option delta = N(0.247487) = 0.597734.
Book delta = −1,000 × 0.597734 = −597.734 shares equivalent.
Buy 597.734 shares. Total delta = −597.734 + 597.734 = 0.
A call delta lies between zero and one in this model. Put delta lies between minus one and zero. Delta is a hedge ratio; N(d₂), rather than N(d₁), is the risk-neutral probability that this European call finishes in the money.
Instrument sign versus position sign
A put’s quoted delta is normally the delta of a long put. For example, long-put delta −0.25 and signed quantity −1,000 give position delta +250. A short put is directionally bullish even though the long-put instrument delta is negative.
Example: −10 contracts × 100 shares × (−0.25) = +250
Do not reverse the instrument sign and also reverse the quantity twice.
LEARNING SECTION 04
Why must a delta hedge be rebalanced?
The hedge uses today's delta. When spot changes, the option's delta changes. The fixed share holding no longer offsets the option book.
| Instant new spot | Short-call P&L | Share P&L | Net P&L | Rebalance |
|---|---|---|---|---|
| ₹102 | −₹1,249.11 | +₹1,195.47 | −₹53.65 | Buy 53.077 shares |
| ₹98 | +₹1,139.82 | −₹1,195.47 | −₹55.64 | Sell 56.068 shares |
| ₹110 | −₹7,186.66 | +₹5,977.34 | −₹1,209.31 | Buy 223.853 shares |
These are instantaneous, fully repriced moves with unchanged volatility and maturity. They exclude financing and transaction costs. A short-gamma trader typically buys more underlying after a rise and sells after a fall. Frequent rebalancing can become expensive.
LEARNING SECTION 05
Gamma: the curvature behind the residual loss
Gamma is ∂Δ/∂S = ∂²V/∂S². It measures how much delta changes for a small ₹1 spot move. A long vanilla call or put has positive gamma; writing it reverses the sign. Shares have zero gamma.
Change in value ≈ Δ × dS + ½ Γ × (dS)²
Delta alone versus delta plus gamma
For option A and a ₹5 spot rise:
Delta term = 0.597734 × 5 = ₹2.988672.
Gamma term = ½ × 0.0273587 × 25 = ₹0.341983.
Total estimate = ₹3.330656.
Exact BSM change = ₹3.312529.
The short 1,000-call book has gamma −27.3587. Once delta is hedged, its local spot-move P&L is approximately ½ × (−27.3587) × (dS)². The squared move makes that component negative in either direction.
Gamma is often concentrated near the strike, especially close to expiry. Peak locations depend on which variable is varied. Large shocks require full repricing rather than a fixed-Greek approximation.
Gamma changes delta; it is not the full option-price change
Suppose a long call has delta 0.60 and gamma 0.04. For a ₹2 spot rise, new delta is approximately 0.60+0.04×2 = 0.68. The option-price change is approximately 0.60×2 + ½×0.04×2² = ₹1.28. These are two different outputs: 0.68 is the new hedge ratio; ₹1.28 is an estimated premium change.
The usual positive-gamma and positive-vega statements here apply to long vanilla calls and puts under the stated model. Short positions reverse these signs; exotic options and combined strategies can have different exposures. “At the money” is a useful rule of thumb for high gamma, not an exact universal location of the maximum.
LEARNING SECTION 06
How do we build a gamma–delta neutral book?
Shares = −(Δbook + nB ΔB)
Use option B to hedge the written calls
Buy B = 27.358659 / 0.0379883 = 720.186645 units.
Delta after options = −597.734469 + 720.186645 × 0.377178 = −326.096130.
Buy 326.096130 shares. Initial delta and gamma are both zero.
| Instant new spot | Delta hedge only | Gamma + delta hedge |
|---|---|---|
| ₹90 | −₹1,438.04 | −₹260.45 |
| ₹95 | −₹354.48 | −₹31.18 |
| ₹105 | −₹323.86 | +₹23.24 |
| ₹110 | −₹1,209.31 | +₹147.34 |
Gamma hedging reduces the local curvature exposure. The residual results arise because Greeks change over a finite move and the two options have different strikes and maturities. Vega is still not neutral.
LEARNING SECTION 07
Vega: why can a hedged trader lose when spot is unchanged?
Vega is ∂V/∂σ. Higher implied volatility increases the BSM value of a long vanilla call or put. A short option therefore has negative vega.
Vega per 1 percentage point = S √T φ(d₁)/100
Always label the units
Option A vega = 27.358659 per 1.00 volatility = ₹0.273587 per volatility point.
A move from 20% to 21% is one volatility point: estimated call increase ₹0.273587; exact increase ₹0.273755.
Short 1,000 calls: vega = −₹273.5866 per volatility point. A five-point rise gives a local estimated loss of ₹1,367.93, even if spot stays at ₹100.
A vega-only hedge with option C needs 824.236480 units, but leaves gamma at −13.679329. One hedge instrument generally cannot independently cancel two exposures.
In this BSM setup, raw vega / gamma = S²σT. Two hedge options with the same maturity and common σ have proportional gamma and vega, so their two-equation hedge matrix is singular. Different maturities provide independent exposure ratios in our example.
Volatility points are not relative percentage changes
With vega ₹0.40 per volatility point, an implied-volatility move from 20% to 23% is +3 points. Estimated long-option gain is ₹1.20 per share. For 10 long contracts of 100 shares, estimated position gain is ₹1,200. The volatility has risen 15% relative to its old level, but multiplying vega by 15 would use the wrong unit.
LEARNING SECTION 08
Gamma, vega and delta: the complete worked hedge
Choose two options with sufficiently different gamma-to-vega ratios. Solve their quantities simultaneously, then hedge delta with shares.
18.994144615 nB + 33.192729534 nC = 27,358.658565
The second row uses raw vega per 1.00 volatility for every instrument. Scaling the entire row by 1/100 gives the same quantities.
| Leg | Signed quantity | Delta | Gamma | Vega / vol point |
|---|---|---|---|---|
| Written A | −1,000 | −597.7345 | −27.358659 | −273.5866 |
| Buy B | 480.124430 | 181.0922 | 18.239106 | 91.1955 |
| Buy C | 549.490987 | 399.9731 | 9.119553 | 182.3911 |
| Buy shares | 16.669138 | 16.6691 | 0 | 0 |
| Total | — | ≈ 0 | ≈ 0 | ≈ 0 |
Use unrounded Greeks for the equations. Nearly proportional gamma–vega exposure ratios signal an unstable hedge; determinant size alone depends on units. Such a hedge may amplify input errors: small input changes may produce very large positions. Consider liquidity, concentration, costs and residuals after lot rounding.
LEARNING SECTION 09
Joint stress tests: compare the hedge choices
| Instant scenario | Unhedged | Delta | Gamma + delta | Gamma + vega + delta |
|---|---|---|---|---|
| S = 105; σ = 22% | −₹3,815.63 | −₹826.96 | −₹182.60 | +₹37.73 |
| S = 95; σ = 18% | +₹3,165.73 | +₹177.06 | +₹314.30 | −₹0.56 |
| S = 110; σ = 25% | −₹8,277.66 | −₹2,300.31 | −₹277.25 | +₹181.64 |
| S = 100; σ = 25% | −₹1,371.29 | −₹1,371.29 | −₹678.47 | +₹25.05 |
Each number comes from repricing all option legs and adding the share-value change. No time elapses, and rates are unchanged. The final hedge has much smaller losses in these selected scenarios, but the comparison does not establish protection against every scenario.
LEARNING SECTION 10
Interactive risk laboratory
Change spot and implied volatility. The laboratory keeps the initial hedge quantities fixed and fully reprices options A, B and C at the new inputs.
Base: spot ₹100, volatility 20%, rate 5%. No time elapses. All three options receive the same new volatility.
P&L excludes funding, fees, spreads, margin and lot rounding. Initial quantities remain fixed so that you can observe residual risk.
LEARNING SECTION 11
Theta and rho: what should a trader monitor?
Is time decay a guaranteed profit for an option writer?
No. For option A, call theta is −₹0.022236 per calendar day, so the short 1,000-call position has model theta of approximately +₹22.24 per day, holding other inputs fixed. Actual P&L also reflects price and volatility moves, financing and hedge costs.
This BSM equation links theta, delta, gamma and value under its assumptions. Theta is not an independent random market input, but desks still budget and manage theta exposure. It is too broad to say that traders never target theta neutrality or that time decay is risk-free income.
Can rho be ignored?
Option A call rho is ₹0.264424 per one-percentage-point rate rise. A 25 bp rise has a local effect of about −₹66.11 on the short 1,000 calls. Longer-dated equity options and rate derivatives can have material rate exposure. Desks may hedge it directly or centrally with suitable rate instruments.
Rho and vega must be compared using explicit shock sizes. Neither the small size nor the slow movement of rates is guaranteed.
Make theta and rho calculations explicit
If a long option costs ₹75 and has theta −₹1.50 per day, the one-day estimate is ₹73.50 with spot, volatility and rates fixed. A written position has the opposite theta contribution. This is a local estimate; theta itself changes, and a price or volatility move can exceed the time-decay gain.
If call rho is ₹10 per percentage point, a rate fall from 2% to 1% implies an approximate premium change of −₹10. A fall from 2% to 1.75% is only −0.25 point and implies −₹2.50. Use the stated scale rather than multiplying by the decimal rate change without conversion.
FROM THE TEACHING WORKBOOK
Four Excel illustrations: from exposure to a verified hedge
The following examples follow the locally available Delta Gamma Hedge Illustration teaching workbook. Its original share hedges are translated into futures below. These are additional examples; the common BSM model and laboratory retain their own stated inputs.
1. Delta neutrality: the sign comes before the quantity
In 02. Delta Hedging Illustration, the desk writes 1,000 one-share calls with delta 0.60. Its delta is −600, so it needs +600 delta: buy 6 theoretical futures contracts. A ₹1 rise produces an approximate call loss of ₹600 and a futures gain of ₹600, before gamma and other effects.
Futures = −(−600) / 100 = +6
Check: −600 + 6 × 100 = 0
A second example combines 500 long calls (delta +0.60) with 1,000 written puts (long-put delta −0.25). The book delta is +300 +250 = +550. Short 5.5 theoretical futures, rather than buy them. Writing a negative-delta instrument creates positive position delta.
2. Gamma–delta neutrality: hedging gamma changes delta
In 07. Simple Neutral Hedging, the existing portfolio has delta 0 and gamma −3,000. A hedge option has delta 0.62 and gamma 1.5 per option unit.
New Δ = 0 + 2,000 × 0.62 = +1,240
Futures = −1,240 / 100 = −12.4 theoretical contracts
| Leg | Delta | Gamma |
|---|---|---|
| Original book | 0 | −3,000 |
| Buy 2,000 option units | +1,240 | +3,000 |
| Short 12.4 theoretical futures | −1,240 | 0 |
| Total | 0 | 0 |
Shorting 12 whole futures leaves delta +40; shorting 13 leaves −60. Recalculate the rounded hedge rather than reporting exact neutrality. Vega is unspecified in this example.
3. Gamma–vega neutrality: two equations, then futures
The same sheet gives book delta 0, gamma −5,000 and vega −8,000. Option 1 has delta 0.60, gamma 0.50 and vega 2.00; option 2 has delta 0.50, gamma 0.80 and vega 1.20. Retain the workbook’s common vega scale in both equations; it cancels from the hedge ratios.
2.00x + 1.20y = 8,000
Solution: buy x = 400 and y = 6,000 option units
New Δ = 400 × 0.60 + 6,000 × 0.50 = 3,240
Futures = −3,240 / 100 = −32.4
| Leg | Delta | Gamma | Vega, source scale |
|---|---|---|---|
| Original book | 0 | −5,000 | −8,000 |
| Buy 400 option 1 | +240 | +200 | +800 |
| Buy 6,000 option 2 | +3,000 | +4,800 | +7,200 |
| Short 32.4 theoretical futures | −3,240 | 0 | 0 |
| Total | 0 | 0 | 0 |
4. Contract multipliers: 50 written calls, two hedge options
In 08. DGV Neutral Case Study, each option contract covers 10 shares. The instrument Greeks below are per share; multiply by 10 before solving in contracts.
| Instrument | Signed contracts | Delta/share | Gamma/share | Vega/share, source scale |
|---|---|---|---|---|
| Written call | −50 | +0.60 | 0.20 | 0.16 |
| Hedge call | x | +0.20 | 0.10 | 0.10 |
| Hedge put | y | −0.80 | 0.30 | 0.20 |
Gamma equation: x + 3y = 100
Vega equation: x + 2y = 80
Subtract → y = 20; substitute → x = 40
Delta after options = −300 + 40 × 2 + 20 × (−8) = −380
Futures = −(−380) / 100 = +3.8 theoretical contracts
| Leg | Delta | Gamma | Vega, source scale |
|---|---|---|---|
| 50 written calls | −300 | −100 | −80 |
| Buy 40 hedge calls | +80 | +40 | +40 |
| Buy 20 hedge puts | −160 | +60 | +40 |
| Buy 3.8 theoretical futures | +380 | 0 | 0 |
| Total | 0 | 0 | 0 |
Buying 4 whole futures leaves delta +20; buying 3 leaves −80. The option contracts in this case are integers, so only the futures rounding changes the stated initial residual.
Build a reusable Excel check
On a new sheet enter signed contracts in column B, multipliers in C and per-share delta, gamma and vega in D:F. Use rows 2:4 for the original option and two hedges. Calculate position delta in G2 with =B2*C2*D2, gamma in H2 with =B2*C2*E2 and vega in I2 with =B2*C2*F2; copy down.
Final delta = SUM(G2:G4)+FuturesQuantity*FuturesMultiplier*QuoteSensitivity
Final gamma = SUM(H2:H4)
Final vega = SUM(I2:I4)
Use named inputs for the futures terms. Keep the unrounded theoretical quantity and a separate executable quantity. Verify the residuals using the executable quantity before approving a trade.
What a zero Greek does—and does not—tell you
Delta neutrality removes the first-order spot term at current inputs. Gamma neutrality additionally removes the second-order spot term. Vega neutrality removes the first-order response to the specified volatility shock. None guarantees unchanged value after a large move or a different volatility-surface move.
For a local P&L estimate use ΔV ≈ Δ·ΔS + ½Γ·(ΔS)² + νpoint·Δσpoints + Θday·days + ρpoint·Δrpoints. Use full repricing for material shocks, and include hedge premiums, financing, transaction costs and futures margin cash flows in the desk assessment.
Teaching examples adapted from the locally available Introduction to Option Greeks and Delta Gamma Hedge Illustration workbooks. Source sheets are named above. Futures overlays are article adaptations; the original exercises use shares.
LEARNING SECTION 12
Trading-desk caselets: detailed solutions using futures
These three fictional desk situations develop delta, gamma–delta and gamma–vega–delta hedges. Each has a stated problem, input table, questions, Excel steps and final checks. Options manage gamma and vega; futures replace cash shares for the remaining delta hedge.
Common futures assumptions — read before solving
| Input / convention | Value | Excel reference |
|---|---|---|
| Futures underlying | Same non-dividend-paying share as the options | No cross-asset basis hedge |
| Units per futures contract Q | 100 underlying units | Illustrative multiplier, not an exchange specification |
| Futures quote sensitivity a = ∂F/∂S | 1.01 | Specified constant carry factor for these instantaneous examples |
| Delta per futures contract | Q × a = 100 × 1.01 = 101 | Underlying-equivalent units per ₹1 spot move |
| Futures gamma and vega | 0 under the stated fixed-carry model | Rates and carry remain fixed |
| Signed futures quantity | Positive = long; negative = short | Theoretical quantities may be fractional |
Final Δ = Δafter options + nFQa
Futures mark-to-market P&L = nFQ(F₁−F₀)
With F = aS and a fixed at 1.01, futures delta per contract is 101, gamma is zero and the spot ₹100 to ₹97 move changes the quote from ₹101 to ₹97.97. In practice, use the selected futures contract’s actual multiplier and consistent spot-to-futures sensitivity. Daily settlement, funding, margin liquidity and changing basis need separate treatment.
Excel bridge: The original 8_Caselets sheet calculates its final delta offset as a share quantity. Keep that source calculation as a number of underlying-equivalent delta units. Convert it to futures contracts by dividing by 101. The extra formulas below are an overlay to enter in unused columns H:I, rather than changes already present in the downloaded workbook.
CASELET 01 · DELTA NEUTRAL USING FUTURES
A put-writing desk hedges a client's protection trade
The story
At 10:00 a.m., fictional Summit Securities sells 2,000 six-month European puts to a client protecting a share portfolio. The puts cover one share each and have a ₹100 strike. The share trades at ₹100. The desk receives premium, but the risk manager prohibits an unhedged directional position. The trader is instructed to hedge with futures rather than short cash shares.
Immediately after the hedge, the share falls to ₹97. The client’s puts become more valuable. The risk manager asks the trader to show how much the futures hedge has offset, explain any remaining loss and restore delta neutrality. Assume no time elapses and volatility, rates and carry are unchanged.
Inputs and questions
| Input / convention | Value | Excel reference |
|---|---|---|
| S₀; K; T | ₹100; ₹100; 0.50 year | Inputs_BS: S0, K_A, T_A |
| r; σ | 5% continuously compounded; 20% | Inputs_BS: r, sigma |
| Number of puts sold | 2,000 | 8_Caselets!C6 |
| Initial put price and delta | ₹4.419719781; −0.402265531 | C7:C8 |
| Shock spot | ₹97 | C11 |
| Futures Q; a; initial quote | 100; 1.01; ₹101 | Common futures assumptions |
- Find the signed option-book delta. Why is it positive?
- Calculate the initial futures hedge and verify delta is zero.
- Reprice the puts at ₹97 and calculate option, futures and combined P&L.
- Calculate the new delta and additional futures trade.
- Explain why initial neutrality did not eliminate the loss and what rounding changes.
Step 1 — determine the exposure
A long put has negative delta. The desk is short, so its position delta is positive: −2,000 × (−0.402265531) = +804.531062. It loses locally when spot falls. Short futures provide the negative delta needed to offset this exposure.
Step 2 — create the initial futures hedge
Check: 804.531062 − 7.965654081 × 101 = 0
Short 7.965654 theoretical futures contracts. Do not short 804.531062 futures contracts: that number is an underlying-equivalent delta quantity, not a contract count.
Step 3 — reprice both legs after the fall
Recalculate d₁ and d₂ at S = 97 using unchanged K, T, r and σ. BSM put value becomes ₹5.752621911; the new long-put delta is −0.487192861. C12 and C16 already compute these in the source sheet.
| Step | Excel entry / calculation | Answer and meaning |
|---|---|---|
| Initial book delta, C9 | =-C6*C8 | +804.531062 |
| Initial futures, overlay I9 | =-C9/101 | −7.965654081 |
| New put value, C12 | BSM repricing at S = 97 | ₹5.752621911 |
| Put P&L, C13 | =-C6*(C12-C7) | −₹2,665.804262 |
| New futures quote | 1.01 × 97 | ₹97.97; quote change −₹3.03 |
| Futures P&L, overlay I14 | =I9*100*(1.01*C11-1.01*S0) | +₹2,413.593187 |
| Combined P&L, overlay I15 | =C13+I14 | −₹252.211075 |
Step 4 — rebalance the futures
The new option-book delta is −2,000 × (−0.487192861) = +974.385723. The original futures hedge still contributes −804.531062. Residual delta is therefore +169.854661.
| Step | Excel entry / calculation | Answer and meaning |
|---|---|---|
| Residual delta, C17 | =-C6*C16+C10 | +169.854661; C10 represents the original delta offset |
| Additional futures, overlay I18 | =-C17/101 | −1.681729313 |
| Total theoretical futures | =I9+I18 | −9.647383394 |
| Final delta check | 974.385722823584 − 9.64738339429291×101 | Approximately zero |
Whole-contract implementation: Initially shorting 8 contracts gives delta 804.531062−808 = −3.468938. Recalculate subsequent P&L using 8, rather than the theoretical quantity. At the shocked spot, choose a new whole-contract target using the new delta and recalculate the residual. Fractional-contract P&L above is a teaching benchmark.
Workbook reference: 8_Caselets!B6:C18. Add the clearly labelled futures overlay in unused H:I cells. C11’s original “Next-day” label is treated here as an instantaneous shock because the pricing formula does not reduce T.
CASELET 02 · GAMMA–DELTA NEUTRAL USING FUTURES
A trader needs a hedge that does more than cancel today's delta
The story
Fictional Ridgeway Trading runs a client-options book with delta +400 and gamma −250. A busy market announcement is approaching. The risk manager is concerned that a futures-only delta hedge will quickly become outdated if spot changes sharply. The trader can use liquid option X to change gamma and futures to change delta.
The instruction is to make gamma and delta zero at the current inputs. Option prices and scenario prices are not supplied, so this is an exposure-construction problem, not a hedge-cost or realised-P&L exercise.
Inputs and questions
| Input / convention | Value | Excel reference |
|---|---|---|
| Book delta; gamma | +400; −250 | C21:C22 |
| Option X delta; gamma | +0.55; +0.025 per unit | C23:C24 |
| Futures delta; gamma | +101 per contract; 0 | Common assumptions |
| Unknown trades | x options; nF futures | Positive = buy / long |
- Explain why futures alone cannot remove gamma.
- Write both neutrality equations and solve for X first.
- Calculate delta after the option purchase and the necessary futures trade.
- Reconcile both final Greeks and quantify the residual if futures are rounded.
- Can this result be described as vega neutral? Explain.
Step 1 — write the two equations
Delta: 400 + 0.55x + 101nF = 0
Futures have no gamma in this model, so gamma must be removed with an option. Buying X supplies positive gamma. This also adds positive delta, which must be included before calculating the futures hedge.
Step 2 — gamma first, futures delta last
| Step | Excel entry / calculation | Answer and meaning |
|---|---|---|
| Option quantity, C25 | =-C22/C24 | Buy 10,000 X |
| Delta after options, C26 | =C21+C25*C23 | +5,900 |
| Delta offset, C27 | =-C26 | −5,900 underlying-equivalent units; not a futures count |
| Futures quantity, overlay I27 | =C27/101 | −58.415841584: short futures |
| Gamma check, C28 | =C22+C25*C24 | 0 |
| Futures-based delta check, overlay I29 | =C26+I27*101 | 0 |
Step 3 — reconcile the hedge leg by leg
| Leg | Position | Delta contribution | Gamma contribution |
|---|---|---|---|
| Original book | Aggregate | +400 | −250 |
| Option X | Buy 10,000 | +5,500 | +250 |
| Futures | Short 58.415841584 | −5,900 | 0 |
| Theoretical total | — | 0 | 0 |
Why this order? Hedging the initial +400 delta with futures first would not remove gamma. Buying the required options afterwards would add +5,500 delta and force another futures adjustment. Solving option exposures first gives the correct combined delta in one pass.
Remaining risk: Vega was not supplied, so it cannot be calculated or claimed neutral. Greeks change with the market, and costs, liquidity, rates and time still matter. Change book gamma C22 to −300, recalculate both trades, and verify the final sensitivities.
Workbook reference: 8_Caselets!B21:C29. Keep C27 as the delta offset and divide it by 101 in a separate futures-contract output.
CASELET 03 · GAMMA–VEGA–DELTA NEUTRAL USING FUTURES
A desk expects both a price move and a volatility repricing
The story
Fictional Mountain Markets has sold several client options. Its consolidated report shows delta +200, gamma −600 and vega −₹3,000 per volatility point. Ahead of an announcement, the risk manager wants to remove all three local exposures. The trader can buy or sell two hedge options on the same underlying, X and Y, and use futures for the final delta adjustment.
X supplies relatively more gamma per unit of vega. Y supplies relatively more vega per unit of gamma. Their different sensitivity ratios allow a joint solution. The exercise assumes these Greeks are available at the current inputs and quantities are initially divisible.
Inputs
| Greek | Book: column C | X: column D | Y: column E | Row in 8_Caselets |
|---|---|---|---|---|
| Delta | +200 | +0.50 | +0.60 | 33 |
| Gamma | −600 | +0.04 | +0.02 | 34 |
| Vega: ₹ per volatility point | −3,000 | +0.10 | +0.25 | 35 |
Futures delta per contract = +101; futures gamma and vega = 0 under the common fixed-carry assumptions. One volatility point means, for example, 20% to 21%. Use this vega scale in every equation.
Questions for the trader
- Write the gamma and vega equations. Why cannot one option generally satisfy both?
- Solve for X and Y by elimination and reproduce the solution with MINVERSE and MMULT.
- Calculate delta after both option trades and convert it to futures contracts.
- Verify all three sensitivities leg by leg.
- Calculate the whole-contract residual and describe the risks that neutrality leaves.
Step 1 — choose target offsets
0.10x + 0.25y = 3,000 (vega)
The right-hand sides are the negatives of the original exposures. X alone would need 15,000 units to cancel gamma but 30,000 units to cancel vega. Because those quantities differ, a single X trade cannot cancel both. Two options with independent gamma-to-vega ratios are needed.
Step 2 — solve by hand
Multiply the gamma equation by 2.5, then subtract it from the vega equation:
0.10x + 0.25y = 3,000
Subtract: 0.20y = 1,500 → y = 7,500
Substitute: 0.04x + 150 = 600 → x = 11,250
Both signs are positive: buy 11,250 X and 7,500 Y. X supplies gamma 450 and vega 1,125; Y supplies gamma 150 and vega 1,875.
Step 3 — reproduce the simultaneous solution in Excel
| Step | Excel entry / calculation | Answer and meaning |
|---|---|---|
| Matrix C37:D37 | =D34 in C37; =E34 in D37 | Gamma row 0.04, 0.02 |
| Matrix C38:D38 | =D35 in C38; =E35 in D38 | Vega row 0.10, 0.25 |
| Required offsets E37:E38 | =-C34 in E37; =-C35 in E38 | 600 and 3,000 |
| Determinant C39 | =MDETERM(C37:D38) | 0.008; unique solution |
| Option quantities C40:C41 | =MMULT(MINVERSE(C37:D38),E37:E38) | 11,250 X and 7,500 Y |
In current Excel, enter the formula in C40 and leave C41 clear for the second result to spill. In older Excel, select C40:C41, enter the formula and confirm with Ctrl+Shift+Enter. A zero determinant gives no unique solution. Near-proportional exposures can produce unstable or impractically large hedges; inspect the positions as well as the determinant.
Step 4 — compute the remaining delta and hedge with futures
| Step | Excel entry / calculation | Answer and meaning |
|---|---|---|
| Delta after options C42 | =C33+C40*D33+C41*E33 | 200+5,625+4,500 = +10,325 |
| Delta offset C43 | =-C42 | −10,325 underlying-equivalent units |
| Futures quantity, overlay I43 | =C43/101 | −102.227722772: short futures |
| Final delta, overlay I44 | =C42+I43*101 | 0 |
Step 5 — verify every contribution
| Leg | Position | Delta | Gamma | Vega / vol point |
|---|---|---|---|---|
| Original book | Aggregate | +200 | −600 | −3,000 |
| X | Buy 11,250 | +5,625 | +450 | +1,125 |
| Y | Buy 7,500 | +4,500 | +150 | +1,875 |
| Futures | Short 102.227722772 | −10,325 | 0 | 0 |
| Theoretical total | — | 0 | 0 | 0 |
| Step | Excel entry / calculation | Answer and meaning |
|---|---|---|
| Gamma C44 | =ROUND(C34+C40*D34+C41*E34,6) | 0 |
| Vega D44 | =ROUND(C35+C40*D35+C41*E35,6) | 0 |
| Futures delta overlay I44 | =ROUND(C42+I43*101,6) | 0 |
Remaining risk: Neutrality holds at current model inputs. Finite shocks change the Greeks; volatility smile and term-structure changes, vanna, volga, theta, rho, jumps, funding, basis and liquidity can still produce P&L. Futures variation margin also creates cash-flow needs. The input grid alone does not determine hedge cost or exact stressed P&L; prices and repricing assumptions are needed.
Learning task: Change C34 from −600 to −800 while leaving vega unchanged. Recompute both option trades and the futures hedge. Explain why both option quantities change when only one target exposure changes.
Workbook reference: 8_Caselets!B32:E44. C43 remains the underlying-equivalent offset. I43 and I44 are proposed extra futures outputs, not existing formulas in the unmodified file.
The practical sequence
- Confirm position signs, Greek units, futures multiplier and quote sensitivity.
- Write original exposures plus hedge contributions equal to zero.
- Use options to solve gamma, or gamma and vega jointly.
- Calculate delta after all option trades.
- Divide the negative delta by futures delta per contract.
- Verify theoretical totals, round into executable quantities, report residuals and stress the resulting book.
LEARNING SECTION 13
Excel implementation and a practical desk routine
| Calculation | Excel formula |
|---|---|
| d1 | =(LN(S/K)+(r+sigma^2/2)*T)/(sigma*SQRT(T)) |
| Call delta | =NORM.S.DIST(d1,TRUE) |
| Put delta | =NORM.S.DIST(d1,TRUE)-1 |
| Gamma | =NORM.S.DIST(d1,FALSE)/(S*sigma*SQRT(T)) |
| Vega / vol point | =S*SQRT(T)*NORM.S.DIST(d1,FALSE)/100 |
| Hedge matrix determinant | =MDETERM(C14:D15) |
| B and C quantities | =MMULT(MINVERSE(C14:D15),F14:F15) |
The matrix references correspond to 6_GVD_Neutral in the local companion workbook. Use dynamic arrays in current Excel; older versions may require array entry.
- Reconcile positions, lot multipliers, prices and valuation inputs.
- Aggregate signed Greeks by underlying, strike and expiry.
- Set exposure limits and select liquid hedge instruments.
- Solve option hedges, then fix delta. Recalculate after rounding.
- Stress spot, volatility, rates and time, including non-parallel volatility moves.
- Monitor margin, liquidity, realised versus implied volatility and hedge costs.
- Rebalance when exposure or risk limits require it.
In the workbook, begin with Inputs_BS, then follow 2_DeltaNeutral, 4_GammaDeltaNeutral, 6_GVD_Neutral and 8_Caselets.
What does N′(d₁) mean in Excel?
N(d₁) is the standard normal cumulative probability; N′(d₁), also written φ(d₁), is its density. They are different functions. Use =NORM.S.DIST(d1,TRUE) for N(d₁), and =NORM.S.DIST(d1,FALSE) for N′(d₁). The density can also be calculated with =EXP(-d1^2/2)/SQRT(2*PI()).
Dividend yield: use the matching BSM formulas
The common example above assumes q = 0. With a continuous dividend yield q, use the formulas below. Enter r, q and σ as annual decimals, and T in years. A known discrete cash dividend requires a separate treatment; simply substituting a yield is not equivalent.
d2 = d1-sigma*SQRT(T)
Call delta = EXP(-q*T)*NORM.S.DIST(d1,TRUE)
Put delta = EXP(-q*T)*(NORM.S.DIST(d1,TRUE)-1)
Gamma = EXP(-q*T)*NORM.S.DIST(d1,FALSE)/(S*sigma*SQRT(T))
Vega per point = S*EXP(-q*T)*SQRT(T)*NORM.S.DIST(d1,FALSE)/100
Matching long European calls and puts have the same gamma and vega when underlying, strike, maturity and valuation inputs match. They do not generally have the same delta, theta or rho.
Annual theta and raw vega are easy to misread
Many BSM spreadsheets return annual theta and raw vega. For a calendar-day convention, divide annual theta by 365; divide raw vega by 100 to express it per volatility point. A trading-day convention must be labelled and applied consistently. Do not divide a figure a second time if it is already scaled.
LEARNING SECTION 14
Learning materials and further reading
This article is adapted from your Option Greeks — Basics handout and checked against the locally available companion workbook. The original files remain unchanged.
The companion downloads support the common model and Section 12. The additional workbook illustrations above identify their own source sheets and futures assumptions.
- Options Industry Council: Understanding Options Greeks
- Options Industry Council: Volatility and the Greeks
Educational illustrations using hypothetical data. Model sensitivities and theoretical hedges are estimates; they do not guarantee trading outcomes.