Support Board
Date/Time: Wed, 27 Nov 2024 08:53:27 +0000
Any way to have the Initial Balance indicator start and stop at certain times?
View Count: 333
| [2023-09-06 22:34:09] |
| jackbravo - Posts: 69 |
|
Hello, I really like the initial balance indicator native in SC. However, I would like multiples IBs throughout the day. It gets confusing because each IB will print until the following period starts. However, I want (for example) a 5min IB every hour that starts at the beginning of the hour, and stops at the beginning of the hour, so it doesn't overlap the following IBs. Thanks. |
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: