◆Financial Derivatives — In Progress Please await announcements of new courses and upcoming batches. Course Updates →
The Mountain Path Academy
← Financial Risk Management

FUNDAMENTALS · FINANCIAL RISK MANAGEMENT

How Traders Manage Risk
Using Options Greeks

An Excel-led guide to measuring option risk, building delta–gamma–vega hedges, converting the final delta into futures contracts and checking what risk remains.

By Prof. V. Ravichandran · The Mountain Path Academy
Updated 29 October 2026 · Excel-led explanations and practical futures hedges

FINANCIAL RISK MANAGEMENT

Options Greeks at a glance

Measure the exposure. Choose the hedge. Reprice under stress. Rebalance.

Δ DeltaDirection

Hedge with futures or shares

Γ GammaCurvature

Hedge with options

ν VegaVolatility

Match volatility exposure

Θ ThetaTime

Monitor carry

ρ RhoRates

Manage rate exposure

The hedge sequence: gamma and vega with options → remaining delta with futures or shares. Neutrality is local and must be monitored.

How to use this guide

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.

What does “manage risk” mean? Measure the exposures, choose suitable hedges, monitor the residual risks and rebalance when markets change. A zero Greek is a local condition at a particular price, volatility and time.

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.

GreekQuestion it answersUsual 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
Read every number in three steps: (1) Is it an instrument Greek or a signed position Greek? (2) Is it per share, per option unit or per contract? (3) Is it a local approximation or an exact model repricing? State these before calculating a hedge.

A precise meaning for each Greek

GreekDefinition and unitSmall-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 moveNew delta ≈ old delta + Γ × change in spot
Vega ν∂V/∂σ; raw derivative or /100 per volatility point20% to 21% is +1 point, or +0.01 in decimal σ
Theta Θ∂V/∂t for elapsed calendar time; specify ₹/day or ₹/yearOne day passing reduces remaining maturity T
Rho ρ∂V/∂r; raw derivative or /100 per percentage point5% 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 / GreekOption AOption BOption C
RoleWritten optionHedge option 1Hedge option 2
Strike K10010595
Time T (years)0.500.251.00
Call value (₹)6.88872.477913.3465
Delta0.5977340.3771780.727897
Gamma0.02735870.03798830.0165964
Vega per 1 vol point (₹)0.2735870.1899410.331927
d₁ = [ln(S/K) + (r + σ²/2)T] / (σ√T)
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.

Call Δ = N(d₁)   |   Put Δ = N(d₁) − 1
Portfolio Δ = Σ(quantity × per-unit delta)
PositionDelta signGamma signVega sign
Long callPositivePositivePositive
Short callNegativeNegativeNegative
Long putNegativePositivePositive
Short putPositiveNegativeNegative
Long share+100

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.

Position delta = signed contracts × multiplier × long-option delta
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 spotShort-call P&LShare P&LNet P&LRebalance
₹102−₹1,249.11+₹1,195.47−₹53.65Buy 53.077 shares
₹98+₹1,139.82−₹1,195.47−₹55.64Sell 56.068 shares
₹110−₹7,186.66+₹5,977.34−₹1,209.31Buy 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.

Delta-neutral does not mean loss-free. The first-order spot sensitivity is zero at inception. Curvature, volatility, time and other exposures remain.

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.

Γ = φ(d₁)/(S σ √T)
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?

Hedge gamma with an option first. Hedge the remaining delta with shares last. Shares can change delta without disturbing gamma.
nB = −Γbook/ΓB
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 spotDelta hedge onlyGamma + 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.00 of σ = S √T φ(d₁)
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.

0.037988289 nB + 0.016596365 nC = 27.358659
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.

LegSigned quantityDeltaGammaVega / vol point
Written A−1,000−597.7345−27.358659−273.5866
Buy B480.124430181.092218.23910691.1955
Buy C549.490987399.97319.119553182.3911
Buy shares16.66913816.669100
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 scenarioUnhedgedDeltaGamma + deltaGamma + 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.

What remains? Changes in Greeks, volatility smile and term-structure moves, cross-sensitivities such as vanna and volga, jumps, funding, execution and model risk. A parallel volatility shock is only one stress.

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.

Θ + rSΔ + ½σ²S²Γ = rV

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.

Use one unit system throughout. Position Greek = signed option contracts × shares per contract × Greek per share. A short position reverses the instrument’s Greek. For these new illustrations only, assume a futures multiplier of 100 and a fixed quote sensitivity ∂F/∂S = 1. Futures delta per contract is therefore 100. This is a teaching approximation, not an exchange contract specification. Section 12 separately uses 101.

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.

