Support Board

Date/Time: Fri, 26 Apr 2024 08:06:49 +0000

Post From: Canceling a limit order on spreadsheet trading

[2014-03-10 19:31:59] Link To Thread - Link To Post [Go To First Post]
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?