B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
9
Basic Options
10
11
Write Put
Profit = -Max(0, E - S) + P
12
S = spot price, E = strike/excerise price, P = put price (premium)
13
14
Spot
15
16
Put
17
Exec
18
19
20
21
22
23
Change the spot, put and exec values and see how the profit changes.
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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.