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 = "https://poloniex.com/public?command=returnTicker";

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!

1 Answer 1


I suggest using a library for this. This is the one I use: link

Code would then be: =CRYPTOFINANCE("COINMARKETCAP:ETH/USD", "price")

The library explains itself rather well.

  • Thank you for the answer but I was looking more to integrate without an add-on!
    – David
    Dec 5, 2017 at 9:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.