The Excel MAXIF function returns the maximum value from a range of cells and a criteria range. For example. The downloadable sample at the bottom of this post is determining the best performance… more
Excel
The Moving Average Convergence/Divergence indicator (MACD) was invented by Gerald Appel over 40 years ago. The study is an unbounded oscillator with two lines: MACD and MACDA.
MACD =… more
This posts details the use of two Excel functions: AVERAGEIFS and COUNTIFS. To start, a simple example of using the AVERAGEIFS function is presented.
In the image below column cells A2:A10… more
CQG IC and QTrader offer the ability to set recalculation rates for studies. In addition, RTD study formulas have a recalculation rate parameter.
In CQG select a chart and then Setup/Chart… more
CQG offers institutional pricing data across 430+ currency pairs of market data. Sourced directly from tier-1 banks and non-bank market makers worldwide, the feed provides up to 50 years of… more
The CME Website has information resources for options traders in the form of downloadable Excel tables with important needed details such as:
Commodity CodeCME Globex CodeProduct NameProduct… more
The CQG Rank Study ranks the individual chart points of a market over a specified number of previous trading periods. For example, if the current bar's close had a rank of 3, and the periods were… more
The Klinger Volume Oscillator (KVO) was developed by Stephen Klinger. The study uses the difference between two exponential smoothed moving averages (EMA) of the "Volume Force" and includes a… more
The Kalman Filter is a recursive algorithm invented in the 1960s to track a moving target from noisy measurements of its position and predict its future position. The Kalman filter is an optimal… more
A popular form of market analysis is to maintain a real-time table of market performance based on an annualized basis. For example, the QSS 2.0 displayed below has a sorted column highlighted with… more