Excel

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

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