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?

Murch
  • 71,155
  • 33
  • 180
  • 600
Victor
  • 30
  • 6
  • 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

1 Answers1

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!

Victor
  • 30
  • 6