Hello does anybody know how to import the Bitcoin price in euro into a Google Sheets document by using the IMPORTXML function?
I am as far as I get the Bitcoin USD price -
=IMPORTXML("https://coinmarketcap.com/currencies/bitcoin/"; "//span[@class='h2 text-semi-bold details-panel-item--price__value']")
by inspecting the CoinMarketCap site I can see the Bitcoin euro price is shown but I do not understand how to refer to it?
<span class="h2 text-semi-bold details-panel-item--price value" data-currency-value="">€3.211,55</span>