Support Board
Date/Time: Fri, 20 Mar 2026 01:20:45 +0000
Trig & Trail OFFSET NOT UPDATING in Triggered Trail Stop (Spreadsheet + Attached Orders)
View Count: 171
| [2026-01-31 22:57:32] |
| Shores2021 - Posts: 39 |
|
Hello, I have a spreadsheet cell generating an Offset value. It's converted from ticks to price. When using Attached Orders Windows with Target1 + Stop:Stop the Offset value pulls from Spreadsheet and works perfect but When using Target1 + Stop: Triggered Trail Stop, the Offset value from spreadsheet only updates the STOP OFFSET, while TRIGGER OFFSET and TRAIL OFFSET does NOT Update. All Offset Values are to be the same as the main Target/Stop Offset. /// Attached Order Window /// Target1 (Price Offset) - Updates automatically from Spreadsheet Stop: Triggered Trailing Stop Stop Offset (Price Offset) - Updates automatically from Spreadsheet Trig Offset (Price Offset) - Not Updating (have to set manually) Trail Offset (Price Offset) - Not Updating (have to set manually) I would like to automatically write-in the Offset value from the spreadsheet cell into all OFFSET windows for Target1 + Stop: Triggered Trail stop (all 3 Offset windows) Q: How can I make all Offset boxes update based on the spreadsheet cell value, preferably without using an ACSIL CUSTOM STUDY? Thank you. Date Time Of Last Edit: 2026-02-01 00:18:55
|
| [2026-02-02 16:48:48] |
| John - SC Support - Posts: 45204 |
|
This statement is not correct: When using Attached Orders Windows with Target1 + Stop:Stop
the Offset value pulls from Spreadsheet and works perfect When you have a Target/Stop offset entered in the Spreadsheet, and you enter an order FROM the spreadsheet, then the Target/Stop will be set based on the offsets entered in the spreadsheet, not from the Trading Window. If you enter an order from the Trade Window, then the offsets will be taken from the settings for the Trade Window. If you enter an order from the Spreadsheet, but have not specified any offsets, then the Attached Orders will come from the Trade Window. Therefore, to do what you are wanting is not supported, nor is it supported in any way at this time. You would have to use ACSIL to access information entered in the Spreadsheet to use as settings for a Triggered Trail Stop. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2026-02-02 21:10:30
|
| [2026-02-02 19:30:56] |
| Shores2021 - Posts: 39 |
|
So to clarify: Currently: 1. Attached Order Target Offset (write-only): (J80) & Attached Order Stop Offset (write-only): (J81) are referencing a spreadsheet cell to get my offset amount and already converted to a price in points. 2. My original opening orders are generated from the spreadsheet at first 3. Then, the Trade Window manages the Stop & Trail 4. I see Target_Limit_Offset pulling successfully from J80 and Stop_Offset pulling successfully from J81 when the original orders are sent. 5. So the only way to write-in and to change Stop:Trail Offset & Stop:Trigger Offset boxes in the Trade Window is using ACSIL (that can reference and pull from any spreadsheet cell into these 2 cells), correct? Thank you John. Date Time Of Last Edit: 2026-02-02 19:32:50
|
| [2026-02-02 21:10:18] |
| John - SC Support - Posts: 45204 |
|
1. OK. 2. Ok. 3. No. When you create an order using the Spreadsheet, it can only create a standard Stop and Limit (Target). You can not do a Trailing Stop directly from the Spreadsheet. If you want to open a posiition from the Spreadsheet and have a Trailing Stop, then you need to NOT enter any Stop Offset or Target Offset in the Spreadsheet. In this case, the system will then look to get the Attached Orders from the Trade Window (the Trade Window does need to be setup to have the proper Attached Orders and the option for "Use Attached Orders" enabled). 4. Yes, this will occur. 5. As specified in #3 above, you would have to setup the Trade Window as you want it and have the Target and Stop offsets (J80/J81) in the spreadsheet blank. There is no interface to change the Stop parameters of the Trade Window through ACSIL. If you were going to go down that path, you are best served to change your trading process from the Spreadsheet to ACSIL, so you can have complete control over what you want to do. The one item we can point you to that might help with what you want to do is that you can set a "Trade Window Configuration" in the Spreadsheet study (cell J112). You can then setup multiple configurations for the approximate offsets you want and then select the configuration you want in the Spreadsheet. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-02-10 20:56:19] |
| Shores2021 - Posts: 39 |
|
Hi John, Could you take a look at this post I posted but didn't get an answer yet. Replay vs Faster Internal Backtesting Thank you very much. |
To post a message in this thread, you need to log in with your Sierra Chart account: