Pull Bitcoin and Cryptocurrencies
Data in Google Sheets

  • As simple as =CRYPTOFINANCE("BTC/USD")
  • +988 cryptocurrencies supported
  • 29 exchanges supported
  • Historical and derivative data

Pull Live Market Data



=CRYPTOFINANCE("BTC/USD", "marketcap")

=CRYPTOFINANCE("LTC/ZAR", "change", "24h")
=CRYPTOFINANCE("KMD/ETH", "change", "1w")
=CRYPTOFINANCE("LTC/ZAR", "change", "6m")

Historical Market Data

Daily historical prices from over 190 exchanges
=CRYPTOFINANCE("COINBASE:BTC/USD", "price", "2018-11-24")

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

Exchange-Specific Data

Just prefix an exchange name to query its API