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?

migrated from money.stackexchange.com Jan 12 at 4:52

This question came from our site for people who want to be financially literate.

  • 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 at 14:01
  • I think this belongs to the Bitcoin Stack – Lucas Raphael Pianegonda Jan 11 at 16:57

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, privacy policy and cookie policy

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