Exchange prices in the historic data table widget

Physical and exchange prices can be aligned in the same Historic Data Table widget. The exchange prices and physical prices align side by side. For physical prices which do not price daily the table has the option in the Settings button to show "carries forward". These are prices in grey between assessment date to align with daily exchange prices. 

For Exchange data, go to the Settings drop down and pick “Null” which will show all weekdays including holidays even if there is no updated price, or select “Value” which will returned only dates with published prices. This is important if you will be exporting the data into Excel to calculate an average.

When viewing Exchange data in a Historical Prices table, you have the option to select different historical fields depending on the source of data. 

You have the ability to view one commodity or view multiple different prices that you are tracking.

Once you have selected the relevant prices into a Historical Price table, select the Settings button on the top right of the widget. You will then be able to select which historical prices you would like to view.

The following data sets have historical fields available - 

• CME (COMEX/NYMEX/CBOT) – Settlement 
• SHFE – Settlement or Close 
• FX Prices –Close Bid London (4pm snapshot) or Close Bid (midnight close).
• LME Officials – Bid, Ask, Mid