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

Specific market data

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

All information are returned from the Binance ticker public API. All 9 ticker information can be retrieved: ask (sell, default), bid (buy), open, high, low, last,volume, change.

Examples:

  • =CRYPTOFINANCE("BINANCE:NEO/BTC") will return NEO price (ask, sell price) in Bitcoin. Same thing as calling =CRYPTOFINANCE("BINANCE:NEO/BTC", "ask")
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "bid") will return NEO bid price in Bitcoin.
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "open") will return NEO open price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "high") will return NEO highest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "low") will return NEO lowest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "last") will return NEO last price in Bitcoin.
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "volume") will return NEO volume in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "base_volume") will return NEO volume in Neo over the last 24 hours.
  • =CRYPTOFINANCE("BINANCE:NEO/BTC", "change") will return NEO change percentage over the last 24 hours.