ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
↓ Enter your coins here (Use local wallets to protect your assets when possible!)
↓ Enter your unit purchase price in BTC
2
COIN IDSymbolBTCUSDEUR24h7dRankMY COINSBTCUSDEURPercentLocal WalletBittrexCoinbaseothersDescriptionPurchase(BTC)Gain25.00%10.00%-5.00%Local %Local WalletExchange
3
BitcoinBTC1US$6,417.24€5,666.080.17%-0.01%10.30.3US$1,925.17€1,699.8267.42%0.10.10.1Electrum / Poloniex10.00%1.250000001.100000000.9500000033.33%US$641.72US$1,283.45
4
EthereumETH0.03291507US$211.48€186.73-0.14%1.46%230.09874521US$634.44€560.1822.19%21MEW + MetaMask0.11-70.08%0.137500000.121000000.1045000066.67%US$422.96US$211.48
5
RippleXRP0.00007869US$0.51€0.450.14%9.07%3100.0007869US$5.06€4.460.18%100.00009357-15.90%0.000116960.000102930.00008889100.00%US$5.06US$0.00
6
SteemSTEEM0.00011554US$0.74€0.66-2.32%-6.19%411000.011554US$74.24€65.562.60%100(Steemit.com)0.0007-83.49%0.000875000.000770000.000665000.00%US$0.00US$74.24
7
NEONEO0.00247786US$15.92€14.06-0.07%-3.71%15100.0247786US$159.20€140.575.57%100.0028-11.51%0.003500000.003080000.00266000100.00%US$159.20US$0.00
8
Basic Attention TokenBAT0.0000391US$0.25€0.22-5.37%-15.77%34100.000391US$2.51€2.220.09%100.000000000.000000000.000000000.00%US$0.00US$2.51
9
golem-network-tokensGNT0.0000254US$0.16€0.14-1.41%-1.83%49100.000254US$1.63€1.440.06%100.000000000.000000000.000000000.00%US$0.00US$1.63
10
EOSEOS0.00084318US$5.42€4.780.63%-0.88%6100.0084318US$54.17€47.831.90%10EOS (not claimed)0.00085.40%0.001000000.000880000.000760000.00%US$0.00US$54.17
11
To add a new coin, copy a new row and change COIN ID and your coin holdings.
Find coin from coinmarketcap.com and use the last part of the URL for COIN ID.
00US$0.00€0.000.00%
12
-
Updated: Mon Nov 12 2018 13:10:46 GMT+0900 (JST)
TOTAL $0.44494151US$2,856.43€2,522.09100.00%US$1,228.94US$1,627.48
13
Local WalletExchange
14
MAJOR COINS
(RANK 1-5)
89.79%43.02%56.98%
15
ALT COINS10.21%
16
https://trybe.one/cryptocurrency-portfolio-v3-for-google-sheets
17
18
19
20
HOW TO USE:
1. From File menu, select "Make a copy..." to save.
2. Edit only fields with green background (COIN ID / coins / secondary currency)
3. From Tools menu, select "Script Editor...", and select "UPDATE" from "Select function...".
4. From the script editor, press "▶" to update price. On first run, you need to allow access.
5. Press the timer button, and select "Add trigger...". UPDATE function can be registered to run automatically.

Secondary Currency: (EUR). you can change it to other currency.
AUD, BRL, CAD, CHF, CNY, EUR, GBP, HKD, IDR, INR, JPY, KRW, MXN, RUB
You can change the format of the cells to display properly. (Format - Number - More Formats - More Currencies)

Purchase Unit Price(BTC): If purchase price is provided, Percent Gain is calculated.
25%, 10%, -5% unit price is also shown, so you can use it for sell price, stop losses...
% can be changed from the header.

History: You can track your portfolio history by calling "RECORD_HISTORY" once per day from script editor.
This features might have some bugs. Please contact me if you find a bug.

* Uses coinmarketcap.com API.
21
22
HODL! : I did some panic sells and lost faith on some coins along the way. I should have just HODL.
This portfolio did better than my personal investments.
23
24
Sheet / Script by mix1009@gmail.com
25
https://steemit.com/cryptocurrency/@mix1009/cryptocurrency-portfolio-template-for-google-sheets
26
27
💎 If you are not a Binance user, please use my referal link to join:
https://www.binance.com/?ref=10032265
28
💎 Donate Bitcoin : 18WMco1QFdWH53rrvmHLb4WKHSir33fzf8
29
💎 Donate ETH : 0xAd722B025FF970bcFDa1732eC17818A5E55cacE5
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