<p>Following up on my question.</p>

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

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

CC BY-SA 4.0
2019-01-17T06:02:14.133Z
2019-01-17T06:02:14.133Z
Victor
<p>I've been using the <code>CRYPTOFINANCE()</code> function in Google Sheets for a while but I can't seem to find out how to pull data from my exchange (Binance).</p>

<p>I'm specifically looking for the BTC/USD and ETH/USD markets. Using the syntax in the doc<a href="https://cryptofinance.ai/docs/how-to-get-data-from-binance/" rel="nofollow noreferrer">1</a> gives me #ERROR in my cells.
My syntax is <code>=CRYPTOFINANCE("BINANCE:BTC/USD")</code></p>

<p>Anybody had this problem before and managed to fix it?</p>

CC BY-SA 4.0
2019-01-11T14:01:59.130Z
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
CC BY-SA 4.0
2019-01-11T16:57:45.737Z
I think this belongs to the Bitcoin Stack
Lucas Raphael Pianegonda
<api><binance><cryptofinance>
How to get BTC and ETH prices from Binance in Google Sheets?
Victor
# How to get BTC and ETH prices from Binance in Google Sheets?

(Asked by: username_0 on 2019-01-11)

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 doc[1](https://cryptofinance.ai/docs/how-to-get-data-from-binance/) gives me #ERROR in my cells.
My syntax is `=CRYPTOFINANCE("BINANCE:BTC/USD")`

Anybody had this problem before and managed to fix it?

**Tags:** api, binance, cryptofinance

> **Comments:**
> **username_1**: 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.  
> **username_2**: I think this belongs to the Bitcoin Stack  

---

## 1 answers

### Answer by username_0 on 2019-01-17. Score: 0 | Accepted answer

Following up on my question.

username_1 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!


---

