Support Board
Date/Time: Sun, 24 Nov 2024 07:43:33 +0000
Post From: Spreadsheet Trading System
| [2024-06-23 14:30:41] |
| User357489 - Posts: 72 |
|
For further reference, here are the 3 individual conditions I want to combine into one buy/sell entry formula: 1) =AND(AO3>0, E3>C4, DY3>DY4, EJ3>EJ4, EK3>EK4, FL3>FL4, EH3>0 2)=AND(ABS($J$8)=0, EA3<EA4, EH3<EH4, EJ3>EJ4, EK3>EK4, E3>C4, EH3>0, E3>C4,FL3>FL4, A3-INT(A3)>TIMEVALUE("08:30:00 3) =OR(AND(ABS($J$8)=0,CROSSFROMBELOW(AJ3:AJ4,AK3:AK4),E3>=AI3,EA3>0, A3-INT(A3)>TIMEVALUE("08:30:00"))) Where $J$8 is the 'position quantity' cell. I asked chat gpt to combine all 3 using =OR(AND as you answered in a previous support ticket, yet I feel this is where I went wrong as I'm not totally confident writing the formulas 'solo: |