Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 17:52:02 +0000



Cancel queued limit order and send new order when second trigger happened

View Count: 193

[2024-05-20 14:38:39]
AzharBasri - Posts: 28
Hi,

I'm using spreadsheet for trading and using limit order when K3 and M3 became TRUE.
How can I cancel the existing order triggered on the first signal and send another limit order at a new level when the second trigger occur?

I already have a formula to cancel working order using J27 for another situation. Can I use the same logic to cancel?

Should I enable J59 or J62? or is there any other way I can achieve what I want?

Thanks.
[2024-05-20 15:01:08]
John - SC Support - Posts: 36238
You would have to add the logic to cell J27 to cancel the working Limit order.

And depending on your setup, you may need to be careful about the order in which you manage what occurs first and then second. In other words, you may have to close out the existing Limit order first before you can add a new Limit order.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-05-20 15:21:23]
AzharBasri - Posts: 28
And depending on your setup, you may need to be careful about the order in which you manage what occurs first and then second. In other words, you may have to close out the existing Limit order first before you can add a new Limit order.

Can the cancellation and addition of the new limit order be done during the same time meaning after the same trigger candle?

What I mean is, after the candle close triggering K3 become TRUE, J27 will be TRUE. Can the new order be sent or since J3>0, it will recognise that the existing order is there already and do not trigger in K3?
[2024-05-20 20:40:52]
John - SC Support - Posts: 36238
In general, something needs to change state for it to create an action. So when J27 goes from False to True it will cancel the Working orders. But once True, it will not continuously cancel new working orders that are added. It has to go from False (or blank) to True.
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:

Login

Login Page - Create Account