Support Board
Date/Time: Sat, 13 Dec 2025 04:10:38 +0000
Post From: Trading Spreadsheet help
| [2017-05-19 05:27:04] |
| Sawtooth - Posts: 4299 |
|
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. |