CryptoHodlings V2
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
3
Coin Name:USD per coin:
Quantity owned:
Holdings (USD):Holdings (EUR):Percent of Portfolio:
24h Volume (Mil USD)
4
BTC3666.560.05 $ 195.60 171.709609534.62% $ 5,461,384,457.06
5
WAVES2.5924.43 $ 63.37 55.6299545311.21% $ 18,739,102.86
6
GNT0.07232.26 $ 15.45 13.560960092.73% $ 2,196,164.55
7
FCT6.284.73 $ 29.71 26.077828235.26% $ 149,099.62
8
ETH123.390.71 $ 87.04 76.4058188115.40% $ 2,581,026,351.19
9
XMR45.443.18 $ 144.50 126.84576525.57% $ 27,964,917.61
10
SC0.005041.05 $ 12.55 11.017270622.22% $ 1,131,623.35
11
MAID0.12140.88 $ 16.87 14.807810482.99% $ 174,260.77
12
NaN
13
Date/Time:NET WORTH (USD):
14
1/17/2019 16:04:58$565.09
15
NaN
16
NaN k
17
NaN
18
NaN
19
NaN
20
NaN
21
NaN
22
NaN
23
NaN
24
NaN
25
NaN
26
NaN
27
NaN
28
NaN
29
NaN
30
NaN
31
NaN
32
NaN
33
NaN
34
NaN
35
NaN
36
NaN
37
NaN
38
NaN
39
NaN
40
NaN
41
NaN
42
NaN
43
NaN
44
NaN
45
NaN
46
NaN
47
NaN
48
NaN
49
NaN
50
NaN
51
NaN
52
NaN
53
NaN
54
NaN
55
NaN
56
NaN
57
NaN
58
NaN
59
NaN
60
NaN
61
NaN
62
NaN
63
NaN
64
NaN
65
NaN
66
NaN
67
NaN
68
NaN
69
NaN
70
NaN
71
NaN
72
NaN
73
NaN
74
NaN
75
NaN
76
NaN
77
NaN
78
NaN
79
Instructions for getting spreadsheet
to update automatically for you:
80
Step 1:

Download the spreadsheet by creating a copy on your own Google Drive (In this sheet, click 'File' ---> 'Make a copy').
Then, open your copy and click on the 'Tools' button in the Google Spreadsheets menu.
81
Step 2:

In the 'Tools' menu, select 'Script editor'.
82
Step 3:

This will take you to the script editor interface, where you have to paste the following code (just copy the code in
cell A84, below, from this sheet). What this code does is it fetches the values of your coin holdings from cells in
your spreadsheet and saves these values as historical data. You can easily modify this code to suit your needs later on.
83
NA
It should look like the image below. Make sure
there are no quotes at the beginning or end of your paste.
84
function cacheFunc(){
SpreadsheetApp.getActiveSpreadsheet().getRange('A1').setValue(Math.random());
}
function saveData() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var netWorth = sheet.getRange('Sheet1!E14').getValue();
var BTC = sheet.getRange('Sheet1!D4').getValue();
var BTCv = sheet.getRange('Sheet1!G4').getValue();
var WAVES = sheet.getRange('Sheet1!D5').getValue();
var WAVESv = sheet.getRange('Sheet1!G5').getValue();
var GNT = sheet.getRange('Sheet1!D6').getValue();
var GNTv = sheet.getRange('Sheet1!G6').getValue();
var FCT = sheet.getRange('Sheet1!D7').getValue();
var FCTv = sheet.getRange('Sheet1!G7').getValue();
var ETH = sheet.getRange('Sheet1!D8').getValue();
var ETHv = sheet.getRange('Sheet1!G8').getValue();
var XMR = sheet.getRange('Sheet1!D9').getValue();
var XMRv = sheet.getRange('Sheet1!G9').getValue();
var SC = sheet.getRange('Sheet1!D10').getValue();
var SCv = sheet.getRange('Sheet1!G10').getValue();
var MAID = sheet.getRange('Sheet1!D11').getValue();
var MAIDv = sheet.getRange('Sheet1!G11').getValue();
var netWorth = sheet.getRange('Sheet1!G14').getValue();
var date = sheet.getRange('Sheet1!F14').getValue();
sheet.appendRow([date,netWorth, BTC, WAVES, GNT, FCT, ETH, XMR, SC, MAID, BTCv, WAVESv, GNTv, FCTv, ETHv, XMRv, SCv, MAIDv]);
}

function search(symbol, myArray) {
for (var i=0; i < myArray.length; i++) {
if (myArray[i].symbol == symbol) {
return myArray[i];
}
}
return myArray[0];
}
function cmc(symbol, key, rand) {
var url = "https://api.coinmarketcap.com/v1/ticker/?convert=USD&limit=70";
var response = UrlFetchApp.fetch(url);
var text = response.getContentText();
var obj_array = JSON.parse(text);
var obj = search(symbol, obj_array);
var value = obj[key];
return parseFloat(value);
}
85
NA
86
Step 4:

Finally, click on the little watch icon which says 'Triggers', seen below:
87
NA
88
NA
89
NA
90
NA
91
NA
92
Step 5:

Then put these settings in by clicking 'Add new trigger':
93
NaN
94
NaN
95
NaN
96
NaN
97
NaN
98
NaN
99
NaN
100
101
NaN
102
NaN
Loading...
Main menu