Support Board
Date/Time: Fri, 29 Nov 2024 14:54:32 +0000
stats
View Count: 349
| [2023-02-06 19:14:47] |
| coachted - Posts: 329 |
|
I am looking to calculate the initial balance vs the past 30 trading day initial balance...i would like to create an text and an alert if the IB is narrower or equal/or larger compared to the past rolling 30 trading days....is there a way to do this???? I also want to do the same thing via the full session range of a product...is this possible.... |
| [2023-02-06 23:14:25] |
| John - SC Support - Posts: 36350 |
|
You would need to use the Spreadsheet Study in order to get the Initial Balance information for each day by looking for a specific time and then pulling the data out at that time. You can then use the MOSTRECENTNONZEROVALUE() function to gather up the data at the top of a column and then you can create your average from that information.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-02-07 15:29:15] |
| coachted - Posts: 329 |
|
so i have a seperate Crude Oil chart...it is a 60 min chart...I use this to get the IB... i then have a subgraph of this IB plotting it the difference from the ib low and the ib high to get the IB range...I then have another subgraph on the to get a ratio to find out where the ib range is today in relation to a simple moving average...the reason i tell you this is I dont know if it would be more accurate running an ATR on the IB range or the simpe moving average to measure the current IB range vs historical...but when i run I run an ATR on the 1st subgraph i get a reading of .33 vs the simple moving 1.06 please advise Date Time Of Last Edit: 2023-02-07 15:34:18
|
| [2023-02-07 17:28:03] |
| John - SC Support - Posts: 36350 |
|
You have to keep in mind that there are zeros everywhere that the IB is not displayed, so depending on how you have the data, you have to be careful with what you are doing. That is one of the reasons we recommend the Spreadsheet with the MOSTRECENTNONZEROVALUE() function, as it is a way to bring all the data from the specific timeframe together so there are no missing pieces. Or you can use ACSIL to do all the necessary calculations and to access the data: Advanced Custom Study Interface and Language (ACSIL): Introduction You can use the Initial Balance study to calculate the values you need. 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: