Login Page - Create Account

Support Board


Date/Time: Sun, 14 Sep 2025 13:22:06 +0000



Post From: Spreadsheet Trading Price Cross a fixed level

[2023-04-12 14:01:37]
ForgivingComputers.com - Posts: 1120
You can also do your own crossover by looking at the previous bar and comparing it to the last bar:

Assume your fixed price is H3.

Cross from Below:

=IF(AND(E4<=H3,E3>H3),1,0)

Cross from Above:

=IF(AND(E4>=H3,E3<H3),1,0)