Login Page - Create Account

Support Board

Date/Time: Sun, 26 Jun 2022 23:13:35 +0000

[User Discussion] - Canceling a limit order on spreadsheet trading

View Count: 1099

[2014-03-10 19:31:59]
HeavyMike - Posts: 25
On my spreadsheet, I have signal on bar close to buy limit at a certain price. However, I want it to cancel that limit order if the next bar closes without filling it. The problem I'm having now is that the limit order never hits (as the price keeps going up) and then with the prices eventually falls, on the way down my limit order hits (and now I'm buying long in a down market). The question may be broken up in two parts, 1) Can I cancel a limit order somehow? 2) can I put a condition to cancel based on the completion of the next bar?
[2014-03-14 04:00:42]
Sierra Chart Engineering - Posts: 103466
1. Yes. You need to use this Spreadsheet cell:

2. This is outside the scope of our support.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2014-03-14 12:57:30]
tomgilb - Posts: 3325
Try this in cell J27:


To post a message in this thread, you need to log in with your Sierra Chart account:


Login Page - Create Account