How to get historical settlement prices if not the same as close.

To get the last settlement for CL in excel I use =RTD("CQG.RTD",,"ContractData","CLEK5,"Settlement",,"T").

For many contracts if I use just the contract such as "CL" vs "CLE" I get the pit closes were close it the same as settlement.

Then I use =RTD("CQG.RTD", ,"ContractData", "CLEK5[-1]","Close",,"T") to pull out the close prices. The -1 is one day previous and if I change the value it changes the day, but if I use Settlement or Settle it does not work and for CLE the Close is not the same.

How can I get historical settees for a contract in excel or in CQG IC.


Sign In or Register to comment.