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. Using Webull API, one can import various financial market data like top-gainers/losers, options data, and many more to make data-driven financial decisions.
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 to import Webull data to Google Sheets.
Install the Amigo Data add-on
Alternatively, you can get it from Google Sheets.
- Open a new sheet
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo and install
Generate the API key
Sign up or log in to RapidAPI.
Once you’re logged in, go to the Webull API documentation in RapidAPI.
Choose a subscription plan from the Pricing menu. In this tutorial, we will choose the Basic option
Click on the endpoints and scroll down a bit. You will find your API key under the Header Parameters.
Choose an endpoint
For this tutorial, we will import short-interest data with the get-short-interest endpoint. In the required parameter section, type in the tickerID 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 option to run the query.
The success message indicates that the endpoints are functioning correctly.
On the right side under Code Snippets, select Shell-> cURL from the dropdown menu.
Copy the URL excluding the apostrophes and also note the headers. This is the endpoint URL for the data to import to Google Sheets.
Import data to Google Sheets
Go back to Google Sheets and launch the Amigo Data extension.
Select Custom API from the list of sources.
Paste the endpoint in the API URL bar.
Then expand the Details tab and enter the following as headers:
Name: X-RapidAPI-Host, Value: webull.p.rapidapi.com
Name: X-RapidAPI-Key, Value: your_key
Replace your_key with your RapidAPI key.
Then click the PREVIEW button.
Flatten the data points and then click IMPORT.
A snippet of the imported data.
You can likewise import other types of data from 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.
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 documentation.
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: