Support Board
Date/Time: Tue, 04 Mar 2025 11:35:47 +0000
Post From: Spreadsheet study. Sum of values with irregular row intervals.
| [2021-11-30 23:07:30] |
| John - SC Support - Posts: 38341 |
|
There are a few things in there that will not work in Sierra Chart. To begin with, the IF statement farthest to the right does not have a "Value if False" entry. It should look like IF(A1:A10,ROW(A1:A10),0). Also, within that IF statement, Sierra Chart does not evaluate A1:A10 as an equation to return a True/False value (in fact, I have no idea myself what exactly that does within an IF statement within Excel). Therefore, you would need to change that to whatever it is checking for. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |