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.