The LAMBDA function is used to create reusable custom functions, which can be called using a "friendly" name. As an introduction to using the LAMBDA function, a previous post detailed using the…
CQG News
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…
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",…
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…
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…
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…
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…
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…
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…