Commodity Price Database Including Automatic Futures Download
Originally published: 06/06/2020 16:19
Publication number: ELQ-98805-1
View all versions & Certificate
certified

Commodity Price Database Including Automatic Futures Download

Includes a database file along with videos that allows you to create analyses of historic commodity prices as

Description
This tool includes a database file along with videos that allows you to create analyses of historic commodity prices as well as commodity futures prices. Databases on commodity prices use information from the world bank and from the Chicago Mercantile Exchange (CME). The database file from the world bank is structured so that you can compare time series and analyze commodity price trends. The database file with futures prices allows you to evaluate futures prices for various different commodities including oil, natural gas, coal and electricity. I have also included VBA code to create the commodity databases where you can read the data and upload it. As with all of the databases, they are structured so that you can delete the old data and then upload new data.

Commodity prices can be very volatile, have mean reversion and be correlated with one another. The first step for analysis of assumptions related to commodity prices should therefore be gathering historic data. Sources for acquiring data include the world bank and futures markets. The world bank website includes a lot of monthly data on many commodity prices (except, unfortunately, diesel prices, petrochemical prices, petrol prices, steel prices and other prices that are from refined products). Local electricity commodity prices are also not in the database and are included in the energy analysis part of the website.

The workbook file listed below goes to the pink data part of the world bank website and updates historic commodity price data as well as forecast data published by the world bank. To update the history data you just have to press the macro button. You can download this file by pressing the button below. As with any of the databases or financial models.

You can update the file every month or couple of months and you can use the file to perform statistical analysis of the various commodity prices. The historic data can be updated very easily by pressing the macro button. To update reading of the forecast you have to look-up the link that sometimes changes.

The file allows you to analyse historic data and compare forecast and projected data for a large series of commodity prices.

This spreadsheet contains the following sheets and includes dynamic charts:
1. Table of Contents
2. Monthly Prices
3. Base Sheet
4. Offset Chart
5. Scatter
6. Distribution Chart
7. Distribution Chart 1
8. Month Moving Volatility
9. Volatility
10. Distributions
11. regression
12. Offset
13. Misc
14. Chart with NA Method

This Best Practice includes
1 Excel file, Link to video

Acquire business license for $25.00

Add to cart

Add to bookmarks

Discuss

Further information

to create analyses of historic commodity prices as well as commodity futures prices


0.0 / 5 (0 votes)

please wait...