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
Workspaces
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
This post details two pages with a general overview of the agriculture markets. These pages are to help you navigate all the possible underlying contracts and data points you may or may not know… 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:
Bollinger… moreIf 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