Technical Studies Reference

Mutual Fund Bars

This study is used with Mutual Fund symbols. It calculates and displays new OHLC bars from the data.

Let \(C_t\) be the value of the Close Price at Index \(t\). Then we denote the Open, High, Low, and Close Prices for Mutual Fund Bars at Index \(t\) as \(O^{(MF)}_t\), \(H^{(MF)}_t\), \(L^{(MF)}_t\), \(C^{(MF)}_t\), and we compute them for \(t \geq 0\) as follows.

\(O^{(MF)}_t = C_{t - 1}\)

\(H^{(MF)}_t = \max\left\{C_t, O^{(MF)}_t\right\}\)

\(L^{(MF)}_t = \min\left\{C_t, O^{(MF)}_t\right\}\)

\(C^{(MF)}_t = C_t\)


  • This study has no Inputs.


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.


*Last modified Wednesday, 03rd January, 2018.