Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sat, 01 Nov 2025 18:13:50 +0000

Post From: False positives using IF statement

[2020-03-05 21:20:58] Link To Thread - Link To Post [Go To First Post]
tommartin321 - Posts: 77
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
0x Thank you
EMA5_8_13.png / V - Attached On 2020-03-05 21:19:40 UTC - Size: 20.86 KB - 232 views