Thom Hartle

Microsoft Excel 2016 introduced the IFS function. This function can replace using nested IF functions. Below is an example of nested IF functions:

=IF(N2=0,"#",IF(N2=1,"#.0",IF(N2=2,"#.00",… more

Thom Hartle

Excel 365 includes the SORT and SORTBY functions which provide users with a simple way to dynamically sort data on a real-time basis. A common use would be to dynamically sort market performance… 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

Andy Hecht

The raw material markets declined in Q4. The commodity asset class consisting of 29 primary commodities traded on U.S. and U.K. exchanges moved 3.91% lower in Q4 2023. At the end of 2023, the… more

Marcus Kwan

Various improvements and bug fixes.

GeneralAdded new linking mode so some widgets can be publishers, subscribers or bothTrading/ReportingCopy and paste of selected row in Orders widgets now… more
Thom Hartle

A post titled "Excel Indirect Function and More" was published on February 22, 2022, that detailed using Excel's INDIRECT function, as well as details to automatically format cells for displaying… 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

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

Microsoft® Excel 365 includes a Text function that makes pulling text out of a string much easier than before Excel 365 was released. To illustrate, we will review the steps before Excel 365 was… 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