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 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

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 table is from Microsoft's Excel Help file for Reference Operators. It lists three Reference Operators.

In legacy Excel if a function required the data to be returned to be an array then you had to press Ctrl + Shift + Enter following entering the function. You would see curly brackets surrounding… more

The Double Dash Operator (--) is formally known as the double unary operator. It is used in Excel to convert non-numeric data like TRUE/FALSE statements or text-based numbers into actual integers… more

This post details a macro-enabled Excel Dashboard for monitoring Soybeans, Soybean Meal, and Soybean Oil contracts. The macro is a feature for managing the price axis on the charts. Excel may use… more

This post details an Excel dashboard for measuring the Z-Score of stocks from the NASDAQ 100. The dashboard sets the parameters as user defined inputs for the time frame, the average lookback… more

Excel has some very useful functions for screening market performance data and filtering large amounts of data to highlight particular user defined results for further analysis.

This post… more

This post details using a nested XLOOKUP function to pull data from a matrix. The matrix displays the monthly percentage net change using a column for the symbols and a row for the months. The RTD… more