Excel 365 BYCOL and by BYROW Functions and a Correlation Matrix

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

Weekly Grain Seasonal Review 4.17.24

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

Dumbbell Charts in Excel

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

Weekly Grain Seasonal Review 4.10.24

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

Excel Parsing Data Functions

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

CME Strike Price Listing and Exercise Procedures Tables

Thom Hartle

The CME Website has information resources for options traders in the form of downloadable Excel tables with important needed details such as:

Commodity CodeCME Globex CodeProduct NameProduct… more

Weekly Grain Seasonal Review 4.3.24

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

CQG Primer: The Rank Study

Thom Hartle

The CQG Rank Study ranks the individual chart points of a market over a specified number of previous trading periods. For example, if the current bar's close had a rank of 3, and the periods were… more

Grains in the 2024 Crop Year

Andy Hecht

As the markets head into 2024's second quarter, the North American agricultural planting season is getting underway. Farmers are now planting the grains that feed and increasingly power the world… more

CQG Primer: The Klinger Volume Oscillator

Thom Hartle

The Klinger Volume Oscillator (KVO) was developed by Stephen Klinger. The study uses the difference between two exponential smoothed moving averages (EMA) of the "Volume Force" and includes a… more