Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 14:41:40 +0000



Post From: active formula depend on difference between bars

[2023-07-26 09:51:15]
User278398 - Posts: 291
i have "spreadsheet formula"(id3) study which active when there is interaction between 2 lines (the blue and the red in the pic), =if(crossover(id1.sg1,id2.sg1),1,0)
....
how can i change the above formula or had another "spreadsheet formula" study which depend on id3 that will be active only if
the last active of id3 was in range that more then 40 bars?

at 11:28:10 will work(the last active was at 11:27:04, and between those two activion there is 66 bars)
at 11:30:12 will work(the last active was at 11:28:50, and between those two activion there is 82 bars)

regards
image121212.png / V - Attached On 2023-07-26 09:44:23 UTC - Size: 182.61 KB - 89 views
Attachment Deleted.