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("HITBTC")

Specific market data

In a nutshell, call =CRYPTOFINANCE("HITBTC:BTC/USD") to get the current Bitcoin price in US Dollar.

All information are returned from the HitBTC ticker public API. All 7 ticker information can be retrieved: ask (default), bid, last, high, low, open, volume.

Examples:

  • =CRYPTOFINANCE("HITBTC:BTC/USD") will return Bitcoin price (ask, sell price) in US Dollar. It is the same thing as calling =CRYPTOFINANCE("HITBTC:BTC/USD", "ask").
  • =CRYPTOFINANCE("HITBTC:BTC/USD", "bid") will return Bitcoin bid price in US Dollar.
  • =CRYPTOFINANCE("HITBTC:BTC/USD", "last") will return Bitcoin last price in US Dollar.
  • =CRYPTOFINANCE("HITBTC:BTC/USD", "high") will return Bitcoin highest price in US Dollar over the last 24 hours.
  • =CRYPTOFINANCE("HITBTC:BTC/USD", "low") will return Bitcoin lowest price in US Dollar over the last 24 hours.
  • =CRYPTOFINANCE("HITBTC:BTC/USD", "open") will return Bitcoin open price in US Dollar over the last 24 hours.
  • =CRYPTOFINANCE("HITBTC:BTC/USD", "volume") will return Bitcoin volume over the last 24 hours.