Excel

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

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

If Microsoft Excel is an app that you utilize for building market screening dashboards then you might periodically require updating the symbols used in the dashboards. For example, using an Excel… more

This year, 2026, has seen a rotation towards large cap value stock. This post details a downloadable Microsoft Excel dashboard that tracks the current sessions performance of the holdings of the… more

This post is an update to: Excel 365: S&P 500 Screening Dashboard.

The original post offered an Excel dashboard that screened the holdings of the S&P 500 for market performance… more

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

The original post offered an Excel dashboard that screened the holdings of the NASDAQ 100 for market performance… more