CQG & Excel
2 results found
-
Get Account Balances
In the CQG Integrated Client (IC), under the Account Summary tab there is a row named Account Balance. This, for us, has a value for each different currency which we use for our total balance calculation. That is, we have a value for AUD, CAD, GBP, EUR and so on. Then at the end there are the total and total changed values in USD. For us, these are fairly static values as the FX doesn't change. Contrast this to OTE or NLV which are available via the Excel Toolkit.
Would be great if we could get all these values in…1 voteThis will be available in CQG 2024, now in alpha, and to all customers later this year: https://news.cqg.com/news/announcements/2023/2023-06/cqg-2024-whats-new-cqg-rtd-toolkit-upgrade
-
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…
1 vote
- Don't see your idea?