Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 15:41:35 +0000



Post From: Spreadsheet Trading Price Cross a fixed level

[2023-04-12 14:01:37]
ForgivingComputers.com - Posts: 960
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)