ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Derrived from:Cryptocurrencies Value Calculator
2
Authors:Pablo Yabo
http://blog.coinfabrik.com/live-updated-cryptocurrency-investment-tracking-spreadsheet/
3
Luke Stokes
https://steemit.com/crypto/@lukestokes/the-cryptocurrency-bank-spreadsheet
4
5
DO NOT REQUEST ACCESS TO THIS SPREADSHEET.

PLEASE MAKE A COPY.

Thank for being your own Cryptocurrency Bank!

API services provided by https://coinmarketcap.com/api/

To get started, go to File -> Make a Copy. Add your favorite currencies to columns A and B (currency name and symbol). Then add the assets you own to column H. Next, update your transaction history with your purchases and transfers. Add your own exchange and wallet names. The spreadsheet will let you enter the rate you bought against BTC, USD, BTS, or ETH. It will then display your profit or loss and % change based on the current prices. When adding transfers between wallets, leave the rate as 0. It can also be helpful to add notes to your cells. For a sale, enter a negative amount. It's helpful to double entry so if you sell one currency for another, put in the sale on one line and then increase your balance of the other currency on a separte line.

If you want to determine what an asset's value is against some other currency (USD, BTC, ETH, or BTS), use the Calculator tab.

To refresh the prices, change the value in M2.

If this spreadsheet is useful to you, please feel free to send some crypto my way and let me know about it on Steemit.

- Luke Stokes

Steemit: @lukestokes
BitShares: @luke-stokes
BTC: 1FkLhWjRCrqVNXbMCxRMeZw3eLXRrNZ3vm

Decentralized Exchanges are the future! Use BitShares: https://wallet.bitshares.org/?r=luke-stokes

Follow me on Steemit: https://steemit.com/@lukestokes
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
Change Log
32
3/26/2017 16:32:35Added a place to keep track of historical total dollar value over time (just copy, paste values)
33
Added a wallet balance feature to see the current balance of all your wallets. To use this feature, add your current wallet balances as transactions and then update the values on the prices & Totals to include a line for each wallet and each asset you have.
34
5/24/2017Temporarily disabled API calls. Contacted cryptocompare who then updated the ratelimit for pricing to make things work again.
35
1/19/2017Updating the spreadsheet to use coinmarketcap's API since the other one was being rate limited. Updating to pull all values at once instead of individually.
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