This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (symbol: DJIA).
Throughout the trading session, the thirty individual stocks are dynamically ranked and displayed in the histogram bar chart with their respective net percent change for today’s trading session.
In addition, this dashboard offers a high/low color alert. If the last prices is within two cents of the high, then the high price is highlighted with a green background. If the last prices is within two cents of the low, then the low price is highlighted with a red background.
The percent net change column is heat mapped. 5-minute Sparkline charts are next to the Net Change column.
Next to each company name is a link to Yahoo Finance. Clicking the News link will take you to the Yahoo page for that symbol.
There are two 5-minute open, high, low, and close charts updated throughout the trading session. The left chart is the DJIA. The right chart can display any symbol you enter. All capital letters are required when entering symbols.
Make sure to lower your Excel RealTimeData (RTD) throttle to 50 milliseconds or lower. Learn how to do that here.
Requires CQG Integrated Client, data enablements for the NYSE and Nasdaq, and Dow and Key Indices.
DJIA and Dow Jones Industrial Average are registered trademarks of Dow Jones Trademark Holdings LLC (“Dow Jones”).