Support Board
Date/Time: Mon, 27 Oct 2025 16:47:50 +0000
Post From: Trading Spreadsheet help
| [2017-05-19 05:27:04] |
| Sawtooth - Posts: 4280 |
|
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. |