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.
To import Webull data to Google Sheets, we will follow the steps below:
- Install the Amigo extension
- Generate API key
- Get the Webull API endpoint
- Import the data to Google Sheets
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.
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.
Once you’re logged in, go to the Webull API documentation in RapidAPI.
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.
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.
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.
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.
Click the Test Endpoint button to 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.
Copy the URL excluding the apostrophes and also note the 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.
Select Custom API from the list of sources.
Enter the Webull API endpoint URL in the API URL field.
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.
Then click the PREVIEW button to retrieve and preview the Webull data to import to Google Sheets.
Flatten the nested datasets and then click IMPORT.
The data from Webull will be imported into Google Sheets in a short while. Below is a snippet of the imported data.
You can likewise import other types of data from Webull to Google Sheets using the Webull API. Following are some other examples.
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.
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.
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