Support Board
Date/Time: Sun, 15 Jun 2025 17:06:10 +0000
Post From: Volume greater than previous range of bars
| [2025-05-28 14:20:23] |
| John - SC Support - Posts: 40422 |
|
What you are doing is specifically stated as something that will not work in the documentation you reference. It is the last paragraph that states the following: It needs to be understood that you cannot compare a range of individual values using a comparison operator to a single value. For example, this is not valid: =SG1[0:-10] > 100 . It inherently makes no sense because 11 different values cannot be compared to a single value. This requires an iteration which is not possible with Spreadsheet formulas.
What you can do is use the MAX() function to get the largest value of the last 10 bars and then compare that to the current bar. So your formula would be the following: =ID1.SG1 > MAX(ID1.SG1[-1:-10]) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |