Cryptocurrency spreadsheet | Bitcointalksearch.org

ArpFlush

hero member

Activity: 623

Merit: 501

Quote from: franky1 on February 02, 2017, 03:14:10 PM

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 Wink

franky1

legendary

Activity: 4424

Merit: 4794

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

hero member

Activity: 623

Merit: 501

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 Wink

Topic: Cryptocurrency spreadsheet (Read 1332 times)