BTC diversification...

	A	B	C	D	E	F	G	H
1	Date	BTC Price	BTC held	BTC value	USD held	Total Investments	%BTC in portfolio	BTC to sell to rebalance
2	01/01/2011	$0.50	10,000	$5,000.00	$95,000.00	$100,000.00	5.00%	0
3	01/01/2012	$6.00	10,000	$60,000.00	$95,000.00	$155,000.00	38.71%	7,417
4	01/01/2013	$5.00	2,583	$12,916.67	$139,500.00	$152,416.67	8.47%	0
5	01/01/2014	$800.00	2,583	$2,066,666.67	$139,500.00	$2,206,166.67	93.68%	2,308
6	01/01/2015	$300.00	276	$82,731.25	$1,985,550.00	$2,068,281.25	4.00%	0
7	01/01/2016	$430.00	276	$118,581.46	$1,985,550.00	$2,104,131.46	5.64%	0
8	01/01/2017	$1,000.00	276	$275,770.83	$1,985,550.00	$2,261,320.83	12.20%	50
9	01/01/2018	$15,000.00	226	$3,391,981.25	$2,035,188.75	$5,427,170.00	62.50%	190
10	01/01/2019	$6,000.00	36	$217,086.80	$4,884,453.00	$5,101,539.80	4.26%	0
11	01/01/2020	$7,300.00	36	$264,122.27	$4,884,453.00	$5,148,575.27	5.13%	0
12	01/01/2021	$29,000.00	36	$1,049,252.87	$4,884,453.00	$5,933,705.87	17.68%	16
13	12/11/2021	$60,000.00	20	$1,227,663.28	$5,340,335.28	$6,567,998.56	18.69%	10
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
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