Support Board
Date/Time: Thu, 20 Mar 2025 00:00:44 +0000
Post From: Programming Spreadsheets - Exit/Entry Signal On Same Bar
| [2022-10-27 21:30:05] |
| GG - Posts: 20 |
|
Hey there, The system: opens one trade/day at 9:25 toward VWAP if it is within the 2nd standard deviation, closed by 9:35 (or cross of VWAP). The formulas: K3 =AND($J$53=0,ID0.SG4@3>ID5.SG9@3,ID0.SG4@3<ID5.SG1@3) L3 =CROSSFROMBELOW(E3:E4, ID5.SG1@3:ID5.SG1@4) M3 =AND($J$53=0,ID0.SG4@3>ID5.SG1@3,ID0.SG4@3<ID5.SG8@3) N3 =CROSSFROMABOVE(E3:E4, ID5.SG1@3:ID5.SG1@4) I28 =AND(J8 = 0, OR(FRACTIME(J41) < TIMEVALUE("09:25:00"), FRACTIME(J41) > TIMEVALUE("09:35:00"))) I29 =FRACTIME(J41) > TIMEVALUE("09:35:00") I85 =FALSE The problem: It doesn't enter half the time with error "Spreadsheet order has been ignored because Auto Trading has been disabled. (J28/85). J28 will read a 0 and the green/red arrow appears yet still no entry. TIA |