This web API provides precise rate data for a wide range of commodities in a variety of currencies.
Commodities-API originated as a modest, minimalist Open-Source API for financial institutions’ recent and historical commodity prices.
With a precision of two decimal points and a rate of up to every 60 seconds, the API can provide real-time commodity data. Commodities-API is designed on a solid back-end architecture that provides response speeds for defined API calls of less than 50 milliseconds.
Only a few of the jobs include delivering commodity exchange rates, converting single currencies, and returning Time-Series and Fluctuation data.
The Commodities-API protects your connection with bank-grade 256-bit SSL encryption.
Commodities-API is used by thousands of developers, small businesses, and huge corporations on a daily basis. Because of its dependable data sources and 6+ years of expertise, this API is the most popular site for commodity rates.
We’ll demonstrate to you how to use the API Connector add-on for Sheets to pull gold data directly into Google Sheets from the Commodities-API. We’ll begin by obtaining an API key from Commodities-API, and then submit a request for gold data into your spreadsheet.
GET THE API CONNECTOR ADD-ON FROM THE GOOGLE MARKETPLACE BY CLICKING HERE BEFORE BEGINNING.
First section: Commodities
1° Get your API Key
2° Pick the plan that suits you the most and sign up
3° Once you verify your email address, go to your Dashboard
The second section: let’s get started
We’ll start by following the Commodities documentation to get the most recent cotton values in USD.
- API root: https://commodities-api.com/api/
- Endpoint: /latest
- Query strings: &base=USD&symbols = COTTON&access_key=YOUR_ACCESS_KEY
When we combine everything, we get the following API Request URL: https://commodities-api.com/api/latest?base=USD & symbols = COTTON&access_key=YOUR_ACCESS_KEY
Third section: insert API data into Google Sheets
Let’s copy and paste the URL into API Connector.
1- Select Add-ons > API Connector > Open in Google Sheets from the drop-down menu.
2- In the Create tab, type the API URL we just defined.
3- We don’t require any headers, thus that section can be skipped. Set authentication to none because we don’t need any extra authentication.
4- To use it as your data destination, create a new tab and press ‘Set current’.
5- Type a name for your request and hit the Run button. Your sheet will update with the most recent gold statistics in a moment.
Now you’re ready to enjoy the features of this reliable API!
Also published on Medium.