Book Δ = −1,000 × 0.60 = −600
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.

Option units = −(−3,000) / 1.5 = 2,000 bought
New Δ = 0 + 2,000 × 0.62 = +1,240
Futures = −1,240 / 100 = −12.4 theoretical contracts
LegDeltaGamma
Original book0−3,000
Buy 2,000 option units+1,240+3,000
Short 12.4 theoretical futures−1,2400
Total00

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.

0.50x + 0.80y = 5,000
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
LegDeltaGammaVega, source scale
Original book0−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,24000
Total000

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.

InstrumentSigned contractsDelta/shareGamma/shareVega/share, source scale
Written call−50+0.600.200.16
Hedge callx+0.200.100.10
Hedge puty−0.800.300.20
Book Greeks: Δ = −50 × 10 × 0.60 = −300; Γ = −100; ν = −80
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
LegDeltaGammaVega, 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+38000
Total000
Why buy futures after buying options? The hedge puts supply positive gamma and vega but negative delta. Buying an option does not necessarily add positive delta. The resulting book needs a positive futures hedge.

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.

Futures quantity = −SUM(G2:G4)/(FuturesMultiplier*QuoteSensitivity)
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 / conventionValueExcel reference
Futures underlyingSame non-dividend-paying share as the optionsNo cross-asset basis hedge
Units per futures contract Q100 underlying unitsIllustrative multiplier, not an exchange specification
Futures quote sensitivity a = ∂F/∂S1.01Specified constant carry factor for these instantaneous examples
Delta per futures contractQ × a = 100 × 1.01 = 101Underlying-equivalent units per ₹1 spot move
Futures gamma and vega0 under the stated fixed-carry modelRates and carry remain fixed
Signed futures quantityPositive = long; negative = shortTheoretical quantities may be fractional
nF = −Δafter options / (Q × a)
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 / conventionValueExcel reference
S₀; K; T₹100; ₹100; 0.50 yearInputs_BS: S0, K_A, T_A
r; σ5% continuously compounded; 20%Inputs_BS: r, sigma
Number of puts sold2,0008_Caselets!C6
Initial put price and delta₹4.419719781; −0.402265531C7:C8
Shock spot₹97C11
Futures Q; a; initial quote100; 1.01; ₹101Common futures assumptions
  1. Find the signed option-book delta. Why is it positive?
  2. Calculate the initial futures hedge and verify delta is zero.
  3. Reprice the puts at ₹97 and calculate option, futures and combined P&L.
  4. Calculate the new delta and additional futures trade.
  5. 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

nF = −804.531062 / 101 = −7.965654 contracts
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.

StepExcel entry / calculationAnswer and meaning
Initial book delta, C9=-C6*C8+804.531062
Initial futures, overlay I9=-C9/101−7.965654081
New put value, C12BSM repricing at S = 97₹5.752621911
Put P&L, C13=-C6*(C12-C7)−₹2,665.804262
New futures quote1.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.

StepExcel entry / calculationAnswer 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 check974.385722823584 − 9.64738339429291×101Approximately zero
Final answerInitially short 7.965654 futures. After the fall, short another 1.681729, for a total short position of 9.647383 contracts. The hedge offsets most of the put loss; the residual loss is ₹252.21. Negative gamma makes delta change during the move. Rebalancing fixes the new delta; it does not recover an existing loss.

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 / conventionValueExcel reference
Book delta; gamma+400; −250C21:C22
Option X delta; gamma+0.55; +0.025 per unitC23:C24
Futures delta; gamma+101 per contract; 0Common assumptions
Unknown tradesx options; nF futuresPositive = buy / long
  1. Explain why futures alone cannot remove gamma.
  2. Write both neutrality equations and solve for X first.
  3. Calculate delta after the option purchase and the necessary futures trade.
  4. Reconcile both final Greeks and quantify the residual if futures are rounded.
  5. Can this result be described as vega neutral? Explain.

Step 1 — write the two equations

Gamma: −250 + 0.025x = 0
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

StepExcel entry / calculationAnswer and meaning
Option quantity, C25=-C22/C24Buy 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*C240
Futures-based delta check, overlay I29=C26+I27*1010

Step 3 — reconcile the hedge leg by leg

