Login Page - Create Account

Support Board


Date/Time: Mon, 10 Aug 2026 05:16:39 +0000



Post From: Automated Trading - Spreadsheet

[2017-08-20 01:00:12]
Sawtooth - Posts: 4343
Try this:

In a Formula Column, e.g. in cell P3:
=IF(alertcondition,1,IF(reversalcondition,0,P4))
Then find the row where the reversal happened, e.g. cell Q3:
=AND(P4=1,P3=0)