Support Board
Date/Time: Sun, 19 Jan 2025 21:49:39 +0000
Post From: If Condition is met, then enter position if other condition is met
[2018-04-29 18:29:17] |
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? |