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

=CRYPTOFINANCE("BTC/EUR", "volume")

=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
=CRYPTOFINANCE("BINANCE:BNB/BTC", "bid")
=CRYPTOFINANCE("BINANCE:BTC/USDT", "change")

=CRYPTOFINANCE("KRAKEN:BTC/EUR", "volume")

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

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