Thom Hartle

Each Wednesday this article will be updated with the current seasonal study using CQG's Seasonal analysis applied to the Soybean, Wheat and Corn markets. You can download the CQG pac providing the… more

Andy Hecht

COMEX copper futures posted a 2.10% gain in 2023 and moved 2.99% higher in Q1 2024, settling at $4.0070 per pound at the end of March. One month later, the price was over the $4.50 level, with… more

Thom Hartle

Excel's SWITCH function is similar to Excel's IF and IFS functions and is the topic of this post. First, a review of the IF and IFS functions.

Users of Microsoft Excel may utilize the IF… more

Thom Hartle

Each Wednesday this article will be updated with the current seasonal study using CQG's Seasonal analysis applied to the Soybean, Wheat and Corn markets. You can download the CQG pac providing the… more

Marcus Kwan

Various improvements and bug fixes.

GeneralWidgets can now belong to more than 1 linking groupAdded Messages to the right barAdded Spanish language supportTrading/ReportingStrategy builder can… more
Thom Hartle

This post details how to extract data from a large array, such as a correlation matrix, to make your workflow more efficient.

First, as the LAMBDA function is used, a brief overview is… more

Thom Hartle

Each Wednesday this article will be updated with the current seasonal study using CQG's Seasonal analysis applied to the Soybean, Wheat and Corn markets. You can download the CQG pac providing the… more

Thom Hartle

Dumbbell charts have the name due to the look of the data displayed having the appearance of a dumbbell.

In other words, a circle at each end connected by a line. In the image above… more

Thom Hartle

Each Wednesday this article will be updated with the current seasonal study using CQG's Seasonal analysis applied to the Soybean, Wheat and Corn markets. You can download the CQG pac providing the… more

Thom Hartle

This post offers solutions to parsing data in Excel using string functions. As an example, this RTD formula returns the long description of a Crude Oil calendar spread:

=RTD("cqg.rtd", ,"… more