Workspaces

Thom Hartle
Aug 24, 2015

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

Thom Hartle
Aug 17, 2015

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
Jul 14, 2015

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
May 29, 2015

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
May 21, 2015

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 19, 2015

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

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
Apr 23, 2015

This Microsoft Excel® spreadsheet presents a 10-by-10 correlation matrix. In addition, a dynamically ranked view of the correlations from the 10-by-10 correlation matrix is displayed as histogram bars. The histogram bars are separated into the... more

Thom Hartle
Apr 20, 2015

This Microsoft Excel® dashboard looks for forty strikes above and below the ATM. Features also include a theoretical value column. If the current best bid is higher than the theoretical value, the best bid is highlighted green. If the best ask is... more

Thom Hartle
Apr 15, 2015

You can use Microsoft Excel® and data from CQG to expand the features of your own market display dashboards. This powerful combination can be tailored to your specific needs. This article shows you how to build an Excel dashboard and provides a... more