Import Webull Data To Google Sheets

Reading Time: 5 minutes

Webull is a premium web platform that offers commission-free trading with no minimum deposit restriction. It also allows you to trade in extended market hours i.e. pre-market and after-hours sessions.

In this article, we will learn how to import Webull data to Google Sheets using Amigo with Webull API. Using Webull API, one can import various financial markets data like top-gainers/losers, options data, and many more.

Below is a snippet of daily top gainers from Webull imported into Google Sheets.

Webull top gainers

To import Webull data to Google Sheets, we will follow the steps below:

Webull data imports to Google Sheets

Here’s the step-by-step guide on how to use Webull API to import Webull data to Google Sheets.

Install the Amigo Data add-on

Install the Amigo Google Sheets add-on from the Google Workspace Marketplace to use the Webull API to import Webull data to Google Sheets.

Install the Amigo add-on

Install Amigo Data to import Webull data to Google Sheets

Alternatively, you can get it from Google Sheets.

  • Open Google Sheets
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install it.

Generate the API key

We’ll use a Webull API on RapidAPI to retrieve data from Webull and import them into Google Sheets.

Sign up or log in to RapidAPI.

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

Webull API documentation

Choose a subscription plan from the Pricing menu to use the Webull API to retrieve data from Webull to Google Sheets. You can opt for the Basic (free) plan and upgrade later should you need.

Subscribe to the Webull API to use retrieve data from Webull

Click Endpoints to go back to the Webull API documentation and scroll down a bit. You will find your API key under the Header Parameters.

Rapid API key

Choose a Webull API endpoint

On the left side of the Webull API documentation, we’ll find a list of data types that we can retrieve using the Webull API.

Types of data available for import with the Webull API

Click on any one of the endpoint categories and select an API endpoint. For this tutorial, we will import short-interest data with the get-short-interest endpoint under the stock” API.

In the required parameter section, enter the ticker ID of the stock you wish to import. 

Note: You can obtain the ticker ID of any stock by using stock/search endpoint.

List of endpoints under stock category

Click the Test Endpoint button to run the Webull API request.

Run the Webull API request

if the API is working and if the input parameter is valid, then we should see a success message along with the result of the API query.

The Webull API endpoint URL as well as the API headers which we’ll use to retrieve and import Webull data to Google Sheets can be found in the Code Snippets.

Change the language from (Node.js) Axios to (Shell) cURL from the dropdown menu.

Select the cURL from Shell

Copy the URL excluding the apostrophes and also note the headers.

Webull API endpoint URL and headers

Import the Webull data to Google Sheets

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

Launching Amigo Data to import Webull data to Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Enter the Webull API endpoint URL in the API URL field.

Entering the Webull API endpoint URL

Then expand the Details tab and enter the following as headers (as given in the Code Snippets):

Header 1
Name: X-RapidAPI-Host
Value: webull.p.rapidapi.com
Header 2
Name: X-RapidAPI-Key
Value: Your_key
Replace Your_key with your RapidAPI key.

Webull API headers

Then click the PREVIEW button to retrieve and preview the Webull data to import to Google Sheets.

Preview the Webull data to import to Google Sheets

Flatten the nested datasets and then click IMPORT.

Preview of the Webull data to import to Google Sheets

The data from Webull will be imported into Google Sheets in a short while. Below is a snippet of the imported data.

A snippet of the Webull data imported into Google Sheets

You can likewise import other types of data from Webull to Google Sheets using the Webull API. Following are some other examples.

Rating-Pricing-Target data

Using the rating-pricing-target endpoint, you can import the data about the rating, price, and target of a particular stock. In the required parameters section, enter the tickerID of the stock that you wish to search for.

Rating and price endpoint

Company profile data

Using the get-company-profile endpoint, you can import data like key holders, key executives, insiders, and many more about a particular company. In the required parameters section, enter the tickerID of the company.

Company profile endpoint

Similarly, you can also explore other endpoints. To explore more endpoints go through the Webull API documentation.

Automatically update the data

After importing the data, you can set a refresh schedule so that the data are updated automatically at regular intervals. By this, you can automate importing financial market data to Google Sheets. To learn how to set a refresh schedule, follow this link.

Amigo extension can connect Google Sheets to multiple sources and allows you to import data automatically. It’s a convenient and versatile tool to import and export data to Google Sheets. It can save you a lot of time and effort. To learn more visit our blog.

There are several other types of data that you can import into Google Sheets using Amigo Data such as CNBC data, Trading View data, and Coinranking data to name just a few.

Some related articles you may be interested in:

Import CNBC Data To Google Sheets

Automate Trading View Data Imports To Google Sheets

Automate Coinranking Data Imports To Google Sheets

Leave a Reply