(Public) GBTC NAV discount calculator

	A	B	F	G	J	K	L
1
2
3	Bitcoin price (may be delayed?)	10,409.9750				11	0.00100721
4				DATA IMPORT STUFF
5	GBTC	17.83		https://finance.google.com/finance?q=CURRENCY%3ABTC&sq=bitcoin	https://grayscale.co/bitcoin-investment-trust/
6	GBTC NAV	10.48503092	Bitcoin price from Google Finance	10,409.9750 USD	Investment Objective	Shares track the Bitcoin market price, less fees and expenses*
7	Premium	70.05%		+119.98000	Benchmark Index	TradeBlock XBX Index 24-hour VWAP
8					Symbol	GBTC
9					CUSIP	09173T108
10	This spreadsheet model may be wrong, so please do your own homework.				ISIN	US09173T1088
11					Bloomberg	XBTFUND**
12					Inception Date	9/25/2013
13					Annual Fee	2%
14					AUM	$1.761B‡
15					Shares Outstanding	175,984,800‡
16					Bitcoin per Share	0.00100721‡
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