Import Data from Binance To Google Sheets

Import Data from Binance To Google Sheets
Reading Time: 5 minutes

Quick guide
1. How to import data from Binance to Google Sheets:
2. Install Amigo Data addon in Google Sheets
3. Get the endpoint for the data you want to import from Binance
4. Launch Amigo Data and select Custom API
5. Enter the endpoint in API URL
6. Preview and import

Below are samples of analytical charts in Google Sheets created with the imported data.

  • Top 20 currencies with most gain in price
  • Top 10 currencies most traded by volume

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. 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 can perform deeper and more minute analyses, and gain better insight as a result.

Let us import the price change statistics for all the cryptocurrencies in the last 24 hours.

Step 1: Getting the tool to import the data

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.

You can get it from the Google Workspace Marketplace here.

Install Amigp Data to import data from Binance to Google Sheets

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: Getting 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.

The base endpoint is: https://api.binance.com. All endpoints start with the base endpoint.

Note: Binance also has other base endpoints. So if you face performance issues, you can try with one of the other base endpoints.

The other base endpoints are:
https://api1.binance.com
https://api2.binance.com
https://api3.binance.com

Now we need to get the endpoint for the 24hr ticker price change statistics.

Open the Binance API Documentation page. Click Market Data Endpoints and navigate to the 24hr Ticker Price Change Statistics.

API Documentation - Market Data Endpoints

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/24hr

This is the complete endpoint for the 24hr Ticker Price Change Statistics.

Step 3: Import data from Binance to Google Sheets

We can now begin importing data from Binance into Google Sheets.

  1. Open a new Google Sheets document and launch Amigo Data
    Extensions→Amigo Data→Connect
  2. From the list of sources, select Custom API.
  3. Keep GET as the option, and under API URL, paste the endpoint
  4. After that is done, click PREVIEW.

On the preview page, you can edit and remove information you do not want to import by clicking the FLATTEN button.

Once all that is done, click the IMPORT button. The data from Binance will be imported into Google Sheets in a couple of seconds.

Importing price tickers for some 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 enclosed under quotation marks and separated by a comma.

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

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/