CryptoCurrency Portfolio

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	Y	Z	AA
1														↓ Enter your coins here (Use local wallets to protect your assets when possible!)					↓ Enter your unit purchase price in BTC
2	COIN ID	Symbol	BTC	USD	EUR	24h	7d	Rank	MY COINS	BTC	USD	EUR	Percent	Local Wallet	Bittrex	Coinbase	others	Description	Purchase(BTC)	Gain	25.00%	10.00%	-5.00%	Local %	Local Wallet	Exchange

3	Bitcoin	BTC	1	US$6,417.24	€5,666.08	0.17%	-0.01%	1	0.3	0.3	US$1,925.17	€1,699.82	67.42%	0.1		0.1	0.1	Electrum / Poloniex	1	0.00%	1.25000000	1.10000000	0.95000000	33.33%	US$641.72	US$1,283.45
4	Ethereum	ETH	0.03291507	US$211.48	€186.73	-0.14%	1.46%	2	3	0.09874521	US$634.44	€560.18	22.19%	2		1		MEW + MetaMask	0.11	-70.08%	0.13750000	0.12100000	0.10450000	66.67%	US$422.96	US$211.48
5	Ripple	XRP	0.00007869	US$0.51	€0.45	0.14%	9.07%	3	10	0.0007869	US$5.06	€4.46	0.18%		10				0.00009357	-15.90%	0.00011696	0.00010293	0.00008889	100.00%	US$5.06	US$0.00
6	Steem	STEEM	0.00011554	US$0.74	€0.66	-2.32%	-6.19%	41	100	0.011554	US$74.24	€65.56	2.60%				100	(Steemit.com)	0.0007	-83.49%	0.00087500	0.00077000	0.00066500	0.00%	US$0.00	US$74.24
7	NEO	NEO	0.00247786	US$15.92	€14.06	-0.07%	-3.71%	15	10	0.0247786	US$159.20	€140.57	5.57%	10					0.0028	-11.51%	0.00350000	0.00308000	0.00266000	100.00%	US$159.20	US$0.00
8	Basic Attention Token	BAT	0.0000391	US$0.25	€0.22	-5.37%	-15.77%	34	10	0.000391	US$2.51	€2.22	0.09%		10						0.00000000	0.00000000	0.00000000	0.00%	US$0.00	US$2.51
9	golem-network-tokens	GNT	0.0000254	US$0.16	€0.14	-1.41%	-1.83%	49	10	0.000254	US$1.63	€1.44	0.06%		10						0.00000000	0.00000000	0.00000000	0.00%	US$0.00	US$1.63
10	EOS	EOS	0.00084318	US$5.42	€4.78	0.63%	-0.88%	6	10	0.0084318	US$54.17	€47.83	1.90%				10	EOS (not claimed)	0.0008	5.40%	0.00100000	0.00088000	0.00076000	0.00%	US$0.00	US$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.							0	0	US$0.00	€0.00	0.00%
12	-	Updated: Mon Nov 12 2018 13:10:46 GMT+0900 (JST)							TOTAL $	0.44494151	US$2,856.43	€2,522.09	100.00%												US$1,228.94	US$1,627.48
13																									Local Wallet	Exchange
14												MAJOR COINS (RANK 1-5)	89.79%												43.02%	56.98%
15												ALT COINS	10.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