Support Board
Date/Time: Fri, 29 Nov 2024 08:37:26 +0000
Post From: Initial balance location
| [2023-02-28 23:24:29] |
| John - SC Support - Posts: 36350 |
|
We assume that what you mean is that you want to have the Initial Balance display across the entire day's bars. To do this, you will need to add the Spreadsheet Study to your chart and then in cell K3 put in the following: =MOSTRECENTNONZEROVALUE(AA3:AA1000) And in cell L3 put the following: =MOSTRECENTNONZEROVALUE(AB3:AB1000) Where AA and AB are the columns that contain the High/Low for Time Period study subgraphs (you will have to change this for your situation). Then set the Spreadsheet Study to be in Region 1, and set the Draw Style for the K and L columns to Dash and set the colors as you want. Then set the High/Low for Time Period study to be Hidden (enable the Hide option on the settings window). The one thing that you might have to do is to increase the Number of Rows on the Spreadsheet Study in order to cover the amount of data you have in the chart. You will want the Number of Rows that you set to match the ending range in the MOSTRECENTNONZEROVALUE() function. For example, if you change the number of rows to 5000, then you will need to change the ending range in the MOSTRECENTNONZEROVALUE() to be AA5000 (or AB5000). For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |