Login Page - Create Account

Support Board


Date/Time: Tue, 23 Apr 2024 11:48:17 +0000



Post From: Automated Trading

[2019-02-18 23:37:58]
Sawtooth - Posts: 3976
I would like to add conditions:
- the order should only be triggered if the opening is in the range high / low of the previous day
Add conditions to the formulas:
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.