# Workspaces

#### The Pareto Chart in Excel 2016 - 365

###### Aug 12, 2024

A Pareto chart is a histogram chart displaying columns sorted in a descending order and a line representing the cumulative total percentage. Pareto charts highlight the largest factors in a data… more

#### Working With Excel 365 "Spill" Ranges

###### Aug 06, 2024

The post "Excel Combining SORTBY, CHOOSECOLS, and TAKE Functions" discusses Excel 365's Dynamic Arrays and the concept of returned data automatically "spilling" into a collection of cells.

more

#### CQG Primer: Analyze Commitment of Traders (COT) with an Oscillator

###### Jul 22, 2024

Tracking and analyzing cash market data is more difficult because most cash market data is a single print for the day of the report, that is there is no open, high, low or close, just the close.… more

#### Excel 365 Filter Function

###### Jul 15, 2024

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

#### Excel 365 SEQUENCE Function

###### Jul 08, 2024

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

#### Excel 365 XMATCH Function

###### Jul 01, 2024

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

#### CBOE Europe Derivatives

###### Jun 26, 2024
Introduction

Cboe Europe Derivatives (CEDX) is a European derivatives marketplace which enables participants to access equity derivatives markets for quotes and trade execution.

CEDX offers a… more

#### CQG Primer: Study Recalculation Setting and RTD Parameters

###### Jun 20, 2024

CQG IC and QTrader offer the ability to set recalculation rates for studies. In addition, RTD study formulas have a recalculation rate parameter.

In CQG select a chart and then Setup/Chart… more

#### Excel 365 LARGE and XLOOKUP Functions

###### Jun 17, 2024

Excel 365 offers the LARGE and XLOOKUP functions. This post details using both for tracking market performance.

The image below is a table from Excel where the data presented are percent net… more

#### Excel's Implicit Intersection Operator: =@CQGContractData("EP", "LastTrade",, "T")

###### Jun 10, 2024

The RTD function displayed in the title of the post includes the "@" sign. If you use the CQG RTD Toolkit installed on the Excel Ribbon when either CQG IC or QTrader are installed to pull in "… more