# Thom Hartle

## Today’s Synthetic Spread Time of High and Low Using RTD

CQG Integrated Client and CQG QTrader customers can pull the time the high and low occurred during today’s session into a Microsoft Excel® spreadsheet using these RTD formulas:

=RTD("CQG.RTD", ,"ContractData", "EP", "HighTime",, "T")... more

## Volume by Price in Excel

With the addition of the Footprint® Charts and Studies by MarketDelta to CQG Integrated Client and CQG QTrader, customers can pull volume data traded by price into Excel.

To pull in the data, we used the RTD formula:

=... more

## Eurodollar Options Volume Dashboard

This Microsoft Excel® dashboard scans the options on the Eurodollar futures market for volume and ranks the traded volume for each expiry out to three years. The scan covers options traded ten strikes above and below the at-the money option. Then... more

## Pulling Historical CVB Data into Excel

Pull historical CVB data into Microsoft Excel® using RTD formulas with this sample spreadsheet. It not only pulls open, high, low, and close values into Excel, but also a study, the Relative Strength Index.

To pull in the data,... more

## Pulling Historical Spread Data into Excel

Pull historical spread data into Microsoft Excel® using RTD formulas with this sample spreadsheet. It not only pulls open, high, low, and close values into Excel, but also a study, the simple moving average of the spread.

To pull... more

## Delta Bar Chart and Excel

This Microsoft Excel® dashboard uses RTD formulas to pull in market data based on a new CQG chart type called Delta Bar. Delta Bar is similar to the Constant Volume chart type except instead of a user-set amount of executed volume to determine... more

## Mark Fisher Indicator

Mark B. Fisher, founder and CEO of MBF Clearing Corp, discussed his chart and study during a joint webinar with CQG. This article further explains the study and chart type, available in CQG, as well as Mark Fisher’s trading bands that are... more

## Spread Analysis Dashboard

This Microsoft Excel® dashboard offers four charts displaying seventy-five open, high, low, and close bars of a spread. The spread symbols are entered into Excel on the symbols tab and the time frame is set for the charts. The RTD formulas use... more

## Apply Studies to Different Chart Types

The Microsoft Excel® RTD Studies sample offers a collection of RTD CQG study formulas applied to the Bar chart type. If you want to use other chart types, such as no gap or constant volume bars, then the solution is to include the chart type in... more

## S&P 500® and NASDAQ 100® Performance Dashboard

This Microsoft Excel® dashboard offers a two-window view for tracking market performance. The top half displays market data using symbols such as indices, stocks and futures that the user enters on the symbols tab. The bottom half has four stock... more