Login Page - Create Account

Technical Studies Reference


Multiply All Charts

This study calculates products across \(N\) open charts (up to \(200\)) 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)}\)

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

\(\displaystyle{\prod_{j = 1}^N O^{(j)}_t} = O^{(1)}_t \cdot O^{(2)}_t \cdot \cdots \cdot O^{(N)}_t\)

For an explanation of the Pi (\(\Pi\)) notation for multiplication, refer to our description here.

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.

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_All_Charts.287.scss


*Last modified Thursday, 17th October, 2019.