Support Board

Date/Time: Sat, 11 May 2024 11:54:57 +0000

Post From: Spreadsheet, formula including all session bars

[2024-02-18 21:20:24] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3995
=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.