Support Board
Date/Time: Mon, 25 Nov 2024 22:24:32 +0000
[User Discussion] - Canceling a limit order on spreadsheet trading
View Count: 1818
| [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] |
| |
|
1. Yes. You need to use this Spreadsheet cell: https://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#CancelWorkingOrders 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: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation 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] |
| Sawtooth - Posts: 4120 |
|
Try this in cell J27: =AND(J3<>0,J8=0,OR(K5,M5)) |
To post a message in this thread, you need to log in with your Sierra Chart account: