In this guide, we’ll walk through how to pull cryptocurrency market data from the Binance API directly into Google Sheets, using the API Connector add-on for Sheets.
The nice thing about Binance is that it doesn't require any authentication (though this also makes it more likely to produce errors). It also provides some detailed data that other APIs don't, like open orders and candlestick chart data.
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Pull Data from Binance to Sheets
The easiest way to get started with the Binance API is through API Connector’s built-in integration.
Select Binance from the drop-down list of applications
Select an endpoint. These endpoints are all open so you don't need an API key. For this example we'll choose the /ticker/24hr endpoint, which provides 24hr price change statistics.
Choose a destination sheet, name your request, and hit Run. A moment later you'll see price change stats for all currency pairs in your sheet.
Part 2: Create a Custom Request
Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the API URLs shown in the APIdocumentation. Here's an example request setup:
For most endpoints, Binance returns dates as UNIX timestamps .
To convert these timestamps to a human readable date, set your data destination to cell B1, and add the following formula to cell A2: =arrayformula((B2:B/1000)/86400+date(1970,1,1))
B2:B reflects the column in which the timestamp is located, so just modify it to match the column in which you want to convert timestamps.
Part 4: Binance Error Messages
If you use Binance for a little while, you'll almost certainly run into an error message from their server.
There are a few different errors you might see:
(403). <Request blocked. We can't connect to the server for this app or website at this time. There might be too much traffic or a configuration error. OR(418) {"code":-1003,"msg":"Way too much request weight used; IP banned until 1616682165041. Please use the websocket for live updates to avoid bans."}
You can see some information about these errors in Binance's docs, but basically Binance is sensitive to rate limits.
When you run your requests through API Connector / Google Sheets, you're more likely to hit these rate limits because all requests running through Google Sheets share the same pool of IP addresses from Google's servers. Unfortunately there isn't always enough capacity for Binance to handle the massive request volume from Google Sheets.
If you continue to have issues, I recommend switching to a crypto API that limits by your own API key rather than the shared pool of IP addresses for Google Apps Script. Please check this article for a list of alternative crypto APIs.
(451) { "code": 0, "msg": "Service unavailable from a restricted location according to 'b. Eligibility' in https://www.binance.com/en/terms.}
As of Nov 2022, Binance began blocking API calls sent through Google Cloud, which includes requests through Google Sheets (more info). This can be worked around through one of the following methods:
Use the data sub-domain, e.g. https://data.binance.com/api/v3/ticker/24hr
Use API Connector's preset integration instead of making a custom request. The preset integration automatically applies the data domain.
Select Add Account then choose the Binance tab on CoinLedger.Click on Auto-Import then enter your API Key and API Secret into CoinLedger.Click Connect.
Binance provides historical market data that can be downloaded via the Binance website or API. ... You can view all candlestick charts, trading, and aggregated trading data for Spot and Futures pairs.
Log in to your Binance account and go to [Institutional] - [Historical Market Data].
There are two common ways to add JSON API to Google Sheets: code and no-code. The code option is suitable for tech-savvy users who are more or less proficient in Google Apps Script, Python, or another programming language.
Simply type in, between quotation marks, the ticker symbol for the cryptocurrency as the only argument for the function. Alternatively, type the ticker symbol, without quotation marks, into a cell and use the cell reference in the formula.
Obtaining an API key. After logging in to your Binance account, click on the profile icon on the top right-hand side of the screen. From there, select API Management. Next, you will be asked to create a label for the API key.
Access Binance in Excel. Binance is the biggest cryptocurrency exchange in the world. Use this connector in Excel to access public exchange information, as well as your personal trading data.
Scrape and extract data on top users and their current positions from Binance Futures Leaderboard, the largest cryptocurrency exchange in the world. Use all filtering and sorting options provided by Binance to integrate top user crypto positions into your coin trading strategy.
Are API Connector requests secure? Yes. API Connector does not view or store API credentials or any of the data that gets retrieved. All requests run through Google's servers only, and API Connector does not have its own external databases.
To import this on excel go to Data>Get Data>From other Sources> From Web or simply Data>From Web.Paste the API URL on the prompt then click OK.Then select Into Table on the Convert tab.
An API connector provides Azure Active Directory with the information needed to call API endpoint by defining the HTTP endpoint URL and authentication for the API call. Once you configure an API connector, you can enable it for a specific step in a user flow.
To pull cryptocurrency prices into Google Sheets, follow these steps: Type =GOOGLEFINANCE( in a spreadsheet cell to begin the formula. Type a symbol for a cryptocurrency (between quotation marks), like this "BTCUSD" Press enter on the keyboard (Final formulas will look like this: =GOOGLEFINANCE("BTCUSD")
Register and log in to your Binance account, then go to [API Management].Enter the label API key and click [Create API].Upon successful creation, you can get the API Key and Secret Key.
Binance has upgraded its API deposit and withdrawal functions, allowing users to more freely deposit and withdraw interoperable tokens across multiple networks, as shown below. Allows withdrawals across multiple networks using API. Returns deposit addresses for multiple networks.
Log in to your Binance.US account. Then, hover over the User Profile button in the top-right corner and click 'Export Reports' from the drop-down menu. ...
Click 'Generate Reports' to continue.
To customize your report, select the Asset, Transaction Type, Date Range, and File Format, available as a . CSV or .
Binance.US is available to many, albeit not all, U.S. residents. It's important to note that this crypto exchange is not available to residents of Hawaii, New York, Texas and Vermont.
Register and log in to your Binance account, then go to [API Management]. Enter the label API key and click [Create API]. Upon successful creation, you can get the API Key and Secret Key.
Binance requires identity verification before it lets you deposit or withdraw funds. That's easy If you aren't a US citizen. Simply provide your ID information, complete your KYC, and use Binance freely.
Google Sheets' GOOGLEFINANCE function can be used to get cryptocurrency prices. Simply type in, between quotation marks, the ticker symbol for the cryptocurrency as the only argument for the function. Alternatively, type the ticker symbol, without quotation marks, into a cell and use the cell reference in the formula.
From the projects list, select a project or create a new one. If the APIs & services page isn't already open, open the left side menu and select APIs & services. On the left, choose Credentials. Click Create credentials and then select API key.
Binance users can now purchase crypto using Apple Pay & Google Pay. According to Binance, users can now use these payment methods to buy crypto coins and tokens listed on the platform.
Binance offers the Binance Pay payment option method to crypto-friendly companies. By displaying the store's unique QR code, merchants can set up Binance Pay in their physical location for a contactless, secure cryptocurrency payment experience.
Log in to your Binance.US account. Then, hover over the User Profile button in the top-right corner and click 'Export Reports' from the drop-down menu. ...
Click 'Generate Reports' to continue.
To customize your report, select the Asset, Transaction Type, Date Range, and File Format, available as a . CSV or .
Introduction: My name is Errol Quitzon, I am a fair, cute, fancy, clean, attractive, sparkling, kind person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.