Support Board
Date/Time: Thu, 30 Jan 2025 14:43:51 +0000
Post From: Spreadsheet Buy signal one time until next sell signal.
| [2018-01-24 21:23:05] |
| Sawtooth - Posts: 4164 |
|
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. |