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


Install CRYPTOFINANCE 
92,565 traders and analysts already using it

92,565

USERS

12,096,317

LAST 24H API CALLS

2,146

CRYPTOCURRENCIES

196

EXCHANGES

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

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


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

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

In a Nutshell

CRYPTOFINANCE is:

  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

Unlimited CoinMarketCap Data and Real-Time Exchanges Data

For $10/month you access real-time CoinMarketCap data from their new Pro API — over 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,146 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 sub-1-minute refresh interval.

See all benefits   

OUR CUSTOMERS

You’re in Good Company

OTC Desks · Crypto Funds · Traders · Analysts


blockchain

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
Virgin

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:
Install CRYPTOFINANCE