API Connector Documentation
Free Crypto APIs for Google Sheets
There are a huge number of crypto APIs, and virtually all of them offer public crypto 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.
This list refers to publicly available data. Private data, e.g. your own transaction history, always requires authentication.
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 but simple dataset focused on currencies, prices, and exchange rates | Open | https://api.coinbase.com/v2/exchange-rates?currency=BTC |
3 | CoinCap | Real time cryptocurrency prices | Open | https://api.coincap.io/v2/assets |
4 | CoinDesk | Bitcoin price index | Open | https://api.coindesk.com/v1/bpi/currentprice.json |
5 | CoinGecko | Comprehensive, well-organized cryptocurrency market data. (Use their free API or get 20% off any API plan with the offer code 'MIXEDANALYTICS20'. Apply code at checkout after signing up on www.coingecko.com/api/pricing) | Open/API Key | https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd |
6 | CoinLore | Cryptocurrency market data, including free exchange data not provided by most other APIs | Open | https://api.coinlore.net/api/tickers/ |
7 | CoinMap | Crypto ATMs | Open | https://coinmap.org/api/v1/venues/ |
8 | CoinMarketCap | Comprehensive crypto API providing price/market data, exchange data, and token metadata | API Key | |
9 | CoinPaprika | Frequently updated market data: coin prices, volumes, market caps, ATHs, return rates and more | Open | https://api.coinpaprika.com/v1/tickers |
10 | CoinStats | Cryptocurrency market data | Open | https://api.coinstats.app/public/v1/markets?coinId=bitcoin |
11 | CryptoCompare | Very good API with interesting data points like trading signals and social data alongside standard market data | API Key | |
12 | DEX Screener | Blockchain screener | Open | https://api.dexscreener.com/latest/dex/search?q=WBNB%20USDC |
13 | Exchangerate | Currency exchange & crypto rates | Open | https://api.exchangerate.host/latest |
14 | Gemini | Cryptocurrency market data | Open | https://api.gemini.com/v2/ticker/btcusd |
15 | Kraken | OHLC data, order books, recent trades | Open | https://api.kraken.com/0/public/Trades?pair=ltcusd |
16 | KuCoin | Ticker, order book, historical data | Open | https://api.kucoin.com/api/v1/market/stats?symbol=BTC-USDT |
17 | Nexchange | Cryptocurrency market data | Open | https://api.n.exchange/en/api/v1/price/btcusd/history/?hours=0.1&data_points=3&market_code=nex |
18 | OKX | Cryptocurrency market data | Open | https://www.okx.com/api/v5/market/tickers?instType=SPOT |
19 | OpenSea | NFTs | API Key | |
20 | 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?
Binance is still supported if you use a different base domain, e.g.
https://data.binance.com/api/v3/ticker/24hr
curl -X 'GET' \
'https://api.geckoterminal.com/api/v2/networks?page=1' \
-H 'accept: application/json'
It seems Binance has now removed suport for the "data" subdomain, so I've now removed them from this list.
Binance works fine. A quick google reveals:
curl -sX GET "https://data-api.binance.vision/api/v3/exchangeInfo?symbol=BTCUSDT"
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 transactionsis there some free apis for RSI, MACD, Moving Averages or Logarhythmic Regressions?
Sorry, I'm not really familiar with those but here's a discussion that mentions a few options: https://www.reddit.com/r/algotrading/comments/q44ryc/apis_to_pull_data_for_rsi_macd_and_implied/.
Hi, is there a way to switch out the request from the one with coingecko, so I can get an array of values? Tried the coinbase one but its only 1 coin at a time
Coinbase is one of the simplest APIs, pretty much any other crypto API will let you fetch data for more than one coin at a time. I like CoinMarketCap, or CoinPaprika is great too if you don’t want to get a key.
Do you think NewsData.io provide Crypto News API??
Looks like they do: https://newsdata.io/documentation/#crypto-news. However, access is not free.
You should consider this in your list.
Hi Ana
My name is Wanit, a MSc student at Anglia Ruskin University. I need a csv or json of all coins and their daily or weekly historical data strictly for research.
Where/how do you think I can get this?
I can't say for sure it doesn't exist, but I've never seen anything like that. From what I've seen, APIs only provide historical data for one coin or one date at a time, it would be a huge data set (too big for Sheets anyway) if it contained both daily/weekly historical data and all ~20K coins at once. For example, you could use CoinMarketCap's (paid) /ListingsHistorical endpoint and make the following API call:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/historical?date=2013-12-31&limit=5000&aux=date_added
to return the price of 5000 coins on 2013-12-31. Or you could get historical data for one coin at a time (as a csv download) from https://coinmetrics.io/community-network-data/.You could just run a full node for a bit as all the history of the block chain is, well, by design, on the blockchain. Look at Google Cloud Platform. They have a ready build Binance server VM you can spin up.
Hi Ana,
I've been searching for a way to get crypto price at a specific time of sale for each of my buy and sell transactions. I have a sheet that contains all transactions including the date/time of the transaction, the token symbol, and the amount of transaction and I would like to add a new column that indicates the price of the crypto token at that date/time. Would you please advise to a good API for this purpose and advise how to set it up in API Connector? Ideally it would be a function that reads the time (e.g. UTC), token (e.g BTC), and currency (e.g. USD) columns in the same row of the spreadsheet. My preference is to use data that is accurate down to the minute instead of a daily average if possible. It is ok if I have to pay a reasonable fee for an API key to get this information. Thank you!
This is the closest I found for what you're looking for: https://docs.coingecko.com/reference/coins-id-market-chart-range. They accept parameters for date, currency, and coin ID. However, it will be a daily average for dates more than 90 days in the past. I'm not sure where you'd get more granular data for dates further out (though I'm sure it's out there somewhere).
Edit: Looks like you asked about CoinAPI, and that does indeed have historical data by the minute.