Workspaces

Thom Hartle
Jan 23, 2019
Updated: Jan 23, 2019

After the current trading session ends, many exchanges clear out today’s market data to set up for the preopening posting of orders to the exchange's order book. This includes today’s open, high, low, and close. In effect, the exchange moved... more

Thom Hartle
Dec 12, 2017
Updated: Dec 12, 2018

CQG offers a collection of conditions you can use to mark points on a chart when the condition is met. In addition, you can create your own custom conditions. You can easily bring conditions into Excel using RTD formulas. Excel displays a 1... more

Thom Hartle
Aug 25, 2017
Updated: Nov 08, 2018

These two Microsoft Excel® dashboard display market quotes for tradable UDS for the crude oil contract and the E-mini S&P 500 traded on Globex. There is also a quote display with at-the-money (ATM) calls and puts with one strike... more

Thom Hartle
Jun 18, 2018
Updated: Nov 08, 2018

This Microsoft Excel® dashboard presents two charts of the Nasdaq-100 futures contract and market data for the one hundred stocks that are constituents of the Nasdaq 100 Index.

The chart in the top left corner displays... more

Thom Hartle
May 03, 2017
Updated: Nov 06, 2018

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Guggenheim S&P 500® Equal Weight Technology ETF (symbol: RYT). This ETF seeks to replicate, before fees and expenses, the performance of the S&P 500® Equal Weight... more

Thom Hartle
Aug 03, 2016
Updated: Sep 25, 2018

This Microsoft Excel® dashboard offers a two-window view for tracking market performance (You have to enable macros when this dashboard is first opened.) The top half displays market data using whatever symbols (such as indices, stocks, and... more

Thom Hartle
Sep 07, 2012
Updated: Sep 14, 2018

This spreadsheet outlines the basic syntax of RTD formulas and then details more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your own spreadsheet.

*Requires Microsoft... more

Thom Hartle
Feb 01, 2013
Updated: Sep 14, 2018

To access the RTD feature in CQG Trader, please contact your FCM.

This dashboard allows you to change symbols as well as enter a value for the high-low alert (HLAlert). If the last price is within the value of the high or low prices, then... more

Thom Hartle
Feb 01, 2013
Updated: Sep 14, 2018

To access the RTD feature in CQG Trader, please contact your FCM.

This spreadsheet displays the RTD formulas needed to bring market data from CQG Trader into Microsoft Excel. Excel has a throttle that limits the amount of time between RTD... more

Thom Hartle
Feb 12, 2013
Updated: Sep 14, 2018

To access the RTD feature in CQG Trader, please contact your FCM.

This spreadsheet displays the current market data, last price, best bid, and best ask for three crude oil markets: Light Sweet Crude Oil traded on Globex, Brent Crude Oil... more