Map current cryptocurrency prices into Google Sheets

get-current-crypto-prices.js

/* USAGE:
 *  Sheet -> Tools -> Script Editor...
 *  Paste this script
 *  Update the map (below) to your preferences
 *  Create a button in your Sheet and Assign Script: `test`
 *  et voila profit
 */
function test() {
  // maps currencies.tokens to sheet ranges
  getPrices({
    'USD': {
      'ETH': 'G6',
      'DASH': 'H6',
      'LTC': 'I6',
      'GNT': 'J6',
      'REP': 'K6',
      'BAT': 'L6'
    }
  });
}

function getPrices(model) {
  for (var currency in model) {
    var tokens = Object.keys(model[currency]).toString();
    var url = 'https://min-api.cryptocompare.com/data/price?fsym=' + currency + '&tsyms=' + tokens;
    var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true});
    var json = JSON.parse(response.getContentText());
    for (var token in model[currency]) {
      updatePrice(
        model[currency][token],
        json[token]
      );
    }
  }
}
function updatePrice(range, price) {
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange(range).setValue(1/price);
}