Note GDAX has been renamed to Coinbase Pro. Any syntax using GDAX will be transparently mapped to COINBASE_PRO.

All Coinbase Pro Markets Listing

This function call will return the list of all markets along with all their data point. It is recommend to use this if you need data for all markets.

=CRYPTOFINANCE("COINBASE_PRO")

The following market data will be returned:

  • last_updated, when the data has been fetched from the exchange, timezone is UTC time.
  • market, the market name following the syntax BASE/QUOTE.
  • price, the current price, either the last trade price when available or the current ask price.
  • ask, the best ask price currently in the order book.
  • bid, the best bid price currently in the other book.
  • base_volume, the volume traded over the last 24h in BASE currency (so that’s BTC for BTC/USD).

When the exchange doesn’t provide data, a hyphen (-) will be shown.

Specific Coinbase Pro Market Data

Current Price

This will return Bitcoin price in Euro as currently traded on the exchange.

=CRYPTOFINANCE("COINBASE_PRO:BTC/EUR")

Same thing as calling =CRYPTOFINANCE("COINBASE_PRO:BTC/EUR", "price").

Best Ask Price

This call will return Bitcoin best ask in Euro currently in the order book.

=CRYPTOFINANCE("COINBASE_PRO:BTC/EUR", "ask")

Best Bid Price

This call will return Bitcoin best bid in Euro currently in the order book.

=CRYPTOFINANCE("COINBASE_PRO:BTC/EUR", "bid")

Market Base Volume

This call will return Bitcoin trading volume in Bitcoin over the last 24 hours.

=CRYPTOFINANCE("COINBASE_PRO:BTC/EUR", "base_volume")