#### Excel's SWITCH Function

###### 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

#### Weekly Grain Seasonal Review 4.24.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

#### What's New in CQG One & CQG Desktop Version 9.3

###### Marcus Kwan

Various improvements and bug fixes.

#### 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