This post offers a downloadable Excel Dashboard that details the current session's market performance of the constituents of the two averages.
The top block of the dashboard is the Dow Jones… more
Thom Hartle
This midweek look shows the Nikkei 225 (Osaka), Sep 26 contract, with a gain of +0.14%. The best performer in the US market is the NASDAQ 100, Sep 26 contract showing a gain of +2.62%. The… more
Updated 06/30/2026 to add ALPHABET CL A CMN (Symbol: S.GOOGL) and remove Verizon Communications (Symbol: S.VZ)
This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (… more
This post details using a nested XLOOKUP function to pull data from a matrix. The matrix displays the monthly percentage net change using a column for the symbols and a row for the months. The RTD… more
This post details the Market Profile Value Areas (MPVA) study, as well as providing a downloadable Excel sample for pulling MPVA study data into a spreadsheet.
When applied to a chart, the… more
This midweek look shows the Nikkei 225 (Osaka), Sep 26 contract, with a loss of -3.55%. The best performer in the US market is the E-mini Dow, Sep 26 contract showing a gain of +0.38%. The… more
On Workspaces there are four Excel Dashboard for tracking the current session’s performance of four ARK ETFs. The four ETFs added the recent SpaceX IPO: Space Exploration Technologies Corp. Class… more
This post walks through using Excel's XLOOKUP with Min, Median, and Max Functions to create a summary table of market performance for the forward curves of Soybeans, Soybean Meal, Soybean Oil,… more
This midweek look shows the Nikkei 225 (Osaka), Sep 26 contract, with a gain of +6.90%. The best performer in the US market is the E-mini Dow, Sep 26 contract showing a gain of +1.78%. The… more
This Excel Dashboard tracks the holdings of the Defiance Drone & Modern Warfare ETF.
From their Web Site:
Modern defense is being reshaped by drones, autonomous systems, and AI-… more