Skip to content

Instantly share code, notes, and snippets.

@reazuliqbal
Created February 13, 2018 05:10
Show Gist options
  • Save reazuliqbal/eb7b71652ad0551cde046b0e99d87280 to your computer and use it in GitHub Desktop.
Save reazuliqbal/eb7b71652ad0551cde046b0e99d87280 to your computer and use it in GitHub Desktop.
function BittrexARB(pair) {
pair = (typeof pair !== 'undefined') ? pair : "BTC-LTC";
var doc = SpreadsheetApp.getActiveSpreadsheet();
var sheet = doc.getSheets()[0];
var response = UrlFetchApp.fetch('https://bittrex.com/api/v1.1/public/getorderbook?market='+ pair +'&type=both');
var data = JSON.parse(response.getContentText());
var row = [];
row.push(data.result.buy[0].Rate, data.result.buy[0].Quantity, data.result.sell[0].Rate, data.result.sell[0].Quantity);
return row;
}
function BinanceARB(pair) {
pair = (typeof pair !== 'undefined') ? pair : "BTC-LTC";
var sym = pair.toString().split("-");
var market = sym[1]+sym[0];
var doc = SpreadsheetApp.getActiveSpreadsheet();
var sheet = doc.getSheets()[0];
var response = UrlFetchApp.fetch('https://api.binance.com/api/v1/ticker/bookTicker?symbol='+ market);
var data = JSON.parse(response.getContentText());
var row = [];
row.push(Number(data.bidPrice), Number(data.bidQty), Number(data.askPrice), Number(data.askQty));
return row;
}
function KucoinARB(pair) {
pair = (typeof pair !== 'undefined') ? pair : "BTC-LTC";
var sym = pair.toString().split("-");
var market = sym[1]+'-'+sym[0];
var doc = SpreadsheetApp.getActiveSpreadsheet();
var sheet = doc.getSheets()[0];
var response = UrlFetchApp.fetch('https://api.kucoin.com/v1/open/orders?symbol='+ market +'&limit=1&group=1');
var data = JSON.parse(response.getContentText());
var row = [];
row.push(data.data.SELL[0][0], data.data.SELL[0][1], data.data.BUY[0][0], data.data.BUY[0][1]);
return row;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment