Thom Hartle

Microsoft® Office 365 includes the latest version of Excel which comes with some new functions not available in Excel 2016 or Excel 2019. This post details the XLOOKUP function and its features.… more

This post details how to use Excel’s Index and Matching function to extract data from a table. The example (downloadable sample at the bottom of the post) uses the 30 stocks in the DJIA as a… more

The CQG Statement Reports Add-In is installed with CQG IC and QTrader. This add-in works with CQG’s Statement Report generated from the Orders & Positions window.

Once you… more

Bollinger Bands are included in a group of studies that display price bands surrounding the trading activity.

Here is a list of the group of studies available in CQG:

If you are an analyst, blogger, or simply want to post a screen capture of an IC or QTrader chart on social media then the steps to copying a screen capture to your clipboard are very easy.

… more

The Portfolio monitor is a combination market quotes and study values display. In addition, the Portfolio monitor can display the status of conditions, such as a study has hit an overbought level… more

This Microsoft Excel® dashboard displays all of the JPX-traded Japanese Government Bonds (JGB) contracts including volume and open interest data.

The first three columns detail the… more

This Microsoft Excel® dashboard displays all of the JPX-traded Three-Month TONA contracts including volume and open interest data.

The first three columns detail the contract month… more

This Microsoft Excel® dashboard displays all of the ICE-traded Three-Month SARON contracts including volume and open interest data.

The first three columns detail the contract month… more

This study calculates the Market Profile’s value area and point of control (POC). First, a brief overview of the Market Profile chart then the Excel RTD formulas for MPVAPOC, MPVAHigh and the… more