I would like to create a excel sheet with details of all future contracts for a commodity listed next to each other, starting with the current month to the farthest (which apparently looks like how most people maintain this data file). Refer to excel file CL - CBC.

CME releases daily bulletin in .pdf format and the information for example "Crude Oil" (CL) has to extracted from the file (Refer "Section61_Energy_Futures_Products"),transformed to the desired format (CL - CBC) and then moved to the maintenance file. This has to be done for every contract which consumes lot of time.

Has anyone here figured out a way to do this without having to spend lot of time on maintenance or have a data source which provides the required info in the desired format.Any help would be greatly appreciate.


Thank You

Hi, I realize this post is 2 weeks old. But if you still need help with this, send me a private message.