Charting New Horizons: Navigating Stock and Commodities Markets with Jedox 📈📊
Hello dear Jedox beginners,
In this post, we will take an unusual path and instead of connecting to usual business tools, we will try to extract the commodity and stock data. To do that we will connect to free API at https://www.alphavantage.co/.
Alpha Vantage is a financial data provider that offers a wide range of financial market data and services. It provides access to historical and real-time market data for various asset classes, including stocks, cryptocurrencies, forex (foreign exchange), and more. At this moment we will focus on commodity data.
The connection will be Rest type and the extract will be from JSON.
Technical details for commodities API
Resource is: https://www.alphavantage.co/query?function=${Commodity}&interval=daily&apikey=${API} where API Parameters are
❚ Required: function
The function of your choice. In this case, function=BRENT which is crude oil. A list of the commodities will come with the model
❚ Optional: interval
By default, interval=monthly. Strings daily, weekly, and monthly are accepted.
❚ Optional: datatype
By default, datatype=json. Strings json and csv are accepted with the following specifications: json returns the time series in JSON format; csv returns the time series as a CSV (comma-separated value) file.
❚...