Support Board
Date/Time: Sat, 21 Dec 2024 18:39:52 +0000
[User Discussion] - Resetting Conditions in L3 after working orders are cancelled.
View Count: 1157
| [2015-07-27 06:29:10] |
| CMG - Posts: 179 |
|
Hi There, In a spreadsheet for trading how can I reset conditions on L3 after working orders are cancelled by a non cero value on J27 (Cancel Working Orders) -I have "signal only once per bar" set to "NO" and "reset conditions on new bar" set to "YES". -L3 has a formula that places a limit order. The following all occur in the same bar: When conditions are met in L3, the spreadsheet is placing the limit order and in some occasions before this order is filled, a condition in J27 becomes non zero and cancels the open limit order. These situations are all correct and meant to be. However, when J27 becomes zero again, no new orders are being sent by L3 even though L3 is still true and signal only once per bar is set to "NO". It only sends a new order when there is a new bar. The question is how to reset conditions on L3 after cancellation of orders in the same bar. Thanks |
| [2015-07-27 10:00:49] |
| |
|
Inherently these kinds of things are hard to do in Spreadsheets. Not sure this would help but we can add a cell indicating that there are working orders. It will be FALSE when there are not.
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 |
| [2015-07-27 13:35:04] |
| Sawtooth - Posts: 4141 |
|
Not sure this would help but we can add a cell indicating that there are working orders.
I've used J3 or J4 for this purpose.L3 will reset intrabar if it goes FALSE. Try something like this: =AND(YourExitConditions,$J$4=0) Or if you have an existing OCO bracket order, but you want to exit with a formula: =AND(YourExitConditions,-$J$3=$J$8) |
To post a message in this thread, you need to log in with your Sierra Chart account: