Support Board
Date/Time: Wed, 23 Apr 2025 07:07:23 +0000
Post From: Spreadsheet trading: allow J27 cancel orders outside J85 time window
| [2024-12-13 13:24:13] |
| Sawtooth - Posts: 4209 |
|
would you consider allowing working orders to be cancelled and position flatten dby J27 to take place even though trading is not permitted per the time constraints related to J85?
Solution: Use J28 instead of J85-J87, like this:=AND(J8 = 0, OR(FRACTIME(J41) < TIMEVALUE("09:30:00"), FRACTIME(J41) > TIMEVALUE("16:00:00"))) Referencing J8=0 will allow exit and cancellation autotrading beyond the end time, but disallow entries. Spreadsheet Example Formulas and Usage: Disable Autotrading Outside of Regular Trading Hours |