Integrate Bitcoin price in Google Sheets through Google Script

Integrate Bitcoin price in Google Sheets through Google Script

How can I integrate the real-time value of the BTC/EUR pair to a Google sheet? What script can I use?

For ETH/USD I use Poloniex and a script for that, but there is no BTC/EUR pair on Poloniex.

This is the script I use for Poloniex and the ETH/USD pair:

function getETHtoUSDTpoloniex() { var url = "http://ift.tt/1myUSiE";

var response = UrlFetchApp.fetch(url); var test = response.getContentText();

var myjson = JSON.parse(test); //var leng = myjson.data.length;

var USDT_ETH = myjson["USDT_ETH"];

var price = USDT_ETH.last;

return parseFloat(price); }

Help please!

http://ift.tt/2i1NWxy