Support Board

Date/Time: Sat, 18 May 2024 07:14:36 +0000

Post From: If Condition is met, then enter position if other condition is met

[2018-04-29 18:29:17] Link To Thread - Link To Post [Go To First Post]
User172040 - Posts: 70
Hi, I'm learning the spreadsheet study and trying to refine my testing. In essence I want the K3 column (Buy Entry) to trigger a 1 when the following condition is met: =AND(ABS($J$8)=0,AH3>AF3,AL3>AJ3,D3<=AC3) (This part is already working) But in order to refine it, I want only to trigger a buy order when the above condition is true and then after this condition has been met the system should trigger a long when the 5MA cross the 9MA of my entry chart. I tried to make use of a IF statement but get a ARGS! error. Here's the code I used: =IF(AND(ABS($J$8)=0,AH3>AF3,AL3>AJ3,D3<=AC3),CROSSFROMBELOW(AN3:AN4,AO3:AO4)) -- (AN = 5MA & AO = 9MA) That's obviously not right. Can you kindly guide me in the right direction?