Thom Hartle

Technical studies are used to analyze markets and are often the basis for trading decisions. The studies all take market data and apply mathematical steps that result in a single value.

An… more

This midweek look shows the Nikkei 225 (Osaka), Dec 26 contract, with a gain of +1.29%. The best performer in the US market is the E-mini NASDAQ-100, Dec 26 contract showing a gain of +2.81… more

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.

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