Login Page - Create Account

Support Board


Date/Time: Sun, 16 Mar 2025 02:07:31 +0000



Post From: Auto-trading disabled and positions not flattening - Spreadsheet System for Trading

[2022-08-03 02:31:55]
Sawtooth - Posts: 4184
If you are using J85-J89, try this:

I prefer to use J28/J29 instead of J85-J89, and I set the Flatten time the same or later than the autotrading end time.
This is so that no new entry can happen after the flatten time.

This is accomplished by using a formula like this in J28:
=AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("06:35:00"),FRACTIME(J41)>TIMEVALUE("12:49:00")))

...and a formula like this in J29:
=FRACTIME(J41)>>TIMEVALUE("12:50:00")

The reference to J8 in J28 will disallow entries after 12:49, but allow exits after 12:49.