Support Board
Date/Time: Thu, 06 Nov 2025 04:58:22 +0000
Dynamic stepped trailing stop loss (TSL)
View Count: 128
| [2025-10-26 12:07:34] |
| User795248 - Posts: 8 |
|
In an automated system I'm considering, I would like to have a step TSL set up, which is configured depending upon volatility - ideally the distance between VWAP standard deviation bands - at the time of entry. Is there a way to automatically reference, choose and use one of a number of my saved Trade Window configurations using an alert-based or spreadsheet system? e.g. If range = 50T, then choose trade config #3. If not, is there an easier solution than resorting to manually setting up all the elements of a step TSL logic within a spreadsheet? (I couldn't find a stepped trailing loss study that might speed up this process). Thank you. |
| [2025-10-26 21:14:38] |
| Sawtooth - Posts: 4285 |
|
e.g. If range = 50T, then choose trade config #3.
Use cell J112.This cell can contain a formula using the IF function to output the twconfig file name. Spreadsheet Systems, Alerts and Automated Trading: Trade Window Configuration File (write-only) [v1:J112, v2:J87] is there an easier solution than resorting to manually setting up all the elements of a step TSL logic within a spreadsheet?
Use the Trade Management By Study study, referencing a Formula Column that has a formula that outputs the price of the TSL.Attached Orders: Study Controlled Targets and Stops |
| [2025-11-02 14:11:04] |
| User795248 - Posts: 8 |
|
Thank you, the =IF equation works well. I need a couple of further points for clarification on this 1) If the required trade config changes mid-trade, am I correct in assuming that the attached orders for the open trade will not change with it, i.e. it is as it was at point of entry? 2) I notice that cell J52 seems to register as 2 trades after a single 2-contract trade has been completed. Is this expected? I ask as I'd like to restrict entries to max 2 per day (so would reference J52<=4), but if I decided to up the number of positions in the trade window to e.g. 4, then would I need to change the entry formula to include J52<=8 to ensure the 2-trade limit remains? Is there a better cell to reference that I missed? |
| [2025-11-02 15:22:25] |
| Sawtooth - Posts: 4285 |
|
1) A new twconfig won't move existing stops and targets. 2) J52 doesn't increment at entry, only at exit. A 2-lot round trip trade would increment 1 in J52. Spreadsheet Systems, Alerts and Automated Trading: Daily Total Trades (read-only) [v1:J52, v2:J59] In J53, a 2-lot trade would increment 2 at entry, and two more at exit, so a 2-lot round trip trade would increment 4 in J53. Spreadsheet Systems, Alerts and Automated Trading: Daily Total Quantity Filled (read-only) [v1:J53, v2:J62] BTW, The Spreadsheet System for Trading study's J26 overrides the Trade Window's order quantity. Spreadsheet Systems, Alerts and Automated Trading: Order Quantity (read / write) [v1:J26, v2:J69] |
To post a message in this thread, you need to log in with your Sierra Chart account: