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
Workspaces
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:
Around-the-clock trading access. Futures trade nearly 24 hours a day (17:00 CST to 16:00 CST) allowing you to trade… more
The CME is now offering Single Stock Futures trading. The benefits include:
Around-the-clock trading access. Futures trade nearly 24 hours a day (17:00 CST to 16:00 CST) allowing you to trade… more
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
This post offers a downloadable CQG PAC for installing the DJT and DJU Page in CQG IC or QTrader. The page details the current session's market performance of the constituents of the two averages… more
Excel has some very useful functions for screening market performance data and filtering large amounts of data to highlight particular user defined results for further analysis.
This post… more