Support Board
Date/Time: Mon, 25 Nov 2024 07:49:48 +0000
Post From: Spreadsheet, formula including all session bars
| [2024-02-18 21:20:24] |
| Sawtooth - Posts: 4120 |
|
=IF() is not a supported function
The IF function is supported in both Alert syntax and spreadsheet syntax.what I want to do is when the price has not touched two pivot points R1 and R2 (only one is possible) for example, it draws me a line at X% of point R1, but if the price touched R1 AND R2 it draws me a line at Y% of R1 and this in the session only.
- You would need to create a persistent variable when price has not yet touched R1 and R2.- Then release it and create another persistent variable when price has touched both R1 and R2. - Once the formulas return values, use another spreadsheet column to limit their display to the session times. Here are some formula examples of persistent variables: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Notice that one IF starts the persistence, and a second IF releases it. |