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
Excel/RTD
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.
Reference operatorMeaningExample: (colon)Range operator, which produces one reference… more
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 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
The S&P North American Natural Resources Sector Index is a financial benchmark that measures the performance of U.S. and Canadian publicly traded companies operating within the natural… more