Full listing

This function call will return the list of all markets along with all their data point. It is recommend to use this to avoid the Google Sheets imposed API call quota.

=CRYPTOFINANCE("KUCOIN")

Specific market data

In a nutshell, call =CRYPTOFINANCE("KUCOIN:KCS/BTC") to get the current KCS price in Bitcoin.

All information are returned from the Kucoin ticker public API, 6 ticker information can be retrieved: ask (sell, default), bid (buy), high, low, last and volume.

Examples:

  • =CRYPTOFINANCE("KUCOIN:KCS/BTC") will return KCS price (ask, sell price) in Bitcoin. Same thing as calling =CRYPTOFINANCE("KUCOIN:KCS/BTC", "ask")
  • =CRYPTOFINANCE("KUCOIN:KCS/BTC", "bid") will return KCS bid price in Bitcoin.
  • =CRYPTOFINANCE("KUCOIN:KCS/BTC", "high") will return KCS highest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("KUCOIN:KCS/BTC", "low") will return KCS lowest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("KUCOIN:KCS/BTC", "last") will return KCS last price in Bitcoin.
  • =CRYPTOFINANCE("KUCOIN:KCS/BTC", "volume") will return KCS volume over the last 24 hours.