Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 19:01:10 +0000



Post From: Linear Regression Line not generating alert

[2013-11-19 15:35:14]
djcurcio - Posts: 236
I'm trying to get the Linear Regression middle line to generate and alert when it changes from up to down or down to up.
I am using the below "slope" code and it does not seem to work.
Help appreciated.
Thanks

=OR(AND(SG1>SG1[-1],SG1[-2]>SG1[-1]),AND(SG1<SG1[-1],SG1[-2]<SG1[-1]))