Workspaces

CQG offers the Moving Linear Regression Line study. When plotted on a chart the line (blue line below) is the endpoint of a best fit line using the least squares technique. This technique finds… more

This post details a Microsoft Excel dashboard that tracks the day's performance of the holdings of the Invesco PHLX Semiconductor ETF (Symbol: SOXQ).

From the Invesco website regarding the… more

This post details a Macro-Enabled Excel Dashboard that tracks the holding of the S&P 500 Index and compares the percentage net change of each stock to the percentage net change of the cash S… more

This post is an update to: Excel 365: NASDAQ 100 Screening Dashboard.

Instead of the NASDAQ 100 Index, the iShares S&P 100 ETF (Symbol: S.OEF) is used. The ETF seeks to track an index… more

This post details using Excel's MAP function to rank the companies in the S&P 500 index performance relative to the S&P 500 index's performance. This is defined by today's percentage net… more

Technical studies are used to analyze markets and are often the basis for trading decisions. The studies all take market data and apply mathematical steps that result in a single value.

An… more

This post combines four Excel functions for managing market performance measurements. The market performance measurements are the top ten and bottom ten percentage net changes. The time periods… more

This post details a downloadable Microsoft Excel dashboard that tracks the current sessions performance of the holdings of the iShares S&P 100 ETF (Symbol: OEF).

The iShares S&P 100… more

This table is from Microsoft's Excel Help file for Reference Operators. It lists three Reference Operators.

In CQG Desktop or CQG One, you can write custom formulas for monitoring risk and account status using the "account." prefix. These formulas can be used to create custom columns or filters in the… more