This posts details the use of two Excel functions: AVERAGEIFS and COUNTIFS. To start, a simple example of using the AVERAGEIFS function is presented.
In the image below column cells A2:A10… more
Workspaces
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
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
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 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
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
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 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
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
Heat mapping is a data visualization technique that highlights market performance using colors. Typically, bright green for the top performers and bright red for the weakest performers and… more