S&P 500® and NASDAQ 100® Performance Dashboard

This Microsoft Excel® dashboard offers a two-window view for tracking market performance. The top half displays market data using symbols such as indices, stocks and futures that the user enters on the symbols tab. The bottom half has four stock percentage change performance tables. (You have to enable macros when this dashboard is first opened.) 

The performance tables use percent change for the day. The two tables on the left-hand side are the top and bottom ten stocks by net percentage gain/loss of those stocks that make up the S&P 500 index. The two displays are dynamically ranked by Excel using VBA code. Updates occur on a 1-second basis to manage Excel performance.

An additional column displays today’s traded volume versus yesterday’s 21-day moving average of the volume as a percent ratio. This column is heat mapped, which helps identify those stocks making large moves accompanied with unusually high volume. Blank cells indicate the stock does not have 21 trading days.

The right-hand side displays the same performance information for stocks traded on the Nasdaq exchange. Over 5,000 stocks are tracked.

Not all stocks open at the same exact moment, which can cause an issue with the VBA dynamic ranking. Simply click the Rank button at the bottom of the table and Excel will reevaluate stock performance and update the tables.

The center of the dashboard displays two five-minute charts that use the highest-ranked symbol in the top left-hand and right-hand displays. Down the center of the dashboard are exchange indicators, such as Up and Down Volume, Tick index, etc. Sparkline charts using five-minute values indicate the recent trend of the exchange indicators.

Requires CQG Integrated Client version 2016 and higher, Excel 2013 and higher, and real-time enablements for the NYSE, Nasdaq, and other exchanges whose products you plan to monitor.

Download the Excel File ‌‍‍‍‍

CQG-powered Excel dashboards are copyrighted content owned by CQG and are not available in an unlocked state.

S&P 500 is a registered trademark of The McGraw-Hill Companies, Inc.

Nasdaq-100 Index is a trademark of The Nasdaq Stock Market, Inc. 

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.