Workspaces

This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (symbol: DJIA).

Throughout the trading session, the thirty individual stocks are dynamically ranked and displayed in the histogram bar chart with their respective... more

CQG has added the USDA Crop Progress weekly report to the USDA data offering. This weekly report is very important to traders and analysts in the agricultural markets. Published during the growing season (April to November) the report details... more

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

Imagine that today the 20 day correlation between the E-mini S&P 500 futures contract (symbol: EP) and the Crude Oil Contract (symbol: CLE) is 0.82. Now, is that a typical value or an unusual value? To gauge the reading you would look at a... more

There are numerous Excel samples that walk you through bringing various market data into Excel using RTD formulas. However, there is a lot to look through. One solution is to use the CQG Formula Builder. You can right-click a study, hover your... more

This sample XLS Trader worksheet uses market orders to enter into positions. When filled, XLS Trader will automatically enter in a target and a stop order, which are OCO orders (one cancels the other). In addition, you can exit the open positions... more

This Microsoft Excel® dashboard provides a drop-down menu where you can select the underlying market, such as E-mini S&P 500. The display will then show all front contract option symbols, including weekly and end-of-month options. The... more

CQG has added the CFTC Commitment of Traders data to the data feed. You can read about working with COT symbols here.

If you are interested in pulling the latest COT updates and historical data using RTD formulas there are a couple of... more

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

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Invesco 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