In this article, we will learn how to get real-time market sentiments data to Google Sheets using Amigo Data Add-on. You will be able to import various kinds of market sentiment indicators that will help you analyze the market scenario like stocks with bullish/bearish sentiments, top trending stock tickers, news content, and many more. Amigo Data gives you the flexibility to update your data automatically, just set it up once and let Amigo Data do the job for you.
To import real-time market sentiments data to Google Sheets, we will follow the steps below:
- Install the Amigo Data add-on
- Generate API key
- Get the data endpoint
- Import the data to Google Sheets
Get Real-time Market Sentiments data to Google Sheets
Here’s the step-by-step guide to import real-time market sentiments data to Google Sheets.
Install the Amigo Data add-on
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
Generate the API key
Sign up for RapidAPI
Once you’re logged in, go to the Finance Social Sentiment For Twitter and StockTwits 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 from the get-sentiment-trending/bullish endpoint. This endpoint provides us with different kinds of data for the day like stock details, sentiment score, ranking, and many more.
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: finance-social-sentiment-for-twitter-and-stocktwits.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 social indicators data. Following are some other examples.
Top trending tickers data
Using a get-social-trending/posts endpoint, you can import the top 50 tickers trending on social media by posts. In the required parameters section, you can enter twitter/stocktwits. In the optional parameters section, you can set parameters like isCrypto(true/false), timestamp (24h/72h), and limit (to limit search results).
Get Stock-specific alerts
Using get-alerts endpoint, you can import data like changes in trading (price & volume), financial, & company news/announcement activities for a given stock or cryptocurrency. In the optional parameters section, you can stock tickers symbols separated by a comma.
Similarly, you can also explore other endpoints. To explore more endpoints go through the documentation.
After importing the data, you can also 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.
There are several other types of data that you can import into Google Sheets using Amigo Data such as Marketstack data, Coinmarketcap data, Nasdaq data, and many more. Visit our blog to find out the kinds of data you can import to Google Sheets.
Some related articles you may be interested in:
Get Real-time Stock Data In Google Sheets Using MarketStack API