# Excel

#### Pulling Historical Settlement Data

###### Thom Hartle

A common request is an RTD formula to pull historical settlement prices for a particular market. There is a “Contract Data” RTD formula for settlement:

=RTD("CQG.RTD", ,"ContractData", "CLE", "Settlement",, "T")

However, “Contract... more

#### Pulling Historical Spread Data into Excel

###### Thom Hartle

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.

... more

###### Thom Hartle

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... more

#### ICE Long Gilt Algo Orders Tracker Dashboard

###### Thom Hartle

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this trading activity indicator detects and exposes hidden volume (iceberg orders) on the market.... more

#### Excel’s Dollar Fraction Function and RTD

###### Thom Hartle

When pulling a study value into Excel using RTD, you may not see the same value in Excel that you see on a chart. It is important that the RTD formula uses the same parameters as applied to the chart.

For example, in the chart we see the... more

#### Export Chart and Study Data to Excel

###### Thom Hartle

Request: What is the easiest way to get chart and study data from a chart into an Excel spreadsheet?

Solution: Simply right-click the chart area that has the market data and, at the bottom of the menu, click “Export to Excel... more

#### Add Symbols in All Contracts Window to Excel

###### Thom Hartle

Request: How can I get the symbols I see in the All Contracts Window into Excel? I cannot select the columns and copy and paste.

Solution: CQG offers an Excel RTD Add-in. There is a 64-bit Excel version and a 32-bit Excel version. Please... more

#### NASDAQ 10-Yr US Treasury Algo Orders Tracker Dashboard

###### Thom Hartle

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this indicator of trading activity detects and exposes hidden volume (iceberg orders) on the... more

#### Globex Crude Oil Algo Orders Tracker Dashboard

###### Thom Hartle

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this indicator of trading activity detects and exposes hidden volume (iceberg orders) on the... more

#### Globex Gold Algo Orders Tracker Dashboard

###### Thom Hartle

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this indicator of trading activity detects and exposes hidden volume (iceberg orders) on the... more