Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 11:44:22 +0000



Post From: Moving Average Cross over system

[2015-02-10 00:54:30]
Sawtooth - Posts: 4141
Simple crossover formulas, entered in row 3 of any column K-Z:

=CROSSFROMBELOW(AA3:AA4,AB3:AB4)
=CROSSFROMABOVE(AA3:AA4,AB3:AB4)

where the faster MA is in column AA and the slower MA is in column AB.

You could also use these:
=AND(AB4>AA4,AA3>AB3)
=AND(AB4<AA4,AA3<AB3)