Support Board
Date/Time: Mon, 20 Jan 2025 13:50:07 +0000
[User Discussion] - Spreadsheet auto trading cancelling orders
View Count: 1178
| [2017-06-07 22:59:37] |
| User498548 - Posts: 5 |
|
Hello when using spreadsheet auto trading is there a way to cancel my order if the price has moved away or I have not been filled? |
| [2017-06-08 19:08:02] |
| |
|
Not a simple way. You would have determine a formula to accomplish this and you could only cancel all of the orders for the Symbol and Trade Account. You need to use this Sheet Cell: https://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#CancelWorkingOrders 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 |
| [2018-06-14 01:21:07] |
| User104854 - Posts: 457 |
|
Is there a way or can there be a way to reference the price that an existing order is at so that if it's unfilled and price moves a certain distance away from the order a formula could be created on a spreadsheet to cancel it? You know what price the order is at, the broker knows, I know, the exchange knows, but there isn't a way for the spreadsheet to know? |
| [2018-06-14 02:30:08] |
| Sawtooth - Posts: 4157 |
|
Unfortunately the price of a working order is not output to the spreadsheet. You would have to capture a price at the entry signal bar, and create a persistent variable of it, then compare it to the current price. The caveat is that slippage might cause the captured persistent variable to not be the exact price of the actual working order. Here are some formula examples of persistent variables, but none are specific to your need: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Spreadsheet Example Formulas and Usage: Cancel Unfilled Working Order n Minutes After Entry |
To post a message in this thread, you need to log in with your Sierra Chart account: