568 Chapter 20
−−
−
↑
[([]) ([])]SN d X X e N d X
rT
12Call Call Call
Short call
−− + −
[]
()
−
↑
SN d X X e N d X
rT
([ ])
12Put Put Put
Long put
=− + −
↑
SNd X N d X(([ ]) ( [ ]))
11Call Put
Short stock possition
Call Call Put P
++−
−
eXNdX XNdX
rT
[([]) ([
22uut
Long bond position
])]
↑
We rewrite this expression in terms of Greeks:
−+−
↑
SNd X N d X[([ ]) ( [ ])]
11Call Put
Short stock position
−+−
−
↑
eXNdX XNdX
rT
[([]) ([])]
Call Call Put Put
Long bond po
22
ssition
Call Call Put Put
=− − +
−
SX Xe
r
[()()]ΔΔ
TT
X NdX X N dX[([]) ([])]
Call Call Put Put22
+−
Here’s a run of a simulated position over the course of a year. In this
simulation the position is updated every Δt = 0.05; assuming 250 trading
days in a year, this is approximately every 12 days.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
FEDCBA G
5S 5.00
X
Call
70.00
X
Put
49.04
4r.00%
Sigma 40%
Time until
expiration
Stock price
Stock =-
B9*(calldelta(B9,$B$3,A9,$B$5,$B$6)-
putdelta(B9,$B$4,A9,$B$5,$B$6)) Bond
Porfolio
value
Portfolio
cash flow
1.00 55.00 -36.28 36.28 0.00 0.00
0.95 53.57 -34.75 35.77 1.02 0.00 <-- =(C9*B10/B9-C10)-(D10-D9*EXP($B$5*(A9-A10)))
0.90 52.39 -33.49 35.34 1.85 0.00 <-- =(C10*B11/B10-C11)-(D11-D10*EXP($B$5*(A10-A11)))
0.85 48.07 -30.81 35.49 4.68 0.00 <-- =(C11*B12/B11-C12)-(D12-D11*EXP($B$5*(A11-A12)))
0.80 49.46 -30.98 34.84 3.86 0.00
0.75 50.33 -30.86 34.25 3.39 0.00
0.70 50.54 -30.40 33.73 3.33 0.00
0.65 58.10 -34.27 33.12 -1.15 0.00
0.60 55.71 -31.57 31.90 0.32 0.00
0.55 67.93 -43.58 37.04 -6.54 0.00
0.50 66.69 -40.90 35.23 -5.67 0.00
0.45 73.10 -50.24 40.71 -9.53 0.00
0.40 78.79 -60.20 46.84 -13.36 0.00
0.35 72.21 -47.38 39.15 -8.23 0.00
0.30 77.20 -57.29 45.86 -11.43 0.00
0.25 73.30 -48.65 40.20 -8.45 0.00
0.20 85.78 -77.08 60.44 -16.65 0.00
0.15 80.97 -69.22 57.01 -12.20 0.00
0.10 82.00 -74.69 61.72 -12.97 0.00
0.05 99.59 -99.59 70.72 -28.87 0.00 <-- =(C27*B28/B27-C28)-(D28-D27*EXP($B$5*(A27-A28)))
0.00 89.31 -18.44 <-- =C28*B29/B28+D28*EXP($B$5*(A28-A29))
Check: Collar payoff to client at time 0
Short call payoff -19.31 <-- =-MAX(B29-B3,0)
Long put payoff 0.00 <-- =MAX(B4-B29,0)
Total -19.31 <-- =SUM(B32:B33)
Payoff to bank from delta hedge
-18.44 <-- =E29
Terminal cash
flow to bank
0.86 <-- =-B34+B37
DELTA HEDGING A COLLAR