Two recent posts CQG Primer: The Level Function and Level Function Using Excel RTD Formulas detailed using the Level function available in CQG IC and QTrader. The Level function plots two lines, which identify the highest and lowest levels attained over a defined period. The first post showed how filtering the Bollinger Bands Difference (BDif) study using the Level function created a study that provided a frame of reference for the current value of the BDif relative to the highest and lowest values in the last 20 periods. The second post provided a sample spreadsheet to pull historical values into a spreadsheet using RTD formulas.
This post offers a downloadable spreadsheet that is an Excel dashboard displaying the current market and study values of a portfolio of instruments.
The post Excel Conditions and Studies Dashboard provided an Excel dashboard for monitoring markets, study values and conditions. That same Excel dashboard has been updated to include the Bollinger Bands Difference (BDif) study and the Level function.
The left side of the dashboard lists the instruments and the pertinent market data.
The right side of the dashboard lists the studies and conditions.
Cell M2 is the Time Interval and cell M5 is the lookback period for the Bollinger Band Difference (BDif) study and the Level function.
Cell T2:T22:
=RTD("cqg.rtd",,"StudyData","BDIF("&$A2&",MAType:=Sim,Period1:="&$M$5&",Percent:=2.00,InputChoice:=Close)", "Bar",, "Close",$M$2,"0","All", "", "","True","T")
Cell U2:U22:
= RTD("cqg.rtd",,"StudyData","(BDIF("&$A2&",Sim,"&$M$5&",2.00)-LoLevel(BDIF("&$A2&",Sim,"&$M$5&",2.00),"&$M$5&",0))/(HiLevel(BDIF("&$A2&",Sim,"&$M$5&",2.00),"&$M$5&",0)-LoLevel(BDIF("&$A2&",Sim,"&$M$5&",2.00),"&$M$5&",0))", "Bar", "", "Close",$M$2,"0",,,,,"T")
Again, the Level function compares the ratio of the current study value minus the lowest study value divided by the highest study value minus the lowest study value. This ratio provides a frame of reference. A zero, which is highlighted green, indicates the lowest reading over the last 20 bars.
The two new studies do not require a CQG PAC to be installed. However, the TTM studies and conditions do require a CQG PAC.
Requirements: CQG Integrated Client or QTrader, and Excel 2016 (locally installed, not in the Cloud) or more recent.