Login Page - Create Account

Support Board


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



[User Discussion] - Moving Average Cross over system

View Count: 971

[2015-02-10 00:31:56]
BBFX1966 - Posts: 18
Sorry if this has been covered else where. Where would I be able to find the coding to generate a simple moving average cross over system on the spreadsheet function?
[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)
[2015-02-21 19:41:34]
BBFX1966 - Posts: 18
Thank you tomgilb

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account