The attached Excel spreadsheet is pulling the wrong data and I don't know why. The purpose of the macro is to go to these 2 locations at www.cmegroup.com and pull the most recent Settlement price with the suffix (Final). In the attached case, I ran the macro and it should have used the Friday, 01 Dec 2017 (Final) and some of the numbers match but not all.
Henry Hub Natural Gas Futures Settlements - http://www.cmegroup.com/trading/ener...ate=12/01/2017
Crude Oil Futures Settlements - http://www.cmegroup.com/trading/ener...ate=12/01/2017
Can anyone tell me what the macro is doing wrong and/or fix so it works correctly?
Thank you.
Bookmarks