Support Board

Date/Time: Sat, 18 May 2024 06:22:28 +0000

Post From: Spreadsheet Buy signal one time until next sell signal.

[2018-01-24 21:23:05] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
You need to use an additional Formula Column to create a persistent 1 with the Buy signal formula, then release it with the Sell signal formula, e.g. in cell P3: =IF(yourbuyconditions,1,IF(yoursellconditions,0,P4)) Then in K3: =AND(P4=0,P3) And in M3: =AND(P4,P3=0) This is a simplified solution; your specific situation may require modifying this concept.