Are you looking for an effective way to import real-time commodity price data to Google Sheets? Then you have come to the right place. By the end of this short tutorial, you will be able to import real-time commodity price data to Google Sheets and devise a trading plan that suits you the best.
With Amigo, you can import all sorts of data to Google Sheets in no time. From importing data to setting a refresh schedule to automatically update the data, Amigo handles it for you.
To import real-time commodity price data to Google Sheets, we will follow the steps below:
Real-time commodity price data imports to Google Sheets
Here’s the step-by-step guide to import real-time commodity price data to Google Sheets.
Install the Amigo extension
Install the Amigo 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 and install
Generate the API key
Sign up or log in to RapidAPI.
Once you’re logged in, go to the Global Stock Market API documentation in RapidAPI. This API is a gateway to global financial markets and you can import data like stock, futures, commodity prices, etc.
Click on Subscribe to Test button.
Choose a subscription plan. The basic plan will suffice for now.
Click Endpoints to go back to the API Playground. On the left is the list of the type of data that can be retrieved.
Get the data endpoint
From Get major commodities by price endpoint under the Major commodities section, we can import real-time commodity price data. With this endpoint, we can import real-time commodity price data of all the major commodities throughout the globe. It imports data from popular commodity exchanges MCX, NCDEX, and many more.
Click the Test Endpoint option to run the query
The success message indicates that the API is 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 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: global-stock-market-api-data.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.
The following snippet shows commodities price data from MCX, NCDEX, and many more. This way you can track real-time commodity price data.
You can likewise import other types of data using Global Stock Market API. You have learned how to import real-time commodity price data to Google Sheets from popular exchanges like MCX, NCDEX, etc. To explore more, go through the documentation.
After importing the commodity price data, you can set a refresh schedule so that the data are updated automatically at regular intervals. To learn how to set a refresh schedule, follow this link.
Amigo extension can connect Google Sheets to multiple sources and allows to import data automatically. It’s a convenient and versatile tool for importing and exporting data to Google Sheets. It can save a lot of time and effort. To learn more about other various kinds of data that can be imported to Google Sheets, visit our blog.
Some related articles you may be interested in: