How to get BTC and ETH prices from Binance in Google Sheets?

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?

Victor

Posted 2019-01-11T13:19:09.940

Reputation: 20

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 – 2019-01-11T14:01:59.130

I think this belongs to the Bitcoin Stack – Lucas Raphael Pianegonda – 2019-01-11T16:57:45.737

Answers

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

Posted 2019-01-11T13:19:09.940

Reputation: 20

Asked: 2019-01-11T13:19:09.940

Viewed: 655 times

Active: 2019-05-14T13:10:39.040