0

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

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!

|improve this answer|||||

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.