This spreadsheet study will plot a composite candle underneath n bars, combining the OHLC of those bars. Each composite bar is colored based on whether it closed up or down, allowing the user to determine its OHLC values.
This is a self-contained standalone study that does not reference any other study, and it works on all Intrabar bar types, except on most renko bars. It also works on Historical bars but the starting bar is random.
The user can choose the number of bars to use to create the composite bar by a setting in cell J2 on the spreadsheet. The study uses the Chart Setting's Session Start Time as the first bar to use when building the composite bars.
Click on each of these links to download:
Composite Bar Underlay.StdyCollct+
Composite Bar Underlay.scss
and put both files in your Sierra Chart \Data folder.
The study collection will load the correct spreadsheet study with the correct settings. You must use the study collection to add this study to a chart.
The spreadsheet file contains the formulas; you must download both files.
This study was created on Chart 1. If you add this study to a chart other than Chart 1, you must copy/paste cells J1:J2 from Sheet1 to the Sheet# that corresponds to the Chart# where this study is added. You then must use the J2 setting on that new Sheet#.
6/21/2023 v1b Updated to accommodate Evening Session Times