CQG IC and QTrader offer the Candlestick Formations study.
The Candlestick Formations study is a collection of conditions. Candlestick formations appear as overlays on the chart in the… more
Workspaces
This post details adding HTML News Links to an Excel dashboard for monitoring equities and ETFs.
The news source is Finance.Yahoo.com. An example link for Microsoft is https://finance.yahoo.… more
This post offers a downloadable sample Excel spreadsheet for pulling in historical data and study values from CQG IC or QTrader using RTD formulas.
The Data consists of:
Open, High, Low,… more
This post details the different techniques for pulling Depth-of-Market (DOM) data into Excel.
There are three ways:
C&P RTD formulas for Level 1 DOM data from the various quote… more
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
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 covers two topics: Details using the Chart Analog Overlay Study and the Percent Bar chart type.
Traders use the analog study to compare how markets are trading relative to each… 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 Level Function plots two lines, which identify the highest and lowest levels attained over a defined period. The chart below displays the Level Function using the default lookback period of 20… more