Workspaces

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

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

The CME is now offering Single Stock Futures trading. The benefits include:

The CME is now offering Single Stock Futures trading. The benefits include:

This post is another example of using Excel functions and RTD calls to screen a large portfolio. The sample dashboard is the holdings of the S&P 500® Index (as of 7/20/2026). The screening is… 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

This post details CQG One's Volume Profile Study.

Once applied to a chart, the study calculates the Profile's Value Area and Point of Control (POC).

The value area begins calculating… more