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 the function.
Today, in Excel you can use curly brackets to create returned data in the form of… more
On August 24, 2026, the Chicago Mercantile Exchange began trading E-nano Equity Index futures contracts. The new contracts give 23-hour exposure to the S&P 500, Nasdaq-100, Russell 2000 and the Dow Jones Industrial Average. The E-nano contracts are one-tenth the size of Micro E-mini futures… 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 (TRUE/FALSE statements become1s and 0s).
Think of it as a converter. The first dash turns a… 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 zero for the minimum which compresses the chart data. The macro will adjust the price axis. It does… 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 dashboard to track the current session's market performance of the constituents of the NADAQ 100. To… 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 iShares S&P 500 Value ETF.
From the website:
The iShares S&P 500 Value ETF seeks… 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 characteristics including the weekly, monthly, quarterly, and annual top ten percentage performers and… 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 characteristics including the weekly, monthly, quarterly, and annual top ten percentage performers and… 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 resources and commodities sectors. This post details a downloadable Microsoft Excel dashboard that tracks… more
This post is another example of using Excel functions and RTD calls to screen a large portfolio. The sample dashboard tracks the holdings of the NASDAQ 100® Index (as of 8/02/2026). The screening is for market performance characteristics including the weekly, monthly, quarterly, and annual top… more