Bitcoin Forum

function getBitcoinBalance(bitcoinAddress) {
  var response = UrlFetchApp.fetch('http://blockchain.info/address/' + bitcoinAddress + '?format=json');
  var json = response.getContentText();
  var data = JSON.parse(json);
  return data.final_balance * Math.pow(10,-8);
}

function getBitcoinCashBalance(bitcoinCashAddress) {
  var response = UrlFetchApp.fetch('https://blockdozer.com/insight-api/addr/' + bitcoinCashAddress + '/balance');
  var json = response.getContentText();
  var data = JSON.parse(json);
  return data * Math.pow(10,-8);
}

function getCoinfloorPrice(cur1, cur2) {
  var response = UrlFetchApp.fetch('https://webapi.coinfloor.co.uk:8090/bist/' + cur1 + '/' + cur2 + '/ticker/');
  var json = response.getContentText();
  var data = JSON.parse(json);
  return Number(data.last);
}

function getCryptowatchPrice(exchange, pair) {
  var response = UrlFetchApp.fetch('https://api.cryptowat.ch/markets/' + exchange + '/' + pair + '/price');
  var json = response.getContentText();
  var data = JSON.parse(json);
  return data.result.price;
}

=getBTCBalance($A$1,CONCATENATE("https://blockchain.info/q/addressbalance/",C7))/100000000

function getCryptowatchPrice(exchange, pair) {
  var response = UrlFetchApp.fetch('https://api.cryptowat.ch/markets/' + exchange + '/' + pair + '/price');
  var json = response.getContentText();
  var data = JSON.parse(json);
  return data.result.price;
}