Workspaces

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

This recent post "Quote Spreadsheet 2.0 TTM Squeeze and More" provided a page installed via a CQG PAC that included a CQG QSS V2 for monitoring the markets. The benefit of the Quote Spreadsheet 2.… more

This post "TTM Squeeze Indicator" detailed the TTM indicator, which is a combination of measuring volatility and momentum. The volatility is a condition where the Bollinger Bands contract and move… more

Excel users with RTD links to both market and study data can design a real-time dashboard that can monitor a portfolio of instruments and the status of various studies. This is the topic of this… more

Tracking and analyzing cash market data is more difficult because most cash market data is a single print for the day of the report, that is there is no open, high, low or close, just the close.… more

This post details how to extract data from a large array, such as a correlation matrix, to make your workflow more efficient.

First, as the LAMBDA function is used, a brief overview is… more