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 the btc euro price is shown but I do not understand how to reference to it?
<span class="h2 text-semi-bold details-panel-item--price__value" data-currency-value="">€3.211,55</span>
Thanks your already in advance for any help and clerification.
Article First Published here