Login Page - Create Account

Support Board


Date/Time: Mon, 07 Jul 2025 03:56:29 +0000



Post From: Automated Trading - Spreadsheet

[2017-08-20 01:00:12]
Sawtooth - Posts: 4236
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)