> Exchange for Trading Cryptocurrencies based in China Find examples for accessing every **Binance** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/binance/current-average-price) | **Current Average Price** | =CS.QUERY("Binance","Current Average Price") | =CS.PARAMETERS("Binance","Current Average Price") | 1 | | Try It | [Docs](/providers/binance/symbol-price-ticker) | **Symbol Price Ticker** | =CS.QUERY("Binance","Symbol Price Ticker") | =CS.PARAMETERS("Binance","Symbol Price Ticker") | 1 | | Try It | [Docs](/providers/binance/symbol-order-book-ticker) | **Symbol Order Book Ticker** | =CS.QUERY("Binance","Symbol Order Book Ticker") | =CS.PARAMETERS("Binance","Symbol Order Book Ticker") | 1 | | Try It | [Docs](/providers/binance/staking-list) | **Staking List** | =CS.QUERY("Binance","Staking List") | =CS.PARAMETERS("Binance","Staking List") | 2 | | Try It | [Docs](/providers/binance/staking-detail) | **Staking Detail** | =CS.QUERY("Binance","Staking Detail") | =CS.PARAMETERS("Binance","Staking Detail") | 1 | | Try It | [Docs](/providers/binance/exchange-information---spot) | **Exchange Information - SPOT** | =CS.QUERY("Binance","Exchange Information - SPOT") | =CS.PARAMETERS("Binance","Exchange Information - SPOT") | 0 | | Try It | [Docs](/providers/binance/order-book-(spot)) | **Order Book (SPOT)** | =CS.QUERY("Binance","Order Book (SPOT)") | =CS.PARAMETERS("Binance","Order Book (SPOT)") | 2 | | Try It | [Docs](/providers/binance/recent-trades-list-(spot)) | **Recent Trades List (SPOT)** | =CS.QUERY("Binance","Recent Trades List (SPOT)") | =CS.PARAMETERS("Binance","Recent Trades List (SPOT)") | 2 | | Try It | [Docs](/providers/binance/old-trade-lookup-(spot)) | **Old Trade Lookup (SPOT)** | =CS.QUERY("Binance","Old Trade Lookup (SPOT)") | =CS.PARAMETERS("Binance","Old Trade Lookup (SPOT)") | 4 | | Try It | [Docs](/providers/binance/compressed-aggregate-trades-list-(spot)) | **Compressed Aggregate Trades List (SPOT)** | =CS.QUERY("Binance","Compressed Aggregate Trades List (SPOT)") | =CS.PARAMETERS("Binance","Compressed Aggregate Trades List (SPOT)") | 5 | | Try It | [Docs](/providers/binance/kline-candlestick-data-(spot)) | **Kline-Candlestick Data (SPOT)** | =CS.QUERY("Binance","Kline-Candlestick Data (SPOT)") | =CS.PARAMETERS("Binance","Kline-Candlestick Data (SPOT)") | 5 | | Try It | [Docs](/providers/binance/current-average-price-(spot)) | **Current Average Price (SPOT)** | =CS.QUERY("Binance","Current Average Price (SPOT)") | =CS.PARAMETERS("Binance","Current Average Price (SPOT)") | 1 | | Try It | [Docs](/providers/binance/24hr-ticker-price-change-statistics-(spot)) | **24Hr Ticker Price Change Statistics (SPOT)** | =CS.QUERY("Binance","24Hr Ticker Price Change Statistics (SPOT)") | =CS.PARAMETERS("Binance","24Hr Ticker Price Change Statistics (SPOT)") | 1 | | Try It | [Docs](/providers/binance/symbol-price-ticker-(spot)) | **Symbol Price Ticker (SPOT)** | =CS.QUERY("Binance","Symbol Price Ticker (SPOT)") | =CS.PARAMETERS("Binance","Symbol Price Ticker (SPOT)") | 1 | | Try It | [Docs](/providers/binance/symbol-order-book-ticker-(spot)) | **Symbol Order Book Ticker (SPOT)** | =CS.QUERY("Binance","Symbol Order Book Ticker (SPOT)") | =CS.PARAMETERS("Binance","Symbol Order Book Ticker (SPOT)") | 1 | | Try It | [Docs](/providers/binance/exchange-information-(futures)) | **Exchange Information (Futures)** | =CS.QUERY("Binance","Exchange Information (Futures)") | =CS.PARAMETERS("Binance","Exchange Information (Futures)") | 0 | | Try It | [Docs](/providers/binance/order-book--(futures)) | **Order Book (Futures)** | =CS.QUERY("Binance","Order Book (Futures)") | =CS.PARAMETERS("Binance","Order Book (Futures)") | 2 | | Try It | [Docs](/providers/binance/recent-trades-list--(futures)) | **Recent Trades List (Futures)** | =CS.QUERY("Binance","Recent Trades List (Futures)") | =CS.PARAMETERS("Binance","Recent Trades List (Futures)") | 2 | | Try It | [Docs](/providers/binance/old-trade-lookup--(futures)) | **Old Trade Lookup (Futures)** | =CS.QUERY("Binance","Old Trade Lookup (Futures)") | =CS.PARAMETERS("Binance","Old Trade Lookup (Futures)") | 4 | | Try It | [Docs](/providers/binance/compressed-aggregate-trades-list--(futures)) | **Compressed Aggregate Trades List (Futures)** | =CS.QUERY("Binance","Compressed Aggregate Trades List (Futures)") | =CS.PARAMETERS("Binance","Compressed Aggregate Trades List (Futures)") | 5 | | Try It | [Docs](/providers/binance/kline-candlestick-data--(futures)) | **Kline-Candlestick Data (Futures)** | =CS.QUERY("Binance","Kline-Candlestick Data (Futures)") | =CS.PARAMETERS("Binance","Kline-Candlestick Data (Futures)") | 5 | | Try It | [Docs](/providers/binance/mark-price-(futures)) | **Mark Price (Futures)** | =CS.QUERY("Binance","Mark Price (Futures)") | =CS.PARAMETERS("Binance","Mark Price (Futures)") | 1 | | Try It | [Docs](/providers/binance/get-funding-rate-history-(futures)) | **Get Funding Rate History (Futures)** | =CS.QUERY("Binance","Get Funding Rate History (Futures)") | =CS.PARAMETERS("Binance","Get Funding Rate History (Futures)") | 5 | | Try It | [Docs](/providers/binance/24hr-ticker-price-change-statistics-(futures)) | **24hr Ticker Price Change Statistics (Futures)** | =CS.QUERY("Binance","24hr Ticker Price Change Statistics (Futures)") | =CS.PARAMETERS("Binance","24hr Ticker Price Change Statistics (Futures)") | 1 | | Try It | [Docs](/providers/binance/symbol-price-ticker-(futures)) | **Symbol Price Ticker (Futures)** | =CS.QUERY("Binance","Symbol Price Ticker (Futures)") | =CS.PARAMETERS("Binance","Symbol Price Ticker (Futures)") | 1 | | Try It | [Docs](/providers/binance/symbol-order-book-ticker-(futures)) | **Symbol Order Book Ticker (Futures)** | =CS.QUERY("Binance","Symbol Order Book Ticker (Futures)") | =CS.PARAMETERS("Binance","Symbol Order Book Ticker (Futures)") | 1 | | Try It | [Docs](/providers/binance/get-all-liquidation-orders-(futures)) | **Get All Liquidation Orders (Futures)** | =CS.QUERY("Binance","Get All Liquidation Orders (Futures)") | =CS.PARAMETERS("Binance","Get All Liquidation Orders (Futures)") | 4 | | Try It | [Docs](/providers/binance/open-interest-(futures)) | **Open Interest (Futures)** | =CS.QUERY("Binance","Open Interest (Futures)") | =CS.PARAMETERS("Binance","Open Interest (Futures)") | 1 | | Try It | [Docs](/providers/binance/notional-and-leverage-brackets-(futures)) | **Notional And Leverage Brackets (Futures)** | =CS.QUERY("Binance","Notional And Leverage Brackets (Futures)") | =CS.PARAMETERS("Binance","Notional And Leverage Brackets (Futures)") | 2 | | Try It | [Docs](/providers/binance/open-interest-statistics-(futures)) | **Open Interest Statistics (Futures)** | =CS.QUERY("Binance","Open Interest Statistics (Futures)") | =CS.PARAMETERS("Binance","Open Interest Statistics (Futures)") | 6 | | Try It | [Docs](/providers/binance/top-trader-long-short-ratio---accounts-(futures)) | **Top Trader Long-Short Ratio - Accounts (Futures)** | =CS.QUERY("Binance","Top Trader Long-Short Ratio - Accounts (Futures)") | =CS.PARAMETERS("Binance","Top Trader Long-Short Ratio - Accounts (Futures)") | 6 | | Try It | [Docs](/providers/binance/top-trader-long-short-ratio---positions-(futures)) | **Top Trader Long-Short Ratio - Positions (Futures)** | =CS.QUERY("Binance","Top Trader Long-Short Ratio - Positions (Futures)") | =CS.PARAMETERS("Binance","Top Trader Long-Short Ratio - Positions (Futures)") | 6 | | Try It | [Docs](/providers/binance/long-short-ratio-(futures)) | **Long-Short Ratio (Futures)** | =CS.QUERY("Binance","Long-Short Ratio (Futures)") | =CS.PARAMETERS("Binance","Long-Short Ratio (Futures)") | 6 | | Try It | [Docs](/providers/binance/acquiring-algorithm) | **Acquiring Algorithm** | =CS.QUERY("Binance","Acquiring Algorithm") | =CS.PARAMETERS("Binance","Acquiring Algorithm") | 1 | | Try It | [Docs](/providers/binance/acquiring-coinname) | **Acquiring CoinName** | =CS.QUERY("Binance","Acquiring CoinName") | =CS.PARAMETERS("Binance","Acquiring CoinName") | 1 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/binance/current-average-price) | **Current Average Price** | =CSQUERY("Binance","Current Average Price") | =CSPARAMETERS("Binance","Current Average Price") | 1 | | Try It | [Docs](/providers/binance/symbol-price-ticker) | **Symbol Price Ticker** | =CSQUERY("Binance","Symbol Price Ticker") | =CSPARAMETERS("Binance","Symbol Price Ticker") | 1 | | Try It | [Docs](/providers/binance/symbol-order-book-ticker) | **Symbol Order Book Ticker** | =CSQUERY("Binance","Symbol Order Book Ticker") | =CSPARAMETERS("Binance","Symbol Order Book Ticker") | 1 | | Try It | [Docs](/providers/binance/staking-list) | **Staking List** | =CSQUERY("Binance","Staking List") | =CSPARAMETERS("Binance","Staking List") | 2 | | Try It | [Docs](/providers/binance/staking-detail) | **Staking Detail** | =CSQUERY("Binance","Staking Detail") | =CSPARAMETERS("Binance","Staking Detail") | 1 | | Try It | [Docs](/providers/binance/exchange-information---spot) | **Exchange Information - SPOT** | =CSQUERY("Binance","Exchange Information - SPOT") | =CSPARAMETERS("Binance","Exchange Information - SPOT") | 0 | | Try It | [Docs](/providers/binance/order-book-(spot)) | **Order Book (SPOT)** | =CSQUERY("Binance","Order Book (SPOT)") | =CSPARAMETERS("Binance","Order Book (SPOT)") | 2 | | Try It | [Docs](/providers/binance/recent-trades-list-(spot)) | **Recent Trades List (SPOT)** | =CSQUERY("Binance","Recent Trades List (SPOT)") | =CSPARAMETERS("Binance","Recent Trades List (SPOT)") | 2 | | Try It | [Docs](/providers/binance/old-trade-lookup-(spot)) | **Old Trade Lookup (SPOT)** | =CSQUERY("Binance","Old Trade Lookup (SPOT)") | =CSPARAMETERS("Binance","Old Trade Lookup (SPOT)") | 4 | | Try It | [Docs](/providers/binance/compressed-aggregate-trades-list-(spot)) | **Compressed Aggregate Trades List (SPOT)** | =CSQUERY("Binance","Compressed Aggregate Trades List (SPOT)") | =CSPARAMETERS("Binance","Compressed Aggregate Trades List (SPOT)") | 5 | | Try It | [Docs](/providers/binance/kline-candlestick-data-(spot)) | **Kline-Candlestick Data (SPOT)** | =CSQUERY("Binance","Kline-Candlestick Data (SPOT)") | =CSPARAMETERS("Binance","Kline-Candlestick Data (SPOT)") | 5 | | Try It | [Docs](/providers/binance/current-average-price-(spot)) | **Current Average Price (SPOT)** | =CSQUERY("Binance","Current Average Price (SPOT)") | =CSPARAMETERS("Binance","Current Average Price (SPOT)") | 1 | | Try It | [Docs](/providers/binance/24hr-ticker-price-change-statistics-(spot)) | **24Hr Ticker Price Change Statistics (SPOT)** | =CSQUERY("Binance","24Hr Ticker Price Change Statistics (SPOT)") | =CSPARAMETERS("Binance","24Hr Ticker Price Change Statistics (SPOT)") | 1 | | Try It | [Docs](/providers/binance/symbol-price-ticker-(spot)) | **Symbol Price Ticker (SPOT)** | =CSQUERY("Binance","Symbol Price Ticker (SPOT)") | =CSPARAMETERS("Binance","Symbol Price Ticker (SPOT)") | 1 | | Try It | [Docs](/providers/binance/symbol-order-book-ticker-(spot)) | **Symbol Order Book Ticker (SPOT)** | =CSQUERY("Binance","Symbol Order Book Ticker (SPOT)") | =CSPARAMETERS("Binance","Symbol Order Book Ticker (SPOT)") | 1 | | Try It | [Docs](/providers/binance/exchange-information-(futures)) | **Exchange Information (Futures)** | =CSQUERY("Binance","Exchange Information (Futures)") | =CSPARAMETERS("Binance","Exchange Information (Futures)") | 0 | | Try It | [Docs](/providers/binance/order-book--(futures)) | **Order Book (Futures)** | =CSQUERY("Binance","Order Book (Futures)") | =CSPARAMETERS("Binance","Order Book (Futures)") | 2 | | Try It | [Docs](/providers/binance/recent-trades-list--(futures)) | **Recent Trades List (Futures)** | =CSQUERY("Binance","Recent Trades List (Futures)") | =CSPARAMETERS("Binance","Recent Trades List (Futures)") | 2 | | Try It | [Docs](/providers/binance/old-trade-lookup--(futures)) | **Old Trade Lookup (Futures)** | =CSQUERY("Binance","Old Trade Lookup (Futures)") | =CSPARAMETERS("Binance","Old Trade Lookup (Futures)") | 4 | | Try It | [Docs](/providers/binance/compressed-aggregate-trades-list--(futures)) | **Compressed Aggregate Trades List (Futures)** | =CSQUERY("Binance","Compressed Aggregate Trades List (Futures)") | =CSPARAMETERS("Binance","Compressed Aggregate Trades List (Futures)") | 5 | | Try It | [Docs](/providers/binance/kline-candlestick-data--(futures)) | **Kline-Candlestick Data (Futures)** | =CSQUERY("Binance","Kline-Candlestick Data (Futures)") | =CSPARAMETERS("Binance","Kline-Candlestick Data (Futures)") | 5 | | Try It | [Docs](/providers/binance/mark-price-(futures)) | **Mark Price (Futures)** | =CSQUERY("Binance","Mark Price (Futures)") | =CSPARAMETERS("Binance","Mark Price (Futures)") | 1 | | Try It | [Docs](/providers/binance/get-funding-rate-history-(futures)) | **Get Funding Rate History (Futures)** | =CSQUERY("Binance","Get Funding Rate History (Futures)") | =CSPARAMETERS("Binance","Get Funding Rate History (Futures)") | 5 | | Try It | [Docs](/providers/binance/24hr-ticker-price-change-statistics-(futures)) | **24hr Ticker Price Change Statistics (Futures)** | =CSQUERY("Binance","24hr Ticker Price Change Statistics (Futures)") | =CSPARAMETERS("Binance","24hr Ticker Price Change Statistics (Futures)") | 1 | | Try It | [Docs](/providers/binance/symbol-price-ticker-(futures)) | **Symbol Price Ticker (Futures)** | =CSQUERY("Binance","Symbol Price Ticker (Futures)") | =CSPARAMETERS("Binance","Symbol Price Ticker (Futures)") | 1 | | Try It | [Docs](/providers/binance/symbol-order-book-ticker-(futures)) | **Symbol Order Book Ticker (Futures)** | =CSQUERY("Binance","Symbol Order Book Ticker (Futures)") | =CSPARAMETERS("Binance","Symbol Order Book Ticker (Futures)") | 1 | | Try It | [Docs](/providers/binance/get-all-liquidation-orders-(futures)) | **Get All Liquidation Orders (Futures)** | =CSQUERY("Binance","Get All Liquidation Orders (Futures)") | =CSPARAMETERS("Binance","Get All Liquidation Orders (Futures)") | 4 | | Try It | [Docs](/providers/binance/open-interest-(futures)) | **Open Interest (Futures)** | =CSQUERY("Binance","Open Interest (Futures)") | =CSPARAMETERS("Binance","Open Interest (Futures)") | 1 | | Try It | [Docs](/providers/binance/notional-and-leverage-brackets-(futures)) | **Notional And Leverage Brackets (Futures)** | =CSQUERY("Binance","Notional And Leverage Brackets (Futures)") | =CSPARAMETERS("Binance","Notional And Leverage Brackets (Futures)") | 2 | | Try It | [Docs](/providers/binance/open-interest-statistics-(futures)) | **Open Interest Statistics (Futures)** | =CSQUERY("Binance","Open Interest Statistics (Futures)") | =CSPARAMETERS("Binance","Open Interest Statistics (Futures)") | 6 | | Try It | [Docs](/providers/binance/top-trader-long-short-ratio---accounts-(futures)) | **Top Trader Long-Short Ratio - Accounts (Futures)** | =CSQUERY("Binance","Top Trader Long-Short Ratio - Accounts (Futures)") | =CSPARAMETERS("Binance","Top Trader Long-Short Ratio - Accounts (Futures)") | 6 | | Try It | [Docs](/providers/binance/top-trader-long-short-ratio---positions-(futures)) | **Top Trader Long-Short Ratio - Positions (Futures)** | =CSQUERY("Binance","Top Trader Long-Short Ratio - Positions (Futures)") | =CSPARAMETERS("Binance","Top Trader Long-Short Ratio - Positions (Futures)") | 6 | | Try It | [Docs](/providers/binance/long-short-ratio-(futures)) | **Long-Short Ratio (Futures)** | =CSQUERY("Binance","Long-Short Ratio (Futures)") | =CSPARAMETERS("Binance","Long-Short Ratio (Futures)") | 6 | | Try It | [Docs](/providers/binance/acquiring-algorithm) | **Acquiring Algorithm** | =CSQUERY("Binance","Acquiring Algorithm") | =CSPARAMETERS("Binance","Acquiring Algorithm") | 1 | | Try It | [Docs](/providers/binance/acquiring-coinname) | **Acquiring CoinName** | =CSQUERY("Binance","Acquiring CoinName") | =CSPARAMETERS("Binance","Acquiring CoinName") | 1 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*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 **Click here** for additional documentation from Binance Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `Binance` `provider`