Excel

Google Sheets

> Binance.US is a secure platform for users to buy, sell, and store cryptocurrencies. Fast Binance.US offers unwavering performance with a trusted world-class matching engine, supporting up to 1,400,000 orders per second.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Binance%20US">Binance US</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Test%20connectivity" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/test-connectivity) | **Test connectivity** | <inline-code functionvalue='=CS.QUERY("Binance US","Test connectivity")'>=CS.QUERY("Binance US","Test connectivity")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Test connectivity")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Check%20server%20time" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/check-server-time) | **Check server time** | <inline-code functionvalue='=CS.QUERY("Binance US","Check server time")'>=CS.QUERY("Binance US","Check server time")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Check server time")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Exchange%20information" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/exchange-information) | **Exchange information** | <inline-code functionvalue='=CS.QUERY("Binance US","Exchange information")'>=CS.QUERY("Binance US","Exchange information")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Exchange information")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Order%20book" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/order-book) | **Order book** | <inline-code functionvalue='=CS.QUERY("Binance US","Order book",{"symbol","ETHBTC";"limit","100"})'>=CS.QUERY("Binance US","Order book")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Order book")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Recent%20trades%20list" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/recent-trades-list) | **Recent trades list** | <inline-code functionvalue='=CS.QUERY("Binance US","Recent trades list",{"symbol","ETHBTC";"limit","500"})'>=CS.QUERY("Binance US","Recent trades list")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Recent trades list")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Old%20trade%20lookup" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/old-trade-lookup) | **Old trade lookup** | <inline-code functionvalue='=CS.QUERY("Binance US","Old trade lookup",{"X-MBX-APIKEY","Your X-MBX-APIKEY";"symbol","ETHBTC";"limit","500";"fromId","28457"})'>=CS.QUERY("Binance US","Old trade lookup")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Old trade lookup")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Compressed%2FAggregate%20trades%20list" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/compressed/aggregate-trades-list) | **Compressed/Aggregate trades list** | <inline-code functionvalue='=CS.QUERY("Binance US","Compressed/Aggregate trades list",{"symbol","ETHBTC";"fromId","28457";"startTime","1546300800";"endTime","1546387200";"limit","500"})'>=CS.QUERY("Binance US","Compressed/Aggregate trades list")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Compressed/Aggregate trades list")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Kline%2FCandlestick%20data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/kline/candlestick-data) | **Kline/Candlestick data** | <inline-code functionvalue='=CS.QUERY("Binance US","Kline/Candlestick data",{"symbol","ETHBTC";"interval","1d";"startTime","1546300800";"endTime","1546387200";"limit","500"})'>=CS.QUERY("Binance US","Kline/Candlestick data")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Kline/Candlestick data")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Current%20average%20price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/current-average-price) | **Current average price** | <inline-code functionvalue='=CS.QUERY("Binance US","Current average price",{"symbol","ETHBTC"})'>=CS.QUERY("Binance US","Current average price")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Current average price")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/24hr%20ticker%20price%20change%20statistics" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/24hr-ticker-price-change-statistics) | **24hr ticker price change statistics** | <inline-code functionvalue='=CS.QUERY("Binance US","24hr ticker price change statistics",{"symbol","ETHBTC"})'>=CS.QUERY("Binance US","24hr ticker price change statistics")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","24hr ticker price change statistics")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Symbol%20price%20ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/symbol-price-ticker) | **Symbol price ticker** | <inline-code functionvalue='=CS.QUERY("Binance US","Symbol price ticker",{"symbol","ETHBTC"})'>=CS.QUERY("Binance US","Symbol price ticker")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Symbol price ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Symbol%20order%20book%20ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/symbol-order-book-ticker) | **Symbol order book ticker** | <inline-code functionvalue='=CS.QUERY("Binance US","Symbol order book ticker",{"symbol","ETHBTC"})'>=CS.QUERY("Binance US","Symbol order book ticker")</inline-code> | <inline-code>=CS.PARAMETERS("Binance US","Symbol order book ticker")</inline-code> | 1 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Test%20connectivity" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/test-connectivity) | **Test connectivity** | <inline-code functionvalue='=CSQUERY("Binance US","Test connectivity")'>=CSQUERY("Binance US","Test connectivity")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Test connectivity")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Check%20server%20time" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/check-server-time) | **Check server time** | <inline-code functionvalue='=CSQUERY("Binance US","Check server time")'>=CSQUERY("Binance US","Check server time")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Check server time")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Exchange%20information" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/exchange-information) | **Exchange information** | <inline-code functionvalue='=CSQUERY("Binance US","Exchange information")'>=CSQUERY("Binance US","Exchange information")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Exchange information")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Order%20book" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/order-book) | **Order book** | <inline-code functionvalue='=CSQUERY("Binance US","Order book",{"symbol","ETHBTC";"limit","100"})'>=CSQUERY("Binance US","Order book")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Order book")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Recent%20trades%20list" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/recent-trades-list) | **Recent trades list** | <inline-code functionvalue='=CSQUERY("Binance US","Recent trades list",{"symbol","ETHBTC";"limit","500"})'>=CSQUERY("Binance US","Recent trades list")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Recent trades list")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Old%20trade%20lookup" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/old-trade-lookup) | **Old trade lookup** | <inline-code functionvalue='=CSQUERY("Binance US","Old trade lookup",{"X-MBX-APIKEY","Your X-MBX-APIKEY";"symbol","ETHBTC";"limit","500";"fromId","28457"})'>=CSQUERY("Binance US","Old trade lookup")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Old trade lookup")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Compressed%2FAggregate%20trades%20list" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/compressed/aggregate-trades-list) | **Compressed/Aggregate trades list** | <inline-code functionvalue='=CSQUERY("Binance US","Compressed/Aggregate trades list",{"symbol","ETHBTC";"fromId","28457";"startTime","1546300800";"endTime","1546387200";"limit","500"})'>=CSQUERY("Binance US","Compressed/Aggregate trades list")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Compressed/Aggregate trades list")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Kline%2FCandlestick%20data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/kline/candlestick-data) | **Kline/Candlestick data** | <inline-code functionvalue='=CSQUERY("Binance US","Kline/Candlestick data",{"symbol","ETHBTC";"interval","1d";"startTime","1546300800";"endTime","1546387200";"limit","500"})'>=CSQUERY("Binance US","Kline/Candlestick data")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Kline/Candlestick data")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Current%20average%20price" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/current-average-price) | **Current average price** | <inline-code functionvalue='=CSQUERY("Binance US","Current average price",{"symbol","ETHBTC"})'>=CSQUERY("Binance US","Current average price")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Current average price")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/24hr%20ticker%20price%20change%20statistics" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/24hr-ticker-price-change-statistics) | **24hr ticker price change statistics** | <inline-code functionvalue='=CSQUERY("Binance US","24hr ticker price change statistics",{"symbol","ETHBTC"})'>=CSQUERY("Binance US","24hr ticker price change statistics")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","24hr ticker price change statistics")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Symbol%20price%20ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/symbol-price-ticker) | **Symbol price ticker** | <inline-code functionvalue='=CSQUERY("Binance US","Symbol price ticker",{"symbol","ETHBTC"})'>=CSQUERY("Binance US","Symbol price ticker")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Symbol price ticker")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Binance%20US/Symbol%20order%20book%20ticker" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/binance-us/symbol-order-book-ticker) | **Symbol order book ticker** | <inline-code functionvalue='=CSQUERY("Binance US","Symbol order book ticker",{"symbol","ETHBTC"})'>=CSQUERY("Binance US","Symbol order book ticker")</inline-code> | <inline-code>=CSPARAMETERS("Binance US","Symbol order book ticker")</inline-code> | 1 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-Binance US">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-Binance US">Get Cryptosheets for Googlesheets</a>**

\*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work

**<a href="https://github.com/binance-us/binance-official-api-docs/blob/master/rest-api.md">Click here</a>** for additional documentation from Binance US

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `Binance US` `provider` 


How to pull Binance US data into Excel and Google Sheets