Thom Hartle

This post combines four Excel functions for managing market performance measurements. The market performance measurements are the top ten and bottom ten percentage net changes. The time periods… more

This post details a downloadable Microsoft Excel dashboard that tracks the current sessions performance of the holdings of the iShares S&P 100 ETF (Symbol: OEF).

The iShares S&P 100… more

This midweek look shows the Nikkei 225 (Osaka), Sep 26 contract, with a gain of +0.77%. The best performer in the US market is the E-mini S&P 500, Sep 26 contract showing a loss of -0.… more

This table is from Microsoft's Excel Help file for Reference Operators. It lists three Reference Operators.

Reference operatorMeaningExample: (colon)Range operator, which produces one reference… more

This midweek look shows the Nikkei 225 (Osaka), Sep 26 contract, with a loss of -1.00%. The best performer in the US market is the E-mini NASDAQ -100, Sep 26 contract showing a loss of -0.… more

In CQG Desktop or CQG One, you can write custom formulas for monitoring risk and account status using the "account." prefix. These formulas can be used to create custom columns or filters in the… more

This midweek look shows the Nikkei 225 (Osaka), Sep 26 contract, with a loss of -2.57%. The best performer in the US market is the E-mini S&P 500, Sep 26 contract showing a loss of -0.… more

In legacy Excel if a function required the data to be returned to be an array then you had to press Ctrl + Shift + Enter following entering the function. You would see curly brackets surrounding… more

This midweek look shows the Nikkei 225 (Osaka), Sep 26 contract, with a loss of -0.26%. The best performer in the US market is the E-mini Dow, Sep 26 contract showing a gain of +0.30%. The… more

On August 24, 2026, the Chicago Mercantile Exchange began trading E-nano Equity Index futures contracts. The new contracts give 23-hour exposure to the S&P 500, Nasdaq-100, Russell 2000 and… more