DEMO - end_of_day.xlsx - Google Sheets

	A	B	C	D	E
1	Index	vntw-hodlx-10-d
2	Current date	2022-06-24
3	Rebalance date	2022-05-16
4	Current index value	904.62
5	Rebalance index value	1293.39
6
7	Asset	Rebalance price (USD)	Current price (USD)	Rebalance weight	Current weight
8	ADA	0.5545	0.496	0.02172173	0.02778031
9	AVAX	32.61	19.24	0.0103621	0.00874107
10	BNB	294.11	236.31	0.05105949	0.05865586
11	BTC	29458.4	21093.91	0.59535794	0.60952104
12	DOT	10.52	8.029	0.01194735	0.01303707
13	ETH	1998.92	1199.76	0.26013033	0.22323001
14	MATIC	0.6723	0.576	0.00642756	0.00787351
15	SOL	52.24	40.16	0.01897952	0.02086116
16	XRP	0.41371	0.3651	0.02401397	0.03029998
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	Price data: cryptocurrency exchanges, see https://www.vinterapi.com/api/v2/active_single_assets/
75	Reference rates: The exact reference rates used in the calculation can be found at www.vinterapi.com/api/v2/active_multi_assets/
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