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

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", "marketcap")


=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")




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

Data Availability Service

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.

See all benefits  

Ready to organize and analyze your cryptoassets? Get started now for free: