Crypto Investment Performance Sheet (@HaDuong_)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Comments
07.12.2017
2
IntroHi everyone,

I just recently started digging deeper into the crypto space and found the incredible support within this community extremely valuable. I'd like to give back so that others can enter the ecosystem as easily as I did. Hence, I created this investment tracking tool that you can use for your cryptoassets.

Please find the original article here:
https://medium.com/@Ha.Duong

You can find a simpler version for Coinbase users here:
https://docs.google.com/spreadsheets/d/1pwIjhpxopcA2V625K3sOO1pfDfVIEmAzg2INX8hAptc/edit?usp=sharing

If you think this was useful please share your love with a tweet or a like on Medium. Of course, I’d also be happy with a small donation (BTC: 18APi2Nk1p5L7iEmJM7aG5h6GUqxvWEUS7 & ETH: 0x0356fd48514D2EE84B13f06D741B62DEed351e23) :)
3
Step by step instructions:1) Click on file > make a copy to create your own sheet that you can edit.
2) You might need to enable your Google Sheet to run a) the cryptofinance() function and b) the importjson() functions. See instructions for a) here: https://medium.com/r/?url=https%3A%2F%2Fjbuty.com%2Fhow-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14 (thanks to Julien Buty) and for b) here: https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a (thanks to Paul Gambill).
3) You don’t need to change anything on the sheet “Crypto Portfolio” besides the names of the cryptoassets you want to track (needs to be the same as in the sheet “Crypto Trades”). Enter your recent investments, trades, or crypto-to-crypto exchanges in the sheet “Crypto Trades” like in the examples given.
4) Add a new row per deposit (transfering money to the wallet or exchange) by entering the data in columns G & H. The grey fields are formulas while the white fields are for your inputs.
5) For each transaction, add a new row. Only enter the volumes for the 2 currencies (fiat or crypto) that were affected by the transaction (columns I-P). The exchange rates (columns C & D) will automatically be calculated.
6) You can find your token balance on row 2 in this sheet and also on the “Crypto Portfolio” sheet.
7) The values and charts on the “Crypto Portfolio” sheet should automatically update once you refresh (Ctrl + F5).

Please note that the Cryptocompare API calls sometimes fail due to high request volume so some fields will show “#VALUE” until you refresh. Best would be for you to copy and paste only the values (Ctrl+shift+v) into the fields for the rows where the API requests were successful so that your sheet won’t need to request everything each time you open it.
4
Data sourcesCoinmarketcap API, Cryptocompare API
5
About the authorMy name is Ha and I'm an Investment Manager at Project A Ventures in Berlin. I'm excited about nerdy things like AI, blockchain and next gen developer tools. If you know someone I should be talking to please reach out!

Also, if there is anything else I can do for you shoot me a message.

Cheers,
Ha

minhhaduong.com
blog.minhhaduong.com
twitter.com/HaDuong_
linkedin.com/in/minhhaduong
6
7
8
9
10
11
12
13
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
Loading...
 
 
 
About
Crypto Portfolio
Crypto Trades
 
 
Main menu