I've been using the CRYPTOFINANCE() function in Google Sheets for a while but I can't seem to find out how to pull data from my exchange (Binance).

I'm specifically looking for the BTC/USD and ETH/USD markets. Using the syntax in the doc1 gives me #ERROR in my cells. My syntax is =CRYPTOFINANCE("BINANCE:BTC/USD")

Anybody had this problem before and managed to fix it?

  • Binance has a public API you can possibly query for these purposes. Also keep in mind Binance isnt a regulated exchange and therefore uses stable coins(most notably USDT) and not actual USD for its markets.
    – Leon
    Jan 11, 2019 at 14:01
  • I think this belongs to the Bitcoin Stack Jan 11, 2019 at 16:57

1 Answer 1


Following up on my question.

Leon had a point in his comment, Binance doesn't have USD pairs, only USDT.

I updated my cryptofinance calls to =CRYPTOFINANCE("BINANCE:BTC/USDT") and =CRYPTOFINANCE("BINANCE:ETH/USDT") and it worked like a charm!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.