All Coinbase Pro 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.
=CRYPTOFINANCE("COINBASE PRO")
The following market data will be returned:
last_updated
, when the data has been fetched from the exchange, timezone isUTC
time.market
, the market name following the syntaxBASE/QUOTE
.price
, the current price, either thelast
trade price when available or the currentask
price.ask
, the bestask
price currently in the order book.bid
, the bestbid
price currently in the other book.change 24h
, the price change in percentage over the last 24h.volume
, the volume traded over the last 24h in quote currency (USD
inBTC/USD
).base_volume
, the volume traded over the last 24h in base currency (BTC
inBTC/USD
).
Notes:
- When the exchange doesn’t provide a given market data, a hyphen (-) will be shown.
Coinbase Pro Market Data
Market Current Price
This will return Bitcoin price in U.S. Dollars as currently traded on Coinbase Pro:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD")
Same thing as calling =CRYPTOFINANCE("COINBASE PRO:BTC/USD", "price")
.
Best Ask Price
This will return Bitcoin best ask price in U.S. Dollars as currently available on Coinbase Pro order book:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD", "ask")
Best Bid Price
This will return Bitcoin best bid price in U.S. Dollars as currently available on Coinbase Pro order book:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD", "bid")
1h Price Change
This call will return Bitcoin price change percentage in U.S. Dollars over the last hour on Coinbase Pro:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD", "change_1h")
24h Price Change
This call will return Bitcoin price change percentage in U.S. Dollars over the last 24h on Coinbase Pro:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD", "change")
7d Price Change
This call will return Bitcoin price change percentage in U.S. Dollars over the last 7 days on Coinbase Pro:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD", "change_7d")
Market Volume
This call will return Bitcoin traded volume in U.S. Dollars over the last 24h on Coinbase Pro:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD", "volume")
Market Base Volume
This call will return Bitcoin traded volume in BTC
over the last 24h on Coinbase Pro:
=CRYPTOFINANCE("COINBASE PRO:BTC/USD", "base_volume")
Coinbase Pro Historical Data
Historical data is not available for Coinbase Pro at this time.