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	$13,584.14	226	$3,071,809.88	$2,035,188.75	$5,106,998.63	60.15%	189
10	01/01/2019	$3,827.96	38	$143,913.43	$4,596,298.77	$4,740,212.20	3.04%	0
11	01/01/2020	$7,185.44	38	$270,138.95	$4,596,298.77	$4,866,437.71	5.55%	0
12	01/01/2021	$29,394.66	38	$1,105,101.16	$4,596,298.77	$5,701,399.92	19.38%	18
13	01/01/2022	$47,740.14	19	$925,969.65	$5,131,259.93	$6,057,229.58	15.29%	7
14	01/01/2023	$16,613.40	13	$210,789.45	$5,451,506.62	$5,662,296.07	3.72%	0
15	01/01/2024	$44,204.37	13	$560,861.40	$5,451,506.62	$6,012,368.02	9.33%	0
16	01/01/2025	$93,462.86	13	$1,185,849.06	$5,451,506.62	$6,637,355.68	17.87%	6
17	09/01/2025	$94,409.58	7	$670,458.79	$5,973,620.11	$6,644,078.90	10.09%	0
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