Thom Hartle

The Excel 365 Filter function is a member of the Dynamic Arrays group. The function is useful for sorting through a large table of data.

The function is:

=FILTER(Array, Include, [If Empty… more
Thom Hartle

The Fixed Income futures markets are mostly lower so far this week. The TSE 10 Year JGB, Sep 24 contract is down -0.02%. The best performer in the US market is the 2yr US Treasury Note (… more

Thom Hartle

This midweek snapshot shows a mostly positive performance for the Equity Index futures markets. The best performer in the Japanese market is the Nikkei 225 (Osaka), Sep 24 contract with a +… 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

Excel 365 SQUENCE function populates a column or row with sequential integers, such as 1,2,3,4, etc.

The function has four parameters:

SEQUENCE(rows, [columns], [start], [step])

more

Thom Hartle

This midweek snapshot shows a mostly positive performance for the Equity Index futures markets. The best performer in the Japanese market is the Nikkei 225 (Osaka), Sep 24 contract with a +… more

Thom Hartle

The Fixed Income futures markets are mostly lower so far this week. The TSE 10 Year JGB, Sep 24 contract is down -0.01%. The best performer in the US market is the 5yr US Treasury Note (… 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, which includes a downloadable Excel sample at the bottom of the post, describes how to use Excel's XMATCH function to search a large table. The table used consists of the constituents… more

Marcus Kwan

Various improvements and bug fixes.

GeneralOptions view added to mobile modeContract volume option available for QB Donut viewChartingLast price line option added to CQG Profile… more