# CQG PAC Files

#### Dynamically-Updated Volatility Excel Dashboard

This Microsoft Excel dashboard measures volatility by using the difference between the upper and lower Bollinger Bands and dividing the difference by the Moving Average. The dashboard then sorts… more

#### First and Last Hour Traded Volume Excel(R) Dashboard

This Microsoft Excel dashboard is used to track the performance of a collection of Exchange-Traded Funds (ETFs).

The market information displayed is the last price, net change, the… more

#### Labels

CQG's market data information breaks down into two types of data: One is study data that can be seen on a chart, such as the high of a market from last week. The other is a label data, which is… more

#### Measuring Price Movements

In this article, we measure the price action between a significant high and a significant low identified by CQG's ZigZag study. The ZigZag study is a useful graphical tool that connects… more

#### Seasonal Analytics

This short article is not a huge programming exercise, it is mainly about a smart way to see seasonal behavior in an overlay chart. Here is the result we would like to have:

The… more

#### Auto Fibonacci Retracements, Part 1

Derived from contributions medieval mathematician Leonardo Fibonacci made to number theory, retracements measure the price areas where a market move is likely to pause or reverse a trend. Many… more

#### Smart Pyramiding

If we look more closely into trend-following trading systems, sometimes the percentage of winning trades is only slightly above 50%, but the trading system still creates some nice and profitable… more

#### ATR-Based Quantity and Risk

The Average True Range (ATR) study takes the moving average of the true range over the specified period.

Definitions:

True Range = True High - True Low True High = The greater of the… more

#### Correlation and Relative Performance

The Correlation function in the CQG toolbox correlates the price movement of two symbols over a defined number of bars. For example, CORREL(CL,QO,10) will return the correlation between West Texas… more

#### Using the Super Template

Some of the work traders do in building trading systems can be very creative and exciting, but unfortunately some of the work is not. In most cases, traders have a specific idea in mind that they… more