Login Page - Create Account

Technical Studies Reference


Multiply Charts - Bar

This study calculates products across two open charts for the following variables.

  • Open Price \(O\)
  • High Price \(H\)
  • Low Price \(L\)
  • Close Price \(C\)
  • Volume \(V\)
  • Open Interest \(OI\)
  • Open Price \(O\)
  • OHLC Average Price \(\overline{P}^{(OHLC)}\)
  • HLC Average Price \(\overline{P}^{(HLC)}\)
  • HL Average Price \(\overline{P}^{(HL)}\)
  • Bid Volume \(V^{(Bid)}\)
  • Bid Volume \(V^{(Ask)}\)

Chart 1 is the chart to which the Multiply Charts - Bar is applied, and Chart 2 is the chart specified by the Chart 2 Number Input.

Let the Inputs Chart 1 Multiplier and Chart 2 Multiplier be denoted as \(v_1\) and \(v_2\), respectively. Then we multiply each variable from Chart 1 by \(v_1\) and each variable from Chart 2 by \(v_2\), then we multiply the results together at each value of the Index \(t\).

For example, let the Open Price at Index \(t\) for the two charts be denoted as \(O^{(1)}_t\) and \(O^{(2)}_t\). We compute the product of these at Index \(t\) as follows.

\(v_1O^{(1)}_t \cdot v_2O^{(2)}_t\)

The Index matching across the charts is done via the ACSIL Function sc.GetNearestMatchForDateTimeIndex().

By default, only the products for the Open, High, Low, and Close Prices are displayed (via OHLC bars). The products for the other variables are not displayed, but they are calculated and can be accessed via a Spreadsheet Study.

Inputs

  • Chart 2 Number: A custom Input by which one can specify which chart is to be considered Chart 2 for the purposes of computing products. This is chart is not necessarily Chart #2 as numbered by Sierra Chart.
  • Chart 1 Multiplier
  • Chart 2 Multiplier

Spreadsheet

The spreadsheet below contains the formulas for this study in Spreadsheet format. Only the products for \(O\), \(H\), \(L\), and \(C\) were tested. Save this Spreadsheet to the Data Files Folder.

Open it through File >> Open Spreadsheet.

Multiply_Charts_-_Bar.268.scss


*Last modified Wednesday, 01st May, 2019.