Support Board
Date/Time: Tue, 26 Aug 2025 13:43:10 +0000
Post From: formula spreadsheet
| [2025-06-25 15:50:23] |
| John - SC Support - Posts: 41473 |
|
What do you mean by "add the condition"? If the exact formula you are entering is the following: =ID3.SG8>ID3.SG9 Then this will return a True/False result. That is, when ID3.SG8 is greater than ID3.SG9 then the result will be True, otherwise it will be False. If you want actually combine these, then you would need to use an IF() statement, like the following: =IF(ID3.SG8 > ID3.SG9, ID3.SG8 / -ID3.SG9, 0) Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#IF_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |