This post details the use of the CQG function: Time Average (TimeAvg), which calculates the average for values taken at the same time of day over the lookback period.
In this example, the… more
Workspaces
CQG IC and QTrader offer charts that utilize volume for the horizontal scale, not time. The first chart type to discuss is Constant Volume Bars.
Constant Volume Bar (CVB)
The Constant… more
There are a number of volume-based studies available to customers using CQG IC or QTrader. This post walks you through the basic details of the various studies, then correlation analysis is… more
CQG IC and QTrader offer two studies that track volatility: Implied Volatility and Historical Volatility. This post details each study and provides an Excel spreadsheet for tracking the two.
… more
The Adaptive Moving Average (AMA) was developed by American quantitative financial analyst and author Perry J. Kaufman. The AMA study is like the exponential moving average (EMA), except the AMA… more
Certified stocks are bags of coffee that have been graded by the ICE exchange by ICE approved graders and are warehoused in exchange approved warehouses around the world. ICE reports the current… more
Technical analysts and technical based traders apply various studies to price data, such as a moving average, to smooth the price action. The goal is to filter the moment-to-moment price action,… more
Customers of BrokerTec can now trade the Relative Value (RV) Treasury Spreads. BrokerTec is the price discovery leader for benchmark cash U.S. Treasuries.
RV Curve offers 21 spreads. This… more
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