Login Page - Create Account

Support Board


Date/Time: Wed, 14 May 2025 00:10:08 +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]))