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
Thom Hartle
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… moreThis 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