Google Spreadsheet script to fetch crypto prices?

Does someone have a working script to fetch the actual prices of crypto´s into a google spreadsheet?

i had one that doesn´t seem to work anymore as the prices don´t update anymore.

preferably in EUR, thanks :sunglasses:

2 Likes

I KNOW it’s here. Somebody did one. Search?

1 Like

i assume you mean Cryto invest tracker

That is the one i used until now, but it doesn´t work anymore, prices don´t update

1 Like

Help @solarsoul !!! Help us!

1 Like

I would also be happy if someone can tell me where can I find @peter 's questionare about selecting cryptos. I already asked in another topic. But nobody answered me.

1 Like

should be this :wink:

2 Likes

Simple way:

have a cell in your sheet (in this example the cell is A1)
https://coinmarketcap.com/currencies/bitcoin/

then in B1, have
=IMPORTXML(A1,"//span[@class=‘text-large2’]")`

This should show the price of the coin in B1, for any other coin just do the same thing and replace ‘bitcoin’ with ‘litecoin’ or whatever else you want in the URL.

more complicated way: https://steemit.com/chainbb/@elowin/google-sheets-and-adding-coinmarketcap-api

2 Likes

will check that out, thanks a lot :beers:

1 Like

Great. Thank you very much. :+1:

2 Likes

This is the one I use. Sometimes you have to edit a blank cell then undo it just to wake it up, I dunno why. Small PITA, but quick and easy.

2 Likes

Change the currency to US dollars.
Then change it back to EURO.
It should update then.

2 Likes

add-ons > cryptofinance

then at doc type in =CRYPTOFINANCE(“BTC/EUR”)

if it does not update, just
delete single letter > enter > retype the deleted letter

2 Likes

Hi! I’m new here and thought i can share what I use in google sheet.

2 Likes

Possible to get marketcap using importxml as well?

1 Like

💰 YEN · DCTV ·️ Bitcoin Lambo · 10 Days of Bitcoin ·️ CEO's Brainpan 🧠