Support Board
Date/Time: Mon, 16 Jun 2025 01:05:20 +0000
Spreadsheet trading issue with working orders
View Count: 221
| [2025-05-14 12:02:20] |
| User427421 - Posts: 45 |
|
I am having an issues with a spreadsheet system for trading study. Sometimes orders get stuck but I selected the option that says "Allow entry with working orders"=Yes and I still get this error: 2025-05-14 07:55:33.395 | Auto-trade: MNQM5.CME[M] 15 Sec #1 | 2025 BOT 1.1 | SellEntry | Bar start date-time: 2025-05-14 07:55:30.000 | SellEntry signal is ignored because Long position quantity or working Buy order exists. Position with working orders quantity: 4 Any way to work around this? |
| [2025-05-14 15:27:33] |
| John - SC Support - Posts: 40422 |
|
The Spreadsheet System for Trading is setup so that you are either going to exit a position using the working orders or you are going to do it through the Exit cell. It does not allow for both directly. That is, you can not have working orders and then have the "Buy Exit" be true and closed out the position that way. To work around this, you would need to cancel the working orders first, and then use the "Buy/Sell Exit" cell. There is an entry in the I/J columns for "Cancel Working Orders". You can use the same logic you use for the "Buy/Sell Exit" and then modify your exit cell by adding a test that checks if the "Cancel Working Orders" is non-zero. This way, the working orders will get cancelled and then the next calculation for the spreadsheet will perform the exit. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: