Bitcoin and Cryptocurrencies Price Data for Google Sheets

Pull Cryptocurrency Prices and More in your Google Sheets

As simple as =CRYPTOFINANCE("BTC/USD")

2,146 cryptocurrencies supported

Historical and global market data

196 exchanges supported

Anonymous and open-source, no sign up required

Install CRYPTOFINANCE

92,496 traders and analysts already using it

Pull Live Market Data

The building blocks to create your own portfolio tracker.

Free Unlimited Data from Over 30 Exchanges
CRYPTOFINANCE connects directly to over 30 exchange APIs to return current market data. New exchanges are added continuously.

Default Data from CoinMarketCap API
CRYPTOFINANCE purchased a commercial license from CoinMarketCap and allows 50 calls/day for free. A plan for unlimited data is available too.

=CRYPTOFINANCE("BTC/USD") =CRYPTOFINANCE("BTC/USD", "marketcap") =CRYPTOFINANCE("BTC/EUR", "volume") =CRYPTOFINANCE("ETH/BTC", "change", "1h") =CRYPTOFINANCE("LTC/ZAR", "change", "24h") =CRYPTOFINANCE("KMD/ETH", "change", "7d") =CRYPTOFINANCE("BTC", "circulating_supply") =CRYPTOFINANCE("BTC", "max_supply") =CRYPTOFINANCE("BTC", "total_supply")

Macro and Exchange-Specific Data

Look up your local exchange prices and quickly discover arbitrage opportunities.

A Birds-Eye View of the Global Crypto Landscape
Follow Bitcoin dominance over time, total marketcap and volume movements, and the number of cryptocurrencies traded on exchanges.

Prefix an Exchange Name to Query its API
CRYPTOFINANCE uses an intuitive syntax to identify which exchanges you want data from. When no exchange is specified it will connect to CoinMarketCap.

=CRYPTOFINANCE("GLOBAL", "btc_dominance")
=CRYPTOFINANCE("GLOBAL", "total_marketcap")
=CRYPTOFINANCE("GLOBAL", "total_24h_volume")

=CRYPTOFINANCE("BINANCE:BNB/BTC", "bid")
=CRYPTOFINANCE("BINANCE:BTC/USDT", "change")

=CRYPTOFINANCE("KUCOIN:KCS/BTC", "volume")

=CRYPTOFINANCE("BITHUMB:BTC")
=CRYPTOFINANCE("BITHUMB:BTC", "high")

=CRYPTOFINANCE("BITFINEX:BTC/USD", "last")

+-----------------+ | Google Sheets | +--------^--------+ | | +-------v-------+ | CRYPTOFINANCE | | Data Proxy | +------^--------+ | +----------------+-------+----------+------------+ | | | | | +-------v-------+ +------v--+ +--v---+ +----v-----+ +····v····· | CoinMarketCap | | Binance | | IDEX | | Poloniex | | +---------------+ +---------+ +------+ +----------+ +··········

Unlimited CoinMarketCap Data and Optimized Exchanges Data

For $10/month you can access real-time CoinMarketCap data from their new Pro API — about 9 times cheaper than a direct subscription!. In addition, we’ve already done the hard work making the data spreadsheet-friendly. All data from +2,070 markets is available via a single function call: =CRYPTOFINANCE("COINMARKETCAP")

Some exchanges (including Poloniex, IDEX) do not offer an API response that can fit directly into a spreadsheet. Our Data Proxy will reformat their API responses for you and allow you to pull all their market data in real-time.
Some other exchanges (recently Binance and Bitfinex) ban requests coming from Google Sheets IPs. Our Data Proxy also the Proxy server offers a solution here too.