I like it, where can i get one of those ?
It's just a google spreadsheet and JSON. Something like this for multipool:
var range = ss.getSheets()[0].getRange("A1:A1");
var url = 'https://multipool.us/api.php?api_key=';
var content = UrlFetchApp.fetch(url).getContentText();
var mydata = Utilities.jsonParse(content);
/* LTC */
var datacut = mydata['currency']['ltc']['confirmed_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(datacut);
var range = ss.getSheets()[0].getRange("A2:A2");
var mydata = Utilities.jsonParse(content);
var datacut = mydata['currency']['ltc']['estimated_rewards'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(datacut);
var range = ss.getSheets()[0].getRange("A3:A3");
var mydata = Utilities.jsonParse(content);
var datacut = mydata['currency']['ltc']['hashrate'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(datacut);
Then just repeat for each coin (without the pulling the URL again).
You can then get the cryptsy prices, with:
var range = ss.getSheets()[0].getRange("A4:A4");
var url = 'http://pubapi.cryptsy.com/api.php?method=marketdata';
var content = UrlFetchApp.fetch(url).getContentText();
var ticker = Utilities.jsonParse(content);
var price = ticker['return']['markets']['LTC']['lasttradeprice'];
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(price);
Then just repeat that again for each coin (also without pulling the URL again).
That should give you most of the data that you would need. Mine also updates difficulty and estimated reward per day based on x hash rate. But, I don't feel like getting into all that. Hope this helps.
Awesome thank you !!!!!