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

Specific market data

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

All information are returned from the Bittrex public API. All 9 tickers information can be retrieved: ask (default), bid, last, high, low, volume, base_volume, open_buy_orders and open_sell_orders.

Examples:

  • =CRYPTOFINANCE("BITTREX:DASH/BTC") will return Dash price (ask price) in Bitcoin. Same thing as calling =CRYPTOFINANCE("BITTREX:DASH/BTC", "ask")
  • =CRYPTOFINANCE("BITTREX:ARK/BTC", "bid") will return Ark bid price in Bitcoin.
  • =CRYPTOFINANCE("BITTREX:XMR/BTC", "last") will return Monero last price in Bitcoin.
  • =CRYPTOFINANCE("BITTREX:XMR/BTC", "high") will return Monero highest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("BITTREX:XMR/BTC", "low") will return Monero lowest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("BITTREX:XMR/BTC", "volume") will return Monero volume (in XMR) over the last 24 hours.
  • =CRYPTOFINANCE("BITTREX:XMR/BTC", "base_volume") will return Monero volume (in BTC) over the last 24 hours.
  • =CRYPTOFINANCE("BITTREX:XMR/BTC", "open_sell_orders") will return the number of open sell orders for the market BTC-XMR.
  • =CRYPTOFINANCE("BITTREX:XMR/BTC", "open_buy_orders") will return the number of open buy orders for the market BTC-XMR. Note: Bittrex market names are a reverse of the pair name. The market labeled BTC-DASH on Bittrex website will use the DASH/BTC ticker in CRYPTOFINANCE.