Skip to content

CQG & Excel

2 results found

  1. 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 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?

CQG & Excel

Categories

Feedback and Knowledge Base