Login Page - Create Account

Technical Studies Reference


Sum - 3 Chart

This study calculates the sums of corresponding variables of three charts. Refer to the Multiple Chart Studies description for instructions to use this study.

Let \(X_t^{(1)}\), \(X_t^{(2)}\), and \(X_t^{(3)}\) denote the value of any chart variable (listed below) at Index \(t\) of Chart 1, Chart 2, and Chart 3, respectively. Chart 1 (aka the Source Chart) is always the chart to which the Sum (Bar) study is applied, and Charts 2 and 3 (aka the Destination Charts) are the charts specified by the Chart 2 Number and Chart 3 Number Inputs, respectively. \(X_t^{(1)}\), \(X_t^{(2)}\), and \(X_t^{(3)}\) can represent any of the following variables.

  • Open
  • High
  • Low
  • Last
  • Volume
  • Number of Trades / Open Interest
  • OHLC Avg
  • HLC Avg
  • HL Avg

Let \(v_1\), \(v_2\), and \(v_3\) denote the Inputs Chart 1 Multiplier, Chart 2 Multiplier, and Chart 3 Multiplier respectively. Then the Sum - 3 Chart study calculates the following sums.

\(\displaystyle{v_1 \cdot X_t^{(1)} + v_2 \cdot X_t^{(2)} + v_3 \cdot X_t^{(3)}}\)

The sums are displayed only for Open, High, Low, and Close. These are displayed in the form of OHLC Bars by default, and the price graph draw type can be changed through the Graph Draw Type setting in the Study Settings window for the study.

When corresponding bars in the three charts do not match in both date and time, then this study uses the sc.GetNearestMatchForDateTimeIndex() to find a match.

Inputs

Spreadsheet

The spreadsheet below contains the formulas for this study in Spreadsheet format. Save this Spreadsheet to the Data Files Folder.

Open it through File >> Open Spreadsheet.

Sum_3_Chart.405.scss


*Last modified Friday, 27th December, 2019.