ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Copy this sheet to do own analysis. Change the cells in yellow. See:
https://www.pftq.com/blabberbox/?page=Comparing_Options_Contracts
2
Call Option 1Call Option 2Call Option 3BTC Price$48,650.00
Monthly Target
10.00%
3
Strike$52,000.00$54,000.00$56,000.00$58,000.00$60,000.00$51,024.55
Target Price of Underlying
4
Contract Price$0.00$0.00$0.00$0.00$0.0012/3/2021Expiry
5
DeltaBy%0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!
Delta calculated by price ratio to next over strike divided by difference in strike as a percentage of spot.
6
Expected Return
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
vs Bitcoin Return
7
# Contracts100#DIV/0!#DIV/0!#DIV/0!#DIV/0!
How many contracts you need to swap if rolling to a better option.
8
Investment Amt
$0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
vs Investing in Bitcoin to Make Same $ Return
9
$ Return#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
10
Ratio to Option 1
1#DIV/0!#DIV/0!#DIV/0!#DIV/0!
How much more (or less) you need to invest to make the same amount as option 1.
11
12
Strike$50,000.00$52,000.00$54,000.00$56,000.00$58,000.00$53,515.00
Target Price of Underlying
13
Contract Price$0.00$0.00$0.00$0.00$0.0012/10/2021Expiry
14
DeltaBy%0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!
Delta calculated by price ratio to next over strike divided by difference in strike as a percentage of spot.
15
Expected Return
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
vs Bitcoin Return
16
# Contracts12#DIV/0!#DIV/0!#DIV/0!#DIV/0!
How many contracts you need to swap if rolling to a better option.
17
Investment Amt
$0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
vs Investing in Bitcoin to Make Same $ Return
18
$ Return#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
19
Ratio to Option 1
1#DIV/0!#DIV/0!#DIV/0!#DIV/0!
How much more (or less) you need to invest to make the same amount as option 1.
20
21
Strike$50,000.00$55,000.00$60,000.00$65,000.00$70,000.00$58,679.78
Target Price of Underlying
22
Contract Price$9,787.50$0.00$6,712.50$0.00$0.0012/31/2021Expiry
23
DeltaBy%-9.73#DIV/0!-9.73#DIV/0!#DIV/0!
Delta calculated by price ratio to next over strike divided by difference in strike as a percentage of spot.
24
Expected Return
-11.32%#DIV/0!-119.67%#DIV/0!#DIV/0!#DIV/0!
vs Bitcoin Return
25
# Contracts12#DIV/0!1.654814984#DIV/0!#DIV/0!
How many contracts you need to swap if rolling to a better option.
26
Investment Amt
$117,450.00#DIV/0!$11,107.95#DIV/0!#DIV/0!-$64,476.84
vs Investing in Bitcoin to Make Same $ Return
27
$ Return-$13,292.67-$13,292.67-$13,292.67-$13,292.67-$13,292.67
28
Ratio to Option 1
1#DIV/0!0.09457595216#DIV/0!#DIV/0!
How much more (or less) you need to invest to make the same amount as option 1.
29
30
Strike$50,000.00$60,000.00$70,000.00$80,000.00$90,000.00$70,329.02
Target Price of Underlying
31
Contract Price$0.00$0.00$0.00$0.00$0.001/28/2022Expiry
32
DeltaBy%0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!
Delta calculated by price ratio to next over strike divided by difference in strike as a percentage of spot.
33
Expected Return
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
vs Bitcoin Return
34
# Contracts12#DIV/0!#DIV/0!#DIV/0!#DIV/0!
How many contracts you need to swap if rolling to a better option.
35
Investment Amt
$0.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
vs Investing in Bitcoin to Make Same $ Return
36
$ Return#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
37
Ratio to Option 1
1#DIV/0!#DIV/0!#DIV/0!#DIV/0!
How much more (or less) you need to invest to make the same amount as option 1.
38
39
Strike$50,000.00$75,000.00$100,000.00$150,000.00$200,000.00$100,704.07
Target Price of Underlying
40
Contract Price$12,649.50$6,399.50$4,055.00$1,503.00$0.003/25/2022Expiry
41
DeltaBy%-2.431.901.131.65#DIV/0!
Delta calculated by price ratio to next over strike divided by difference in strike as a percentage of spot.
42
Expected Return
300.84%301.66%-82.64%-3379.84%#DIV/0!#DIV/0!
vs Bitcoin Return
43
# Contracts1223.65527338-136.2768902-8.989456399#DIV/0!
How many contracts you need to swap if rolling to a better option.
44
Investment Amt
$151,794.00$151,381.92-$552,602.79-$13,511.15#DIV/0!$426,791.94
vs Investing in Bitcoin to Make Same $ Return
45
$ Return$456,654.80$456,654.80$456,654.80$456,654.80$456,654.80
46
Ratio to Option 1
10.9972852815-3.640478475-0.08900979596#DIV/0!
How much more (or less) you need to invest to make the same amount as option 1.
47
48
Strike$50,000.00$75,000.00$100,000.00$150,000.00$200,000.00$169,182.83
Target Price of Underlying
49
Contract Price$13,500.00$7,960.00$5,575.50$2,399.50$0.006/24/2022Expiry
50
DeltaBy%-2.431.350.831.29#DIV/0!
Delta calculated by price ratio to next over strike divided by difference in strike as a percentage of spot.
51
Expected Return
782.84%1083.20%1140.84%699.45%#DIV/0!#DIV/0!
vs Bitcoin Return
52
# Contracts1214.7083313719.9378585275.56270726#DIV/0!
How many contracts you need to swap if rolling to a better option.
53
Investment Amt
$162,000.00$117,078.32$111,163.53$181,312.72#DIV/0!$511,874.12
vs Investing in Bitcoin to Make Same $ Return
54
$ Return$1,268,193.98$1,268,193.98$1,268,193.98$1,268,193.98$1,268,193.98
55
Ratio to Option 1
10.72270566490.68619463081.119214297#DIV/0!
How much more (or less) you need to invest to make the same amount as option 1.
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100