# Workspaces

#### 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

#### Excel Heat Mapping Using Check Boxes

###### Jun 06, 2024

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

###### Jun 03, 2024

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

###### 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