user63397: 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! 

user50144: 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.

63397: <p>How can I integrate the <strong>real-time</strong> value of the BTC/EUR pair to a Google sheet? What script can I use? </p>

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

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

<blockquote>
  <p>function getETHtoUSDTpoloniex() {
  var url = "<a href="https://poloniex.com/public?command=returnTicker" rel="nofollow noreferrer">https://poloniex.com/public?command=returnTicker</a>";</p>
  
  <p>var response = UrlFetchApp.fetch(url);
  var test = response.getContentText();</p>
  
  <p>var myjson = JSON.parse(test);
  //var leng = myjson.data.length;</p>
  
  <p>var USDT_ETH = myjson["USDT_ETH"];</p>
  
  <p>var price = USDT_ETH.last;</p>
  
  <p>return parseFloat(price); }</p>
</blockquote>

<p>Help please! </p>
 50144: <p>I suggest using a library for this.
This is the one I use: <a href="https://chrome.google.com/webstore/detail/cryptofinance/bhjnahcnhemcnnenhgbmmdapapblnlcn?hl=en" rel="nofollow noreferrer">link</a></p>
<p>Code would then be: <code>=CRYPTOFINANCE(&quot;COINMARKETCAP:ETH/USD&quot;, &quot;price&quot;)</code></p>
<p>The library explains itself rather well.</p>
