Support Board
Date/Time: Tue, 26 Aug 2025 13:40:40 +0000
formula spreadsheet
View Count: 119
| [2025-06-25 13:54:41] |
| User220939 - Posts: 54 |
|
Hi, I created a spreadsheet study which calculates the ratio between the max and min delta and the formula works well. I want to add a condition so that the calculation is only done when the max delta is greater than the min delta. and that doesn't work, it erases all the calculations for me. Can you help me? Thanks |
| [2025-06-25 14:58:15] |
| John - SC Support - Posts: 41473 |
|
What is the formula that you have entered for this?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-06-25 15:06:34] |
| User220939 - Posts: 54 |
|
ID3.SG8/-ID3.SG9 it's ok and when I add the condition ID3.SG8>ID3.SG9 it doesn't work anymore |
| [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 |
| [2025-06-25 16:04:51] |
| User220939 - Posts: 54 |
|
it works thank you very much
|
To post a message in this thread, you need to log in with your Sierra Chart account: