Support Board
Date/Time: Tue, 14 Oct 2025 20:16:56 +0000
Stop limit order on spreadsheet system for trading
View Count: 97
| [2025-10-13 15:05:06] |
| User823328 - Posts: 40 |
|
Hello i want to know if it'possible with the spreadsheet system for trading to place 2 opposite stop limit order at the same time using the attached orders of trade windows to also have sl and tp ? What i want to do, i use a initial balance study to have the high and low of a specific timeframe i want the spreadsheet to place automatically a buy stop limit order on the IB high and a sell stop limit order on the IB low. And of course i want to see this pending order on the chart. For now i have configurer this succesfully on the spreadsheet but using market order but i prefer buy stop limit order and i have not success to configuré if i can have some help on it please ? And sorry in advance my english is very bad because it's not m'y native language Date Time Of Last Edit: 2025-10-13 15:36:17
|
| [2025-10-13 18:52:02] |
| John - SC Support - Posts: 42378 |
|
This is not something that can be done with the "Spreadsheet System for Trading", as that system is not setup to place and manage multiple Limit orders. There is the following Order Type that you can use: Order Types: OCO Buy Stop-Limit Sell Stop-Limit Otherwise, if you want to have this as part of an automated trading process, then you would have to create a Custom Study to do this. Refer to the following: Automated Trading From an Advanced Custom Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-10-13 19:28:54] |
| User823328 - Posts: 40 |
|
Ok thanks you. I m not sure to understand very well it's only possible to do what i want with ACSIL ? Or i can also do this with the spreadsheet system for trading using OCO BUY stop limit, sell stop limit ? I have see on the spreadsheet there is the possibility to use stop limit order instead of market order but i have not understand how to do that. |
| [2025-10-13 21:12:25] |
| John - SC Support - Posts: 42378 |
|
You can NOT do this with the Spreadsheet System, as it does not have the capabilities of entering an "OCO" type order. If you want this to be automated, then the only option is to create a custom study with ACSIL. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-10-13 23:05:07] |
| Sawtooth - Posts: 4276 |
|
You might be able to modify this example to do what you want : https://www.sawtoothtrade.com/free-stuff-20.html |
| [2025-10-14 08:02:29] |
| User823328 - Posts: 40 |
|
Oh thanks a lot sir, i have implemented the studie i use and my entry formula on K and it's look like to work. for now my formula on K is always true because my condition are to have the pending order all the day let say betwen 9 am to 4 pm until they are executed or not during this timeframe do you know if it's also work if i only have the signal true one time at 9:00:00 the bot will place the order and they will stay there until they are executed ? if it's work like that i can use the cancel and flatten order at set time function on the spreadsheet. And also another thing when i try to duplicate the chart on the chartbook and change the name of the spreadheet to use different configuration i don't know why but i can't i use different formula on K or another cell but every time i switch to another chart and i come back to the modified spreadsheet all my change are removed like if if i have not made any change, i have try to save using file save but it's always the same issue. Do you know what cause this issue ? Date Time Of Last Edit: 2025-10-14 10:09:42
|
| [2025-10-14 12:56:34] |
| Sawtooth - Posts: 4276 |
|
my condition is to have the pending order all the day let's say between 9 am to 4 pm until they are executed
Edit the formula in J27 to something like this:=AND(J8=0,FRACTIME(J41)>=TIME(16,0,0)) every time i switch to another chart and i come back to the modified spreadsheet all my changes are removed
In the spreadsheet study settings, set the 'Formula Source Sheet Number' to match the Chart#, then only use that Sheet#.
|
| [2025-10-14 13:30:58] |
| User823328 - Posts: 40 |
|
Thanks a lot for your answers i have managed to get what i needed it's really kind. Is it possible to have the same result using any chart and a Blank spreadsheet system for trading ? or have you implemented something on it because i have also tried to copy this on a new spreadsheet and i have not managed to have the order maybe some input are not correct on the chart or on the spreadsheet. |
| [2025-10-14 16:39:25] |
| Sawtooth - Posts: 4276 |
|
maybe some input are not correct on the chart or on the spreadsheet.
To copy all of the formulas to a blank spreadsheet, highlight columns J-O of the original, then Go to the main menu: Spreadsheet >> Copy Formula Then Paste into same highlighted columns on the blank spreadsheet. You could also create a Study Collection of the original, and apply it to any chart. But you'd need to remove the Moving Average, and change the K3 formula. Date Time Of Last Edit: 2025-10-14 16:39:47
|
| [2025-10-14 16:45:42] |
| User823328 - Posts: 40 |
|
Ok thanks a lot, i will do that.
|
To post a message in this thread, you need to log in with your Sierra Chart account: