# Workspaces

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

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