Cryptocurrency spreadsheet

[ArpFlush]

Hi all,

Sorry if this was posted in the wrong subforum.
I'm looking for some help with my cryptocurrency spreadsheet. I have made a few columns (cryptocurrency/price/number) and I like to have the "live" price of the currency or token via API calls.

I already found this for bitcoin: =importdata("https://api.bitcoinaverage.com/ticker/EUR/last")
Now I want to find API calls for the other crypto's in my bag. I tried coinmarketcap, polo, kraken, but I don't understand much as I'm not a coder.
Many thanks 

[1715269349]

1715269349

[1715269349]

1715269349

[1715269349]

1715269349

[franky1]

you have to add this script via google spreadsheet
https://github.com/fastfedora/google-docs/blob/master/scripts/ImportJSON/Code.gs

to enable importJSON.

then in google spreadsheets you can have fun playing with data

=ImportJSON("http://api.cryptocoincharts.info/listCoins", "", "noInherit,noTruncate,rawHeaders")
=ImportJSON("http://api.cryptocoincharts.info/tradingPair/ltc_btc", "", "noInherit,noTruncate,rawHeaders")

other api / addresses apply
https://www.cryptocoincharts.info/tools/api

then you can play around with it

[ArpFlush]

you have to add this script via google spreadsheet
https://github.com/fastfedora/google-docs/blob/master/scripts/ImportJSON/Code.gs

to enable importJSON.

then in google spreadsheets you can have fun playing with data

=ImportJSON("http://api.cryptocoincharts.info/listCoins", "", "noInherit,noTruncate,rawHeaders")
=ImportJSON("http://api.cryptocoincharts.info/tradingPair/ltc_btc", "", "noInherit,noTruncate,rawHeaders")

other api / addresses apply
https://www.cryptocoincharts.info/tools/api

then you can play around with it

Thanks, that might help me. I'll try