A | B | |
---|---|---|
1 | INSTRUCTIONS | |
2 | 1 | Click File>Make a Copy to add this to your own Google Drive |
3 | 2 | Install the SHEETS extension CRYPTO FINANCE |
4 | 3 | Add your addresses in PORTFOLIO tab, column C |
5 | 4 | Add your cash investements in INVEST tab |
6 | 5 | Click Tools > Script Editor - go to the script tab in your browser |
7 | 6 | Add your email address in Line 29 |
8 | 7 | If you modifed the number of rows, update the BALANCE, INVEST & PROFIT cells at script rows 10,11 & 12 |
9 | 8 | Click File >Save |
10 | 9 | Click Edit > Current Project Triggers |
11 | 10 | Click > No triggers set up. Click here to add one now |
12 | 11 | Select these options, or choose your own times, then click save |
13 | ||
14 | ||
15 | ||
16 | ||
17 | ||
18 | ||
19 | ||
20 | ||
21 | 12 | Repeat step 7 |
22 | 13 | Modify a few alert levels in PORTFOLIO tab to be greater than current price |
23 | 14 | Test the script by selecting RUN > logValues and RUN > sendAlert |
24 | 15 | Close the script page if all runs well |
25 | 16 | Share your modifications here - let's contribute and make a great portfolio tracker! |
26 | 17 | Send a tip to show your appreciation! |
27 | ||
28 | BTC | 1J7EQ31fDrKprZjMfQBVJ4hyhaAkgJRDXm |
29 | ETH | 0xa04748b7ef6439cf5736ce4d2ce961b1c3391035 |
30 | XEM | NCIKV5KZIAXXIX65QMPW4TUNDMBDBOFSGRN365LK |
31 | LTC | LLD233QeziKnDq2CaNAE6x6fXFoV4TnxwJ |
32 | Genesis Mining | QNifrD (we both benefit!) |
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 |