Support Board
Date/Time: Thu, 20 Feb 2025 19:24:16 +0000
Spreadsheet trading: allow J27 cancel orders outside J85 time window
View Count: 85
| [2024-12-13 00:23:14] |
| User745789 - Posts: 365 |
|
This is a long shot, but 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? Use case: J85 restricts entry or orders to a certain time in the AM. Then no new orders are allowed. Then J27 cancels any unfilled orders and flattens in PM. Cancelling working orders isn't really "trading". And currently, it is not possible to use J27 if there are J85 constraints in place. Considering the proposed changes in this recent thread (FLatten and Cancel at Set Time), then the limitations placed by J85 in cancelling orders is troublesome. Date Time Of Last Edit: 2024-12-13 10:32:02
|
| [2024-12-13 13:24:13] |
| Sawtooth - Posts: 4173 |
|
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: