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
Thom Hartle
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
From their website:
The iShares Semiconductor ETF seeks to track an U.S. equity index of companies in the semiconductor sector. The fund offers a way to invest in companies across the… more