Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 13:50:17 +0000

How to Post a Message for Support

Post From: ALERT FORMULA QUESTION

[2020-01-09 20:35:03]
[Go To First Post]
Sawtooth - Posts: 3992
Spreadsheet syntax is not the same as Simple Alert syntax. Row 4 is the previous bar on a spreadsheet study:
=AND(CG4<>0,CI4<>0,BX4<0,CB4>0,AB4<>0)

To include 3 previous bars:
=OR(AND(CG4<>0,CI4<>0,BX4<0,CB4>0,AB4<>0),AND(CG5<>0,CI5<>0,BX5<0,CB5>0,AB5<>0),AND(CG6<>0,CI6<>0,BX6<0,CB6>0,AB6<>0))