Perhaps you are pulling market data into Microsoft Excel using RTD functions from CQG and you would like to chart the data in Excel. When you setup the chart you would likely use “Auto” for the high and low values for scaling the vertical axis.... more
Jan 19, 2021
Jun 08, 2017
This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S&P® Biotech ETF (symbol: XBI).
Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom... more
May 03, 2017
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
Jun 18, 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
Aug 16, 2017
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
Jul 27, 2017
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
Aug 06, 2020
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
Dec 12, 2017
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
Jul 28, 2020
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
Oct 23, 2017
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