Note: Coinbase and Coinbase Pro are 2 different exchanges. Click here for Coinbase Pro

All Coinbase Markets in One Listing

This function call will return the list of all markets along with all their data point. It is recommended to use this to avoid the Google Sheets imposed API call quota.


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.

  • last, the price of the last trade.

  • change 24h, the price change in percentage over the last 24h.


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

Coinbase Market Data

Market Current Price

This will return Bitcoin price in U.S. Dollars as currently traded on Coinbase:


Same thing as calling =CRYPTOFINANCE("COINBASE:BTC/USD", "price").

Last Trade Price

This call will return Bitcoin last trade price in U.S. Dollars as it just happened on Coinbase:


24h Price Change

This call will return Bitcoin price change percentage in U.S. Dollars over the last 24h on Coinbase:


Coinbase Historical Data

Historical prices are available on daily and hourly candles, including open, high, low, close, volume and volume_base.

ProTip: See here for how to reference other cells to build the date or specifying the hour.

Historical Price

=CRYPTOFINANCE("COINBASE:BTC/USD", "price", "2017-12-25")

Same thing as calling close.

Historical Open Price

=CRYPTOFINANCE("COINBASE:BTC/USD", "open", "2017-12-25")

Historical High Price

=CRYPTOFINANCE("COINBASE:BTC/USD", "high", "2017-12-25")

Historical Low Price

=CRYPTOFINANCE("COINBASE:BTC/USD", "low", "2017-12-25")

Historical Close Price

=CRYPTOFINANCE("COINBASE:BTC/USD", "close", "2017-12-25")

Historical Market Volume

=CRYPTOFINANCE("COINBASE:BTC/USD", "volume", "2017-12-25")

Historical Market Base Volume

=CRYPTOFINANCE("COINBASE:BTC/USD", "volume_base", "2017-12-25")