Full listing

BTCMarkets full listing is not available at this moment. Their API output needs too much rewriting to fit a sheet format.

Specific market data

In a nutshell, call =CRYPTOFINANCE("BTCMARKETS:BTC/AUD") to get the current Bitcoin price in Australian Dollar.

All information are returned from the BTCMarkets public API. All 4 ticker information can be retrieved: ask (default), bid, last, volume.

Examples:

  • =CRYPTOFINANCE("BTCMARKETS:BTC/AUD") will return Bitcoin price (ask) in Australian Dollar, same as calling =CRYPTOFINANCE("BTCMARKETS:BTC/AUD", "ask")
  • =CRYPTOFINANCE("BTCMARKETS:BTC/AUD", "bid") will return Bitcoin bid price in Australian Dollar.
  • =CRYPTOFINANCE("BTCMARKETS:BTC/AUD", "last") will return Bitcoin last price in Australian Dollar.
  • =CRYPTOFINANCE("BTCMARKETS:BTC/AUD", "volume") will return Bitcoin volume over the last 24 hours.