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

Specific market data

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

All information are returned from the Cryptopia Public API. All 14 tickers information can be retrieved: ask (default), bid, last, high, low, open, close, change, volume, buy_volume, sell_volume, base_volume, buy_base_volume, sell_base_volume.

Examples:

  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC") will return Dotcoin price (ask price) in Bitcoin, similar to calling =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "ask")
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "bid") will return Dotcoin bid price in Bitcoin.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "last") will return Dotcoin last price in Bitcoin.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "high") will return Dotcoin highest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "low") will return Dotcoin lowest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "open") will return Dotcoin open price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "close") will return Dotcoin close price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "change") will return the change percentage for the market DOT-BTC.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "volume") will return Dotcoin volume (in DOT) over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "buy_volume") will return Dotcoin buy volume (in DOT) over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "sell_volume") will return Dotcoin sell volume (in DOT) over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "base_volume") will return Dotcoin volume (in BTC) over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "buy_base_volume") will return Dotcoin buy volume (in BTC) over the last 24 hours.
  • =CRYPTOFINANCE("CRYPTOPIA:DOT/BTC", "sell_base_volume") will return Dotcoin sell volume (in BTC) over the last 24 hours.