Examples
Bitcoin price: https://cryptoprices.cc/BTC/
Ethereum price: https://cryptoprices.cc/ETH/
Binance Coin price: https://cryptoprices.cc/BNB/
Dogecoin price: https://cryptoprices.cc/DOGE/
XRP price: https://cryptoprices.cc/XRP/
How to get Bitcoin price from Google Sheets
=IMPORTDATA("https://cryptoprices.cc/BTC/")
How to get Ethereum price from Microsoft Excel
=WEBSERVICE("https://cryptoprices.cc/ETH/")
How to get Bitcoin ATH price
https://cryptoprices.cc/BTC/ATH/
(Append /ATH/ to any URL)
How to get Shiba Inu Market Cap price
https://cryptoprices.cc/SHIB/MCAP/
(Append /MCAP/ to any URL)
How to get Bitcoin price in EUR/GBP/INR in Google Sheets
=IMPORTDATA("https://cryptoprices.cc/BTC/")*GOOGLEFINANCE("CURRENCY:USDGBP")
Demo / PoC Spreadsheet
You can see an example spreadsheet on my Medium blog post.
List of all tokens/pairs available.
Why use this service:
Simple API, easy to use.
No Parsing: all endpoints return only text (price of coin)
No limits: there's no usage limits
No sign ups: anonymous, no setup, no maintenance.
Why NOT use this service:
Data can be 1h late.
We only provide current price / ATH / Market Cap, other data is missing.
We're only tracking the top 5000 coins by mcap.
FAQ / Common Issues:
Price is wrong: the debug page may give you some hints as to what's wrong, i.e. https://cryptoprices.cc/M87/debug/.
Can you add X token? Unlikely, for now we're only serving top X thousand coins.
Price is interpreted as a string: try using NUMBERVALUE() in Excel or VALUE() in Google Sheets.
If this service doesn't satisfy your requirments, please use CoinGecko API directly.