Workspaces

Thom Hartle
Mar 05, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet presents market data and forward curves of the Globex RBOB Gasoline contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterflies. The butterfly spread quotes use CQG's... more

Thom Hartle
Mar 12, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet offers a unique format where the current market data is displayed as borders around the chart information. The markets are heat-mapped based on percent net change. The heat-mapping is applied to the contract... more

Thom Hartle
Mar 19, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses RTD formulas to pull today's basic orders and positions information from CQG.

Orders and positions data available include:

Number of filled buy orders Number of filled sell orders Number... more
Thom Hartle
Mar 26, 2015
Updated: Sep 14, 2018

Options offer a wide variety of strategies for traders. CQG provides a powerful options analytics package. A number of the analytics tools, such as theoretical value, implied volatility, and the Greeks, provide market information that can be... more

Thom Hartle
Mar 30, 2015
Updated: Sep 14, 2018

If you use RTD formulas for data from the options markets, then Excel will pull data using your settings in CQG, such as the options model you have selected. An RTD formula for implied volatility will pull the Implied Volatility (IV) for the... more

Thom Hartle
May 21, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet is a dynamically ranked performance dashboard of the top and bottom twenty performing SPDR®​ ETFs traded on the NYSE exchange. One hundred and twenty-two ETFs are tracked throughout the trading day. The top... more

Thom Hartle
May 29, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet is an updated version of the CQG-Powered Excel Horizontal DOM Dashboard, which also includes a set of candlestick bars of today's performance for a portfolio of markets. The data is percentage adjusted, enabling... more

Thom Hartle
Jul 14, 2015
Updated: Sep 14, 2018

This spreadsheet allows you to pull historical data into Microsoft Excel® using RTD formulas. The sample spreadsheet pulls open, high, low, close, contract volume, contract open interest and one study, the RSI. The spreadsheet pulls up to 300... more

Thom Hartle
Aug 17, 2015
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays volume and open interest data for soybeans, soybean meal, and soybean oil contracts for tracking the rolls. All of the active deliveries for each individual symbol are displayed in a single dashboard... more

Thom Hartle
Aug 24, 2015
Updated: Sep 14, 2018

This spreadsheet shows you the RTD formulas for pulling historical data into Microsoft Excel® by using dates and time. The sample spreadsheet pulls the closing price and the value of the RSI study by a date and by a time during the day. Subminute... more