Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 14 May 2024 11:59:31 +0000
Time in force in combination with spreadsheet for trading
View Count: 599
| [2020-10-28 11:30:15] |
| FTDK - Posts: 13 |
|
I need to find a way to cancel my limit orders created by my spreadsheet if they aren't filled. It seems like the easiest way to do this is via the time in force section on the Trade Window. I found this webpage for more information regarding time in force but it seems like there was a mistake made? Trade Simulation: Time In Force for Trade Simulation Mode As you can see all sections contain the information about what would happen if i select Good Till Cancelled, i need to know what would happen if i select immediate or cancel vs fill or kill so i can see which one is best for me. Assuming the time in force works when orders are placed via a spreadsheet? If there is another way to cancel my order if it isn't filled, can someone please share it with me? |
| [2020-10-28 20:07:31] |
| |
|
The best way to do this is to be in direct control of it and Cancel the orders after a certain period of time and not rely upon a Time in Force. But that is not going to be simple to do on spreadsheets. So we really recommend using ACSIL for the automated trading in this case: Automated Trading From an Advanced Custom Study 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 |
| [2020-10-29 00:17:10] |
| FTDK - Posts: 13 |
|
Turns out it was fairly easy to do after all. I formulated it like this on my 1 minute chart spreadsheet: =OR(IF(AND($J$9=0, $J$93<A3), 1, 0), IF(AND($J$9=0, $J$94+5<E3), 1, 0), IF(AND($J$9=0, $J$94-5>E3), 1, 0)) $J$9 is the position average price so the order will only be canceled if this field is 0. Meaning if there is no open position. This will work for me since i only allow 1 trade at a time. $J$93 is the last working entry order date-time, so the order will be canceled when this field gets smaller than the opening time of the next new candle. Meaning the order will be there for maximum till the end of the candle that triggered it. $J94 is the last working entry order price, so the buy order will be canceled if the last price is 5 points higher than the buy limit price and the sell order will be canceled if the last price is 5 points lower than the sell limit price. ---- A completely different question but i think i already know the answer to this one: Is it possible to run the spreadsheet for trading on an ES chart but trigger the actual orders in MES (micro es futures)? Date Time Of Last Edit: 2020-10-29 00:18:16
|
| [2020-10-29 14:48:45] |
| John - SC Support - Posts: 31602 |
|
With Regards To: "Is it possible to run the spreadsheet for trading on an ES chart but trigger the actual orders in MES". Yes, refer to the following: Chart Settings: Trade and Current Quote Symbol (text box) (Chart >> Chart Settings >> Symbol >> Symbol menu) 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: