Support Board
Date/Time: Fri, 07 Feb 2025 18:13:09 +0000
Post From: Summation and Color bar based on alert condition issue
| [2022-03-24 22:20:13] |
| John - SC Support - Posts: 37828 |
|
The issue is that the data is changing within the current bar, but it is getting added to the summation before it changes. In the end, this is due to the fact that you are looking at a 1 trade chart, but there is a minimum value for the Chart Update Interval, so the values are not exact for the current bar since the studies have not all been updated at every tick. The solution is to look back by 1 bar so that the data for that previous bar has been properly updated when the Spreadsheet Formula is invoked for the current bar. To do this, you would need to change your formulas to look like the following: =IF(ID6.SG1[-1]>0,ID6.SG1[-1],0) Note that you do not need the "0+ID6.SG1", just having "ID6.SG1" is enough. The [-1] indicates to use the bar just before the last bar. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |