B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
9
Bull Call Spreads
(E
1
< E
2
)
10
11
Buy Call @ E
1
Profit = Max(0, S - E
1
) - C
1
- Max(0, S - E
2
) + C
2
12
Write Call @ E
2
S = spot price, E
n
= excerise at price n, C
n
= call price (premium)
n
13
14
Spot
15
16
Call
1
17
Call
2
18
Exec
1
19
Exec
2
20
21
22
23
24
25
Change the spot, stock, call and exec values and see how the profit changes.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Copyright.
Anthony's VBA Page.
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.