# Workspaces

#### FRED and CQG's XData

###### May 28, 2024

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

#### CQG Primer Pivot Points (cqg.PivotPts)

###### May 24, 2024

The pivot point is the arithmetic average of the high (H), low (L), and closing (C) prices of the active instrument, Pivot Point = (H+L+C)/3 or Pivot Point = HLC3. The study applied to a chart… more

#### Excel Pie Charts

###### May 20, 2024

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

###### May 13, 2024

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

#### CQG Global FX

###### May 06, 2024

CQG offers institutional pricing data across 430+ currency pairs of market data. Sourced directly from tier-1 banks and non-bank market makers worldwide, the feed provides up to 50 years of… more

#### Excel's SWITCH Function

###### Apr 29, 2024

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

###### Apr 22, 2024

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

###### Apr 15, 2024

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

#### Excel Parsing Data Functions

###### Apr 09, 2024

This post offers solutions to parsing data in Excel using string functions. As an example, this RTD formula returns the long description of a Crude Oil calendar spread:

=RTD("cqg.rtd", ,"… more

#### CME Strike Price Listing and Exercise Procedures Tables

###### Apr 05, 2024

The CME Website has information resources for options traders in the form of downloadable Excel tables with important needed details such as:

Commodity CodeCME Globex CodeProduct NameProduct… more