# How To

#### Excel 365 LARGE and XLOOKUP Functions

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")

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

#### Excel Heat Mapping Using Check Boxes

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

#### Excel Quick Analysis Tool

This post introduces using Excel's Quick Analysis Tool. First, a walkthrough of a typical application of one of Excel's data visualization features (heatmapping). In the image below heatmapping… more

#### FRED and CQG's XData

This post offers two topics: An introduction to the website FRED (Federal Reserve Economic Data) maintained by the Federal Reserve Bank of St. Louis and CQG's XData functionality, which is the… more

#### Excel Pie Charts

Pie charts are a popular visual presentation used by analysts for detailing a percentage of a whole, with a circle representing the whole and slices representing the categories that make up the… more

#### Excel Combining SORTBY, CHOOSECOLS, and TAKE Functions

This post presents "how to" rank and sort market data using Excel's SORTBY, CHOOSECOLS, and TAKE functions. This method is a replacement for applying RANK and VLOOKUP functions for ranking and… more

#### Excel's SWITCH Function

Excel's SWITCH function is similar to Excel's IF and IFS functions and is the topic of this post. First, a review of the IF and IFS functions.

Users of Microsoft Excel may utilize the IF… more

#### Excel 365 BYCOL and by BYROW Functions and a Correlation Matrix

This post details how to extract data from a large array, such as a correlation matrix, to make your workflow more efficient.

First, as the LAMBDA function is used, a brief overview is… more

#### Dumbbell Charts in Excel

Dumbbell charts have the name due to the look of the data displayed having the appearance of a dumbbell.

In other words, a circle at each end connected by a line. In the image above… more