Login Page - Create Account

Support Board


Date/Time: Wed, 25 Dec 2024 06:14:15 +0000



Post From: Moving average formula help

[2015-11-06 04:12:05]
Sawtooth - Posts: 4142
You'll need to use the OFFSET function to get the MA value 62 bars previous. (And you can do it without the IF function when you only need a real-time Boolean result.) Try this:

=OFFSET(ID11.SG1@3,62,0)>OFFSET(ID11.SG1@63,62,0)