Workspaces

Thom Hartle
Jun 12, 2019
Updated: Jun 12, 2019

Customers using our flagship product, CQG Integrated Client (CQG IC) or QTrader, 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... more

Thom Hartle
Jun 12, 2019
Updated: Jun 12, 2019

Customers using our flagship product, CQG Integrated Client (CQG IC) or QTrader, 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... more

Thom Hartle
Jun 12, 2019
Updated: Jun 12, 2019

Customers using our flagship product, CQG Integrated Client (CQG IC) or QTrader, 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... more

Thom Hartle
Jul 25, 2016
Updated: Jun 12, 2019

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

Thom Hartle
May 19, 2015
Updated: May 15, 2019

This Microsoft Excel® dashboard uses the CQG RTD OptVal formula to calculate implied volatility, theoretical value, delta, and the Greeks using data inputs from other RTD formulas.

For example, the implied volatility calculation is... more

Thom Hartle
May 04, 2015
Updated: May 15, 2019

This Microsoft Excel® dashboard offers an automatic performance ranking of exchange-traded funds (ETFs) that is focused on equity performance by country. This dashboard requires the NYSE enablement.

The top symbol row automatically... more

Thom Hartle
Jan 20, 2015
Updated: Apr 16, 2019

These two Microsoft Excel® spreadsheets present market data and forward curves of the Globex Crude Light Oil and ICE Brent Crude Oil contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterfly spreads for... more

Thom Hartle
May 08, 2017
Updated: Apr 15, 2019

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Core S&P U.S. Growth ETF (symbol: IUSG). The iShares Core S&P U.S. Growth ETF seeks to track the investment results of an index composed of large- and mid-... more

Thom Hartle
Nov 21, 2017
Updated: Apr 01, 2019

You can use LocalHour and LocalMinute functions in the RTD formula to pull in the open price for a market using a 5-minute bar at 12:00. This technique was detailed in a previous article here.

If you are pulling in a large amount... more

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