In the March 2025 issue of Technical Analysis of STOCKS & COMMODITIES magazine John Ehlers, President of MESA Software, presented "A New Solution, Removing Moving Average Lag."
The… more
Workspaces
The PriceToDollar function converts the prices of the particular market to their value. For example, below the E-mini S&P 500 futures contract's last price is 6003.75. And 6003.75 multiplied… more
Two recent posts CQG Primer: The Level Function and Level Function Using Excel RTD Formulas detailed using the Level function available in CQG IC and QTrader. The Level function plots two lines,… more
This post "CQG Primer: The Level Function" introduced the Level Function. The Level Function plots two lines, which identify the highest and lowest levels attained over a defined period. The… more
The BarInt function can be useful when creating Custom Studies or Conditions which can be applied to different timeframe but where a point of reference may be different whether you are looking at… more
One of the simplest examples for this function is to find out whether a value is an even number.
Modulus (Close(@),2) = 0In other words, the result of the formula above would give us the… more
Bring Updating Time-Series Data from Microsoft Excel® Into CQG
The XL Real-Time study is included in CQGIC subscriptions enabled for CQG Trading, or Spreader, as well as CQG Spreader systems. The… more
CQG customers who create their own custom studies can easily use RTD to pull custom study values into Excel.
There are only two unique requirements in the RTD formula for a custom study:… more