LegPositionDelta contributionGamma contribution
Original bookAggregate+400−250
Option XBuy 10,000+5,500+250
FuturesShort 58.415841584−5,9000
Theoretical total—00
Gamma–delta neutral: options first, futures lastGamma–delta neutral: options first, futures last1. Read the existing bookDelta = +400; gamma = −2502. Neutralise gamma with option Xx = −(−250) / 0.025 = buy 10,000 X3. Recalculate delta after the options400 + 10,000 × 0.55 = +5,9004. Convert the delta offset into futuresnF = −5,900 / (100 × 1.01) = −58.4158425. Verify the theoretical hedgeGamma = 0; delta = 5,900 − 58.415842 × 101 = 06. Round, inspect residuals and monitorShort 58 whole futures → residual delta +42
Final answerBuy 10,000 X and short 58.415842 theoretical futures contracts. Gamma and delta are initially zero. If the desk shorts 58 whole contracts instead, delta is 5,900−58×101 = +42. Shorting 59 gives −59, so 58 has the smaller absolute residual for these inputs.

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

GreekBook: column CX: column DY: column ERow in 8_Caselets
Delta+200+0.50+0.6033
Gamma−600+0.04+0.0234
Vega: ₹ per volatility point−3,000+0.10+0.2535

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

  1. Write the gamma and vega equations. Why cannot one option generally satisfy both?
  2. Solve for X and Y by elimination and reproduce the solution with MINVERSE and MMULT.
  3. Calculate delta after both option trades and convert it to futures contracts.
  4. Verify all three sensitivities leg by leg.
  5. Calculate the whole-contract residual and describe the risks that neutrality leaves.

Step 1 — choose target offsets

0.04x + 0.02y = 600   (gamma)
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.05y = 1,500
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

StepExcel entry / calculationAnswer and meaning
Matrix C37:D37=D34 in C37; =E34 in D37Gamma row 0.04, 0.02
Matrix C38:D38=D35 in C38; =E35 in D38Vega row 0.10, 0.25
Required offsets E37:E38=-C34 in E37; =-C35 in E38600 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

StepExcel entry / calculationAnswer and meaning
Delta after options C42=C33+C40*D33+C41*E33200+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*1010

Step 5 — verify every contribution

LegPositionDeltaGammaVega / vol point
Original bookAggregate+200−600−3,000
XBuy 11,250+5,625+450+1,125
YBuy 7,500+4,500+150+1,875
FuturesShort 102.227722772−10,32500
Theoretical total—000
StepExcel entry / calculationAnswer 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
Gamma–vega–delta neutral: two options, then futuresGamma–vega–delta neutral: two options, then futures1. Read all exposures in consistent unitsDelta +200; gamma −600; vega −3,000 / vol point2. Solve gamma and vega jointly0.04x + 0.02y = 600; 0.10x + 0.25y = 3,0003. Execute the theoretical option hedgeBuy 11,250 X and 7,500 Y4. Recalculate delta and hedge with futuresDelta = 10,325; nF = −10,325 / 101 = −102.2277235. Verify all three theoretical sensitivitiesGamma = 0; vega = 0; delta = 06. Round, inspect residuals and monitorShort 102 whole futures → residual delta +23
Final answerBuy 11,250 X, buy 7,500 Y and short 102.227723 theoretical futures contracts. Initial gamma, vega and delta are zero. Shorting 102 whole contracts leaves delta 10,325−102×101 = +23; shorting 103 leaves −78. Choose the executable hedge in light of limits and costs, then monitor the residual.

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

  1. Confirm position signs, Greek units, futures multiplier and quote sensitivity.
  2. Write original exposures plus hedge contributions equal to zero.
  3. Use options to solve gamma, or gamma and vega jointly.
  4. Calculate delta after all option trades.
  5. Divide the negative delta by futures delta per contract.
  6. Verify theoretical totals, round into executable quantities, report residuals and stress the resulting book.

LEARNING SECTION 13

Excel implementation and a practical desk routine

CalculationExcel 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.

  1. Reconcile positions, lot multipliers, prices and valuation inputs.
  2. Aggregate signed Greeks by underlying, strike and expiry.
  3. Set exposure limits and select liquid hedge instruments.
  4. Solve option hedges, then fix delta. Recalculate after rounding.
  5. Stress spot, volatility, rates and time, including non-parallel volatility moves.
  6. Monitor margin, liquidity, realised versus implied volatility and hedge costs.
  7. 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.

d1 = (LN(S/K)+(r-q+sigma^2/2)*T)/(sigma*SQRT(T))
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.

Educational illustrations using hypothetical data. Model sensitivities and theoretical hedges are estimates; they do not guarantee trading outcomes.