This post "TTM Squeeze Indicator" detailed the TTM indicator, which is a combination of measuring volatility and momentum. The volatility is a condition where the Bollinger Bands contract and move within the Kelter Channels. The momentum indicator (histogram bars) is the momentum study smoothed using the moving linear regression study. When the "Squeeze" condition is true dots are placed either above or below the histogram bars as seen in the image below.
The idea is trends usually start following a congestion or sideways price action, which is referred to as the "Squeeze". This post describes how to pull the study and condition formulas into Excel using RTD calls.
The sample Excel spreadsheet is available at the bottom of the post, along with the CQG PAC for the custom study and condition.
All of the RTD formulas use cell Q2 through Q12 for the market symbol, time frame, etc.
This table lists the RTD formulas used in the columns beginning with H2 and are copied down:
H2 (MA):
= RTD("cqg.rtd",,"StudyData", "MA("&$Q$2&",MAType:=Sim,Period:=20,InputChoice:=Close)", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)I2 (BB High):
= RTD("cqg.rtd",,"StudyData", "BHI("&$Q$2&",MAType:=Sim,Period1:=20,Percent:=2.00,Divisor:=0,InputChoice:=Close)", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)J2 (BB Low):
= RTD("cqg.rtd",,"StudyData", "BLO("&$Q$2&",MAType:=Sim,Period1:=20,Percent:=2.00,Divisor:=0,InputChoice:=Close)", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)K2 (KC High):
= RTD("cqg.rtd",,"StudyData", "KHi("&$Q$2&",MAType:=Sim,Period:=20,MAType1:=Sim,Percent:=150,InputChoice:=Close) ", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)L2 (KC Low):
= RTD("cqg.rtd",,"StudyData", "KLo("&$Q$2&",MAType:=Sim,Period:=20,MAType1:=Sim,Percent:=150,InputChoice:=Close) ", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)Columns M and N are conditions and start with "B.". Pos indicates the "Squeeze" is on and the momentum indicator is positive. Neg indicates the "Squeeze" is on and the momentum indicator is negative.
M2 (TTM Squeeze Pos):
= RTD("cqg.rtd",,"StudyData", "B.TTMSqueeze_BK_Pos_Osc("&$Q$2&",20,2,20,150,5,15)", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)N2 (TTM Squeeze Neg):
= RTD("cqg.rtd",,"StudyData", "B.TTMSqueeze_BK_Neg_Osc("&$Q$2&",20,2,20,150,5,15)", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)This is the RTD formula for the custom momentum indicator:
O2 (TTMSqBBKC):
= RTD("cqg.rtd",,"StudyData", "MLR(Mom("&$Q$2&",Period:=15,InputChoice:=Close),Period:=5,InputChoice:=Close)", "Bar",, "Close",$Q$4,-A2,$Q$6, "", "",$Q$8,$Q$12)Columns M and N are conditionally formatted to color cells green for the Positive Squeeze and red for the Negative Squeeze,
Technical indicators that can signal a trend following a congestion or sideways price action may be of value for generating trading ideas. Backtesting this idea could be worthwhile.
Requirements: CQG Integrated Client or QTrader, and Excel 2016 (locally installed, not in the Cloud) or more recent.