# Workspaces

#### Globex Crude Oil Options Volume Dashboard

###### Dec 29, 2016

This Microsoft Excel® dashboard scans the crude oil (GLOBEX) futures market options for volume and ranks the traded volume for each expiry out to sixteen months. The scan covers options traded ten strikes above and below the at-the... more

#### Pulling Historical Settlement Data

###### Dec 20, 2016

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

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

###### Dec 06, 2016

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

#### Volume by Price in Excel

###### Nov 28, 2016

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:

=RTD("... more

#### Eurodollar Options Volume Dashboard

###### Nov 23, 2016

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

###### Nov 21, 2016

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

#### Pulling Historical Spread Data into Excel

###### Nov 17, 2016

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

#### SPDR Sector ETF Holdings

###### Nov 08, 2016

The component pac at the end of this article contains holdings or components of eleven SPDR ETF portfolios. You can use a portfolio to create a quote page with a link to a chart.

You can also ... more

#### Delta Bar Chart and Excel

###### Nov 03, 2016

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

#### Mark Fisher Indicator

###### Nov 03, 2016

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