Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 16:35:34 +0000



[User Discussion] - Linear Regression Line not generating alert

View Count: 1477

[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]))
[2013-11-19 21:38:59]
Sawtooth - Posts: 4119
The Linear Regression End Channel study constantly redraws the lines so there is no way to compare the previous slope to the current slope, using a Simple Alert.

It would be possible with the Spreadsheet System/Alert study, by locking the TRUE state of a cell with a formula. Post again if you want the details.

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

Login

Login Page - Create Account