Login Page - Create Account

Support Board


Date/Time: Tue, 04 Feb 2025 14:54:54 +0000



Post From: SpreadSheet Formula for Close below then back above a level

[2020-01-22 20:13:44]
Sawtooth - Posts: 4166
Try something like this:
=AND(E4<ID1.SG1@4,E3>ID1.SG1@3)
where ID1 is a moving average.

This also works:
=CROSSFROMBELOW(E3:E4,ID1.SG1@3:ID1.SG1@4)