Support Board
Date/Time: Wed, 27 Nov 2024 08:35:59 +0000
Post From: Any way to have the Initial Balance indicator start and stop at certain times?
| [2023-09-07 14:13:55] |
| John - SC Support - Posts: 36309 |
|
If we are understanding this correctly, you want to have a 5 minute Initial Balance every hour and you only want each Initial Balance to display across that one hour. In this case, you will need to setup your Initial Balance studies and then use the Spreadsheet study to control the display of each line. You can do this by first using the "MOSTRECENTNONZEROVALUE() function to get the Initial Balance values for the particular time period for each day and then using an IF statement and referencing the hour. For example, to display the midline of an Initial Balance study that has Study ID 1, from 09:00 to 09:59, you would enter the following in cell K3: =MOSTRECENTNONZEROVALUE(ID1.SG8@$3:ID1.SG8@$2000) And then enter the following in Cell L3: =IF(HOUR(A3) = 9, K3, 0) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |