How to get rates and data from Coinbase Pro (ex-GDAX)

Note: Coinbase Pro data are available via the GDAX exchange name. This will change to COINBASEPRO in the future, but GDAX will be kept for backward compatibility. It is safe to use the GDAX exchange name.

Full listing

Coinbase Pro (ex-GDAX) 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("GDAX:BTC/USD") to get the current Bitcoin price in US Dollar.

All information are returned from the Coinbase Pro (ex-GDAX) ticker public API. 3 ticker information can be retrieved: ask (default), bid, and volume.

Examples:

• =CRYPTOFINANCE("GDAX:BTC/USD") will return Bitcoin price (ask, sell price) in US Dollar. It is the same thing as calling =CRYPTOFINANCE("GDAX:BTC/USD", "ask").
• =CRYPTOFINANCE("GDAX:BTC/USD", "bid") will return Bitcoin bid price in US Dollar.
• =CRYPTOFINANCE("GDAX:BTC/USD", "volume") will return Bitcoin volume over the last 24 hours.