Login Page - Create Account

Support Board


Date/Time: Tue, 14 Jan 2025 23:54:09 +0000



Post From: Trading Spreadsheet help

[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.