Support Board
Date/Time: Tue, 14 Jan 2025 12:10:49 +0000
[Programming Help] - Trading Spreadsheet help
View Count: 756
| [2017-05-19 02:14:25] |
| User269983 - Posts: 31 |
|
Is it possible to only send out a trailing order only after a price profit condition is met and remain active even after profit fallback lower than the profit condition? For example, I only want the trailing order to be active after I get a 20 ticks profit and remind active even when price fall back to less than 20 tick profit. Long Entry: $50.00 Trailing only start after price hit $50.20. I want the trailing stop to remains active even after price go lower than $50.20 I have this AND condition. But this become false when C3 [high] on a new bar is less than $50.20 =AND($J$8>0, C3>$J$9+0.20, A3>$J$42, D3<(MIN(D4, D5) - 0.03)) |
| [2017-05-19 05:27:04] |
| Sawtooth - Posts: 4151 |
|
It can be done using the Trade Management By Study study, referencing a Formula Column (subgraph) on the spreadsheet, with a formula that is 0 before price moves to 50.20, and contains the trail stop price thereafter. Here's how to return the persistent max high since the entry bar, e.g. in U3: =IF(K3,MAX(C3,INDEX(C3:C1002,NMATCH(1,1,K3:K1002,0),1)),IF(M3,0,U4)) You will need to use more than one Formula Column to accomplish what you need. |
To post a message in this thread, you need to log in with your Sierra Chart account: