Support Board
Date/Time: Sun, 08 Jun 2025 00:36:25 +0000
Post From: Spreadsheet formula efficiency
| [2023-02-18 20:41:37] |
| Sierra_Chart Engineering - Posts: 19860 |
|
Regarding what is optimal: `AND` or `SUM`. If the values in O3:R3 are in fact boolean values (0 is false and non-zero is true) then the code `=IF(AND(O3=1,P3=1,Q3=1,R=1,S3=1),1,0)` can be optimized further: `=IF(AND(O3,P3,Q3,R3,S3),1,0)` because the `boolean` values are stored as a numerical (double) and can be used interchangable. It reduced computation time by means of ommiting comparison operation (`=`). Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2023-02-18 20:41:43
|