Support Board
Date/Time: Tue, 04 Nov 2025 11:05:46 +0000
Post From: Automated Trading
| [2019-02-18 23:37:58] |
| Sawtooth - Posts: 4285 |
|
I would like to add conditions:
Add conditions to the formulas:- the order should only be triggered if the opening is in the range high / low of the previous day K3: =AND(AC3<=E3+2,opening<rangehigh,opening>rangelow) M3: =AND(=AB3<=E3-2,opening<rangehigh,opening>rangelow) - that only on the first arrival of the condition (once low, once high) is triggered.
Put the entry formulas in a Formula Column where you can create a persistent variable of the entry, then in K3/M3 find the transitions. Here is an example:Spreadsheet Example Formulas and Usage: Buy on First Signal and Ignore Multiple Signals I noticed that the function "Flatten positions & cancel orders in time" (J88, J89) gets from (my) system prio 1.
Don't use J85 to J89. Instead, do this:-Use a formula like this in J28: =AND(J8 = 0, OR(FRACTIME(J41) < TIMEVALUE("09:30:00"), FRACTIME(J41) > TIMEVALUE("16:00:00"))) This will allow exits/flattening after autotrading entries are disabled. -Then use a formula like this in J29: =FRACTIME(J41) > TIMEVALUE("16:14:00") The time in J29 should be later than the end time in J28. |