Support Board
Date/Time: Tue, 21 May 2024 03:19:29 +0000
Post From: False positives using IF statement
[2020-03-05 21:20:58] |
tommartin321 - Posts: 74 |
Hello, I'm getting some random false positives from my IF statement below. I want the statement to put a 1 in column if the bar Open is < the three EMA's (ID11, ID12, ID15). And the opposite should produce a -1. However, about 95% of the signals are correct, but every now and then, a false signal appears. See example in attached screenshot. =IF(AND(B3<ID11.SG1@3,B3<ID12.SG1@3,B3<ID15.SG1@3),1,IF(AND(B3>ID11.SG1@3,B3>ID12.SG1@3,B3>ID15.SG1@3),-1,U4)) Thank you, Tom |
EMA5_8_13.png / V - Attached On 2020-03-05 21:19:40 UTC - Size: 20.86 KB - 171 views |