Pull Bitcoin and Cryptocurrencies Price and Data in Google Sheets

  • As simple as =CRYPTOFINANCE("BTC/USD")
  • 2,146 cryptocurrencies supported
  • Historical and global market data
  • 196 exchanges supported see list ›
  • Anonymous and open-source, no sign up required

92,565 traders and analysts already using it

Pull Live Market Data

The building blocks to create your own portfolio tracker.

  • Free Unlimited Data from Over 46 Exchanges
    CRYPTOFINANCE connects directly to over 46 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")

Trading Journal, Tax Reporting

Because nothing is as flexible as a spreadsheet.

  • Over 190 Exchanges’ Historical Data at Your Fingertips
    Use CRYPTOFINANCE to get historical prices on more than 190 exchanges, or as a VWAP. But also ROI per month, quarter or year.
  • Your Accountant Will Thank You
    Accountants know their way around a spreadsheet. Make their life easier by providing them your trading journal using CRYPTOFINANCE.
Hourly historical prices from over 190 exchanges
=CRYPTOFINANCE("COINBASE:BTC/USD", "price", "[email protected]:00")

Get end of day average prices...
=CRYPTOFINANCE("ETH/BTC", "price", "2018-11-24")
...or any OHLCV data
=CRYPTOFINANCE("BINANCE:BNB/BTC", "low", "2019-01-17")

Get HODL Return on Investment for a given quarter or month
=CRYPTOFINANCE("BTC/EUR", "roi", "2018Q4")
=CRYPTOFINANCE("BTC/EUR", "roi", "2018-04")

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





In a Nutshell


  1. A Google Sheets add-on providing the =CRYPTOFINANCE() function.
  2. Free for all supported exchanges latest data.
  3. Free for all Coinmetrics data.
  4. CoinMarketCap price data (free 50 calls/day, and a plan for unlimited calls).
  5. Historical price data from 196 exchanges (free for 25 calls/day, and a plan for unlimited calls).

Along with custom function calls to retrieve ROI (Return On Investment) per month, quarter or year. ATH (All-Time-High) prices, date, volume for all markets, and a simple way to display sparklines (mini-inlined charts) in your sheets.

Data Availability Service

CoinMarketCap and Exchanges Data

For $10/month you access CoinMarketCap data from their Pro API.

In addition, we’ve already done the hard work making the data spreadsheet-friendly. All data from ~2,500 markets is available via a single function call: =CRYPTOFINANCE("COINMARKETCAP")

You will also get an faster refresh interval for exchanges data. The free plan has a 1 hour refresh interval, the Data Availability Service offers a 2 to 3 minutes refresh interval.

See all benefits   


You’re in Good Company

OTC Desks · Crypto Funds · Traders · Analysts


CRYPTOFINANCE allows me to create sophisticated portfolio models, with the flexibility to precisely tailor my reporting.

The support provided is unmatched. I have never had a question unanswered and always left with a greater appreciation for the product.

Trey Brunson · User Operations Support

At Virgin we built our novel and unique trading methodology with CRYPTO­FINANCE. It proved to be a key tool in building our crypto strategy.

The strategy was shared with other investors outside of Virgin and ultimately contributed to the impro­vement of the cryptoassets management industry as a whole.

Alexandre Perrin · Former Investment Associate

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