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 Put Spreads
(E
1
< E
2
)
10
11
Buy Put @ E
1
Profit = Max(0, E
1
- S) - P
1
- Max(0, E
2
- S) + P
2
12
Write Put @ E
2
S = spot price, E
n
= excerise at price n, P
n
= put price (premium)
n
13
14
Spot
15
16
Put
1
17
Put
2
18
Exec
1
19
Exec
2
20
21
22
23
24
25
Change the spot, stock, put 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.