Quick guide
How to import data from Binance to Google Sheets:
1. Install Amigo Data add-on in Google Sheets
2. Get the endpoint of the data
3. Launch Amigo Data and select Custom API
4. Enter the endpoint in API URL
5. Preview and import
Below is a snippet of the imported data and some analytical charts in Google Sheets created with the imported data.
Sections of the article:
Binance is a cryptocurrency exchange with all major cryptocurrencies listed. It is the largest cryptocurrency exchange in the world in terms of daily trading of the volume of cryptocurrencies. Binance offers crypto-to-crypto trading in more than 600 cryptocurrencies and virtual tokens, including Bitcoin (BTC), Ether (ETH), Litecoin (LTC), Dogecoin (DOGE), and its own token Binance Coin (BNB), as well as allows customers to trade cryptocurrencies for conventional fiat money and other assets.
In this tutorial, we’ll learn how we can import data from Binance to Google Sheets with Binance API using a tool called Amigo. You can import data such as exchange information, average current price, and 24-hour ticker price change statistics, as well as your trading information; in other words, all the exchange and trading information on Binance.
Import data like exchange information, current price, high price, low price, volume, quote volume, ticker price change statistics, and so on into Google Sheets for better tracking and deeper insights.
Having the data imported into Google Sheets means that we can perform deeper and more minute analyses, and gain better insight as a result.
How to import Binance data to Google Sheets
Step 1: Install the Amigo Data addon
We need a tool with which to import data from Binance to Google Sheets. For this, we’ll use Amigo Data, a simple but versatile Google Sheets extension that’s easy to use, rich in features, and gives you the ability to pull data from several different sources. Get it from the Google Workspace Marketplace by clicking the link below
Alternatively, you can open a Google Sheets document, then go to Extensions→Add-ons→Get add-ons. And search for Amigo Data and install.
Step 2: Get the endpoint for the data to import
Fetching public data to import data from Binance to Google Sheets doesn’t require any authentication. So, an API key isn’t required, except for importing private trading information. You can easily connect Binance to Google Sheets without API.
The base endpoint is: https://api.binance.com. All endpoints start with the base endpoint.
Binance also has other base endpoints. So if you face performance issues, you can try with one of the other base endpoints given below.
▸ https://api1.binance.com
▸ https://api2.binance.com
▸ https://api3.binance.com
Let us import the price change statistics for all the cryptocurrencies in the last 24 hours from Binance to Google Sheets.
Go to the Binance API Documentation page. Click Market Data Endpoints and navigate to the 24hr Ticker Price Change Statistics.
Note the endpoint–which is: /api/v3/ticker/24hr–and append it to the base endpoint, as shown below.
https://api.binance.com/api/v3/ticker/24hrThis is the complete endpoint for the 24hr Ticker Price Change Statistics. We’ll use this to retrieve data from Binance and import the data to Google Sheets.
Step 3: Import data from Binance to Google Sheets
To import the Binance data to Google Sheets, follow the steps below.
- Launch Amigo Data
Extensions→Amigo Data→Connect - From the list of sources, select Custom API
- Enter the endpoint URL in the API URL bar
- After that is done, click PREVIEW
- Flatten all the nested datasets
- Click the import button to import to Google Sheets.
The data from Binance will be imported into Google Sheets in a couple of seconds. Shown below are the price change statistics for all major coins imported into Google Sheets using Binance API.
And below are refined and filtered data.
Importing price tickers for certain cryptocurrencies
If, instead of importing the tickers for all the cryptocurrencies, you only want to import the ticker price change statistics for a few currencies that you’re interested in, then you can specify it in the query parameters.
Say you want to track the ticker price of Bitcoin, Ether, and Solana against the US Dollar, then after pasting the endpoint, expand the Details tab and add the queries.
In the Name box, enter symbols; and in the Value box, enter [“BTCUSDT”,“ETHUSDT”,“SOLUSDT”].
Here BTC, ETH, and SOL are the base assets, and USDT (“quote asset”) is the currency in which the price of the base asset is quoted.
You can add more currency pairs following the same format: each pair is enclosed in quotation marks and separated by a comma.
We have only used one endpoint as a demonstration of how to use Binance API to import data from Binance to Google with Binance API. There are several other data that you can retrieve including account information such as orders.
Adding and removing data
Should you want to add or remove cryptocurrency or edit the data, you can do so from the View Reports menu.
- Expand the menu
- Select the report to edit under Your Reports
- Click Edit Report and the PREVIEW
- Once the editing is done, click UPDATE
- Then finally click Save & Run
Setting refresh schedule
To get the information updated periodically, click the report you want to update automatically, toggle on the Refresh Schedule and select the schedule–hourly, daily, weekly or custom days.
Then click Save & Run.
Alerts via email or Slack
You can get the report sent to your email or a Slack channel if you want to.
To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.
Conclusion
This is our Binance Google Sheets guide. We can easily import data from Binance to Google Sheets using Amigo Data–a straightforward and hassle-free process. Moreover, Amigo Data gives you the ability to tweak and edit the data before importing them so that you have a dataset that is more readable and easier to understand, enabling to develop insight quickly.
See also
There are plenty of other things that you can use Amigo Data for such as importing data to Google Sheets from Google Trends, Google Ads, Facebook Ads, Google Search Console and MySQL among others. You can check out our blog for tutorials on them.
Some articles that you may be interested in:
https://blog.tryamigo.com/youtube-analytics-to-google-sheets/
https://blog.tryamigo.com/export-razorpay-data-to-google-sheets/
https://blog.tryamigo.com/importing-postgresql-data-to-google-sheets/