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

When no data is available on the exchange, the cells will be blank.

Specific Market Data

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

All information are returned from the QTrade public API. All 10 tickers information can be retrieved: ask (default), bid, last, open, avg, high, low, change, volume, base_volume.

Examples:

  • =CRYPTOFINANCE("QTRADE:SNOW/BTC") will return the Snowblossom price (ask price) in Bitcoin. Same thing as calling =CRYPTOFINANCE("QTRADE:SNOW/BTC", "ask")
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "bid") will return Snowblossom bid price in Bitcoin.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "avg") will return Snowblossom average price over the last 24h in Bitcoin.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "last") will return Snowblossom last price in Bitcoin.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "high") will return Snowblossom highest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "low") will return Snowblossom lowest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "open") will return Snowblossom open price in Bitcoin for the current day.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "change") will return the price change percentage over the last 24 hours.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "volume") will return Snowblossom volume (in SNOW) over the last 24 hours.
  • =CRYPTOFINANCE("QTRADE:SNOW/BTC", "base_volume") will return Snowblossom volume (in BTC) over the last 24 hours.