Sample Binance API Tickers - 2. One call, Simple, Fast and Reliable VLOOKUP
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGH
1
Binance price tickers with Sheets Lookup
2
09/07/2018 14:06:00
3
formula
4
market symbols
bidasklasthighlow
5
BTCUSDT6379.746384.766384.7663206544
6
ETCUSDT11.640511.648211.648111.257712.2512
7
LTCUSDT55.7455.8455.7954.6358.53
8
BNBUSDT9.89429.919.89419.6310.382
9
ETHBTC0.0343250.0343370.0343220.0338530.035899
10
XRPBTC0.000045470.000045540.000045540.000044030.00004718
11
12
13
Let's all treat these lovely APIs with respect and don't hammer them to hard to avoid bans.
14
This Apps Script fetches the tickers from Binance with ONE SINGLE request and writes the output to the Binance24h sheet.
15
The sheet holds some simple vlookup formulas in Column C to retrieve the data from the Binance24h sheet
16
Simple, Effective, Reliable and Fast
17
18
formula
19
market symbols
only bid price
Getting started:
20
BTCUSDT6379.74
Press this link to Copy this sheet to your personal Google Drive
21
ETCUSDT11.6405
Press the image in A1 and authorize the script
22
LTCUSDT55.74
Press the image in A1 to update tickers
23
BNBUSDT9.8942
24
ETHBTC0.034325Enjoy,
25
XRPBTC0.00004547Moosy
26
27
28
29
Loading...
Main menu