Automate TradingView Data Imports To Google Sheets

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Click here to install

Alternatively, you can get it from Google Sheets.

• Open a new sheet
• Go to Extensions→Add-ons→Get add-ons
• Search for Amigo Data and install

We’ll be using a third-party TradingView API on RapidAPI to automate TradingVew data imports to Google Sheets.

Sign or log in up to RapidAPI.

Once you’re logged in, go to the TradingView API documentation in RapidAPI.

Choose a subscription plan from the Pricing menu. We’ll choose the Basic plan; you can upgrade any time should you need to. After subscribing to a plan we’ll be able to import TradingView data to Google Sheets.

Click Endpoints to go back to the API documentation and scroll down a bit. You will find your API key under the Header Parameters. This is the RapidAPI key that we’ll use to pull data from TradingView to Google Sheets.

On the left of the API documentation page is a list of available data endpoints we can retrieve from TradingView using the API.

For this tutorial, let us import from market/get-movers endpoint. This endpoint provides us with movers in different exchanges and different categories.

The header parameter consists of the API key and API host.

In the required parameters section, we have to input the exchange from which to retrieve data. Enter any one from the given options, say, BSE to import BSE data to Google Sheets.

Then in the optional parameter, specify the type of data to fetch. Let’s import stocks with the highest percentage change from BSE to Google Sheets. So, we’ll input percent_change_data in the name field.

Click the Test Endpoint button to run the query.

The success message indicates that the endpoints are functioning correctly. 

The TradingView API endpoint URL can be found in the Code Snippets section.

Change the language from (Shell) cURL from the dropdown list.

Copy the URL excluding the apostrophes and also note the headers. This is the endpoint URL for the data to import to Google Sheets.

Go back to Google Sheets and launch the Amigo Data extension.

Select Custom API from the list of sources.

Enter the API endpoint URL in the API URL field.

Then expand the Details tab and enter the headers mentioned in the Code Snippets:

Name: X-RapidAPI-Host, Value: trading-view.p.rapidapi.com

Name: X-RapidAPI-Key, Value: your_key

Replace your_key with your RapidAPI key.

Then click the PREVIEW button.

Flatten the nested data points and then click IMPORT.

The data from TradingView will be imported into Google Sheets is a couple of seconds.

A snippet of the data imported from TradingView to Google Sheets is shown below.

You can likewise import other types of data from the Trading View API. Following are some other examples.

Economic calendar data

Using calendar/get-economic-calendar endpoint, you can import economic calendar data by specific date ranges and countries. In the required parameter section, you need to enter from and to dates (YYYY-MM-DD). In the optional parameters, you can specify the country code from the list of supported countries.