Search API Connector Documentation
Access Free Crypto APIs in Google Sheets
There are a huge number of crypto APIs, and virtually all of them offer market data for free through their public endpoints.
This article lists the top crypto APIs accessed by users of the API Connector extension for Sheets, along with the type of authentication they require. For Open APIs (those with no authorization requirements) a sample URL is provided so you can click the URL and see the results in your browser.
Two very popular crypto APIs are NOT listed below: Binance and CoinGecko. The reason is that both APIs rate limit users of Google Sheets, resulting in a lot of errors. The APIs listed below are a lot more reliable and largely provide the same market data.
List of Crypto Market Data APIs
# | API Name | Description | Auth requirements | Sample URL |
1 | CoinAPI | Excellent and well-organized source of crypto market data | API Key | |
2 | CoinBase | Small dataset providing currencies, prices, and exchange rates | Open | https://api.coinbase.com/v2/exchange-rates?currency=BTC |
3 | CoinMarketCap | Comprehensive crypto API providing price/market data, exchange data, and token metadata | API Key | |
4 | CoinPaprika | Frequently updated market data: coin prices, volumes, market caps, ATHs, return rates and more | Open | https://api.coinpaprika.com/v1/tickers |
5 | CryptingUp | Small but reliable crypto data API offering free access to key cryptocurrency prices, markets and exchanges | Open | https://www.cryptingup.com/api/markets |
6 | CryptoCompare | Very good and comprehensive market data API with extra data points like trading signals and social data | API Key | |
7 | Kraken | OHLC data, order books, recent trades | Open | https://api.kraken.com/0/public/Trades?pair=ltcusd |
8 | KuCoin | Ticker, order book, historical data | Open | https://api.kucoin.com/api/v1/market/stats?symbol=BTC-USDT |
9 | WazirX | India-focused crypto API with tickers, order books, and trade lookups | Open | https://api.wazirx.com/sapi/v1/tickers/24hr |
Block.cc is a professional cryptocurrency information service platform that provides cryptocurrency quotes, data, and information.
Available data for the currency market is the latest price, best bid / ask price,24h high/low, volume 24h, price change, currency price, order book, exchange announcement, News, articles, transaction count, address count, the exchange rate of more than 100 fiat currencies.
Auth type is API key
You may wish to add that Binance is no longer supported?
OK, I removed it, but Binance is still supported if you use a different base domain, e.g.
https://data.binance.com/api/v3/ticker/24hr
Hi !, Where can I looking for the meaning of each item ['symbol', 'priceChange', 'priceChangePercent', 'weightedAvgPrice', 'prevClosePrice', 'lastPrice', 'lastQty', 'bidPrice', 'bidQty', 'askPrice', 'askQty', 'openPrice', 'highPrice', 'lowPrice', 'volume', 'quoteVolume', 'openTime', 'closeTime', 'firstId', 'lastId', 'count']
Thanks
That sounds like the list of metrics sent back by Binance's ticker endpoint, is that right? If so, I don't think they really define them in their documentation but they're pretty standard metrics so you can Google them for more info. Or, here's a quick list of definitions if it helps:
symbol
: the trading pair, e.g. "BTCUSDT"priceChange
: 24-hour price changepriceChangePercent
: 24-hour price change percentageweightedAvgPrice
: weighted average pricelastPrice
: last transaction pricelastQty
: The last transaction amountopenPrice
: The price of the first transaction within 24 hourshighPrice
:24-hour highest pricelowPrice
: 24-hour lowest pricevolume
: 24-hour trading volumequoteVolume
: 24-hour turnoveropenTime
: The time when the first transaction occurred within 24 hourscloseTime
:The time when the last transaction occurred within 24 hoursfirstId
:first transaction idlastId
:last transaction idcount
:number of transactions