Login Page - Create Account

Support Board


Date/Time: Fri, 24 Jan 2025 06:49:49 +0000



Post From: code problem

[2019-01-01 01:40:30]
Sawtooth - Posts: 4162
You'll need to create a persistent Buy signal that is released with the Sell signal, then find each transition.

In O3:
=IF(E4>ID1.SG1@3,1,IF(E3-B3=B3-E3,0,O4))
In K3:
=AND(O4=0,O3=1)
In L3:
=AND(O4=1,O3=0)

This is a variation of this example:
Spreadsheet Example Formulas and Usage: Buy on First Signal and Ignore Multiple Signals