Update coins price
function updatePoloniex()
{
var response = UrlFetchApp.fetch("https://poloniex.com/public?command=returnTicker");
// TODO: set your sheet name here
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Coins");
var json = JSON.parse(response.getContentText());
var rateeth = json.BTC_ETH.last;
var rateetc = json.BTC_ETC.last;
var ratesc = json.BTC_SC.last;
var ratedgb = json.BTC_DGB.last;
var ratexmr = json.BTC_XMR.last;
var ratexrp = json.BTC_XRP.last;
var ratestr = json.BTC_STR.last;
var ratezec = json.BTC_ZEC.last;
var ratesys = json.BTC_SYS.last;
var ratenxt = json.BTC_NXT.last;
var ratexem = json.BTC_XEM.last;
var rateburst = json.BTC_BURST.last;
var ratesteem = json.BTC_STEEM.last;
// TODO: set column coordinates here in format (column, row); this is now set to A1
sheet.getRange(2, 1).setValue(rateeth);
sheet.getRange(2, 2).setValue(rateetc);
sheet.getRange(2, 3).setValue(ratesc);
sheet.getRange(2, 4).setValue(ratedgb);
sheet.getRange(2, 5).setValue(ratexmr);
sheet.getRange(2, 6).setValue(ratestr);
sheet.getRange(2, 7).setValue(ratexrp);
sheet.getRange(2, 8).setValue(ratesys);
sheet.getRange(2, 9).setValue(ratesys);
sheet.getRange(6, 1).setValue(ratezec);
sheet.getRange(6, 2).setValue(ratexem);
sheet.getRange(6, 3).setValue(rateburst);
sheet.getRange(6, 4).setValue(ratesteem);
}
/*
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Refresh", functionName: "onOpen"} ];
ss.addMenu("BTCE Ticker", menuEntries);
var range = ss.getSheets()[0].getRange("A1:A1");
var url = 'https://btc-e.com/api/2/btc_usd/ticker';
var content = UrlFetchApp.fetch(url).getContentText();
SpreadsheetApp.setActiveRange(range);
SpreadsheetApp.getActiveRange().setValue(content);
};
Bittrex
https://bittrex.com/api/v1.1/public/getmarketsummary?market=btc-ltc
*/
function updateBittrex()
{
var responseaeon = UrlFetchApp.fetch("https://bittrex.com/api/v1.1/public/getmarketsummary?market=btc-aeon");
var responsexdn = UrlFetchApp.fetch("https://bittrex.com/api/v1.1/public/getmarketsummary?market=btc-xdn");
var responsexvg = UrlFetchApp.fetch("https://bittrex.com/api/v1.1/public/getmarketsummary?market=btc-xvg");
var responseburst = UrlFetchApp.fetch("https://bittrex.com/api/v1.1/public/getmarketsummary?market=btc-burst");
// TODO: set your sheet name here
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("BTC");
//var json = JSON.parse(response.getContentText());
//var ratebtc = json2.btc_usd.last;
// TODO: set column coordinates here in format (column, row); this is now set to A2
sheet.getRange(2, 1).setValue(responseaeon);
sheet.getRange(3, 1).setValue(responsexdn);
sheet.getRange(4, 1).setValue(responsexvg);
sheet.getRange(5, 1).setValue(responseburst);
}
function updateBTCe()
{
var response = UrlFetchApp.fetch("https://btc-e.com/api/2/btc_usd/ticker");
// TODO: set your sheet name here
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("BTC");
var json2 = JSON.parse(response.getContentText());
//var ratebtc = json2.btc_usd.last;
// TODO: set column coordinates here in format (column, row); this is now set to A2
sheet.getRange(1, 1).setValue(response);
}
/**
* Retrieves exchange rates from both exchanges.
*/
function updateAll()
{
updatePoloniex();
updateBTCe();
updateBittrex();
}
/**
* Adds a custom menu to the active spreadsheet, containing a single menu item
* for invoking the function specified above.
* The onOpen() function, when defined, is automatically invoked whenever the
* spreadsheet is opened.
* For more information on using the Spreadsheet API, see
* https://developers.google.com/apps-script/service_spreadsheet
*/
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries = [{
name : "Update Poloniex rate",
functionName : "updatePoloniex"
}, {
name : "Update BTCe rate",
functionName : "updateBTCe"
}, {
name : "Update all",
functionName : "updateAll"
}];
sheet.addMenu("Scripts", entries);
};
Public Last updated: 2017-05-27 01:58:38 AM
