In the attached Excel file, I want to
Step 1 - Calculate yearly averages for column Q (PRIOR SETTLE) and put that value in new column U at row CONTRACT MONTH = 12 (December). CONTRACT MONTH is column B and CONTRACT YEAR is column C.
Step 2 - Using column F (PRODUCT DESCRIPTION) "Wti Financial Futures" and "Henry Hub Natural Gas Futures", Create PRICING worksheet with given format.
The settlements page contains the complete CSV download file with all PRODUCT DESCRIPTIONS at http://www.cmegroup.com/market-data/settlements/. However, I was not able to upload the entire file with all PRODUCT DESCRIPTIONS but would like to have ability to do for all of the products.
Thank you.
Bookmarks