Home >> (Table of Contents) Studies and Indicators >> Technical Studies Reference >> Multiply All Charts
Technical Studies Reference
- Technical Studies Reference
- Common Study Inputs (Opens a new page)
- Using Studies (Opens a new page)
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.
*Last modified Wednesday, 28th September, 2022.