Hello,

I am trying to create a scan on Moving Linear Regression crossing down / up price line. I does not show any results

Thank you for reporting the issue. I have submitted your bug report to development.

I can probably create a Condition Formula to get around the issue if you provide the settings of the Moving Linear Regression indicator.

Thanks Bruce,

Yes, I would like to one created.

Thanks

I would need to know the settings of the Moving Linear Regression indicator to help you create the Condition Formula.

I would like 13 day period.

A Condition Formula for price crossing up through its own 13-period moving linear regression can be written as:

C > AVGC13 + 6 * (6 * C + 5 * C1 + 4 * C2 + 3 * C3 + 2 * C4 + C5 - C7 - 2 * C8 - 3 * C9 - 4 * C10 - 5 * C11 - 6 * C12) / 182 AND C1 <= AVGC13.1 + 6 * (6 * C1 + 5 * C2 + 4 * C3 + 3 * C4 + 2 * C5 + C6 - C8 - 2 * C9 - 3 * C10 - 4 * C11 - 5 * C12 - 6 * C13) / 182

A Condition Formula for price crossing down through its own 13-period moving linear regression can be written as:

C < AVGC13 + 6 * (6 * C + 5 * C1 + 4 * C2 + 3 * C3 + 2 * C4 + C5 - C7 - 2 * C8 - 3 * C9 - 4 * C10 - 5 * C11 - 6 * C12) / 182 AND C1 >= AVGC13.1 + 6 * (6 * C1 + 5 * C2 + 4 * C3 + 3 * C4 + 2 * C5 + C6 - C8 - 2 * C9 - 3 * C10 - 4 * C11 - 5 * C12 - 6 * C13) / 182

A Condition Formula for price crossing through its own 13-period moving linear regression in either direction can be written as:

SGN(AVGC13 + 6 * (6 * C + 5 * C1 + 4 * C2 + 3 * C3 + 2 * C4 + C5 - C7 - 2 * C8 - 3 * C9 - 4 * C10 - 5 * C11 - 6 * C12) / 182 - C) <> SGN(AVGC13.1 + 6 * (6 * C1 + 5 * C2 + 4 * C3 + 3 * C4 + 2 * C5 + C6 - C8 - 2 * C9 - 3 * C10 - 4 * C11 - 5 * C12 - 6 * C13) / 182 - C1)

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis

Thanks a lot Bruce.  Your help is very much appreciated.

Hi Bruce,

It doesn't work consistently.   I want the price moving down / up today. 

The current behavior is more or less as  MLR > price   or MLR < price

Please provide specific examples as it most definitely does not behave that way in my copy of TC2000.

The first formula only returns true when the close of the previous bar was at or below the moving linear regression and the close of the current bar is above the moving linear regression.

The second formula only returns true when the close of the previous bar was at or above the moving linear regression and the close of the current bar is below the moving linear regression.

The third formula only returns true when the close of the previous bar was on one side of the moving linear regression and the close of the current bar is on the other side of the moving linear regression.

The cross always happens between the previous bar and the current bar. The formulas do not return true unless this is the case.

Sorry Bruce,

I use only the  first two.  I now changed the chart to line intead of OLC which gives me better insight on crossing , especially in cases like FLS (for price moving up) and LMT (price moving down)

Thanks

A cross is almost always defined as price closing on one side of the line during the previous bar and being on the other side of the line during the current bar.

If you have something else in mind which involves the open, high and low in addition to the close, you would need to provide the specifics on how you wish to define the cross.

Please try the following Condition Formula.

SGN(38 * C + 13 * (C1 + C10) + 8 * C11 - 72 * AVGC8.2) <> SGN(38 * C1 + 13 * (C2 + C11) + 8 * C12 - 72 * AVGC8.3)

TY It performs excellently!   I'd like to also add a PCF that shows MLR10 > (its own) AVGC2 (offset +1) please.  

Please try the following Condition Formula:

38 * C + 13 * (C1 + C10) + 8 * C11 > 72 * AVGC8.2

Hello Bruce,

I am having exactly the same issue. I'm trying to scan for a crossing of the moving linear regression 10 and 30. But nothing is found. Visual inspection shows plenty of charts meeting the criteria. I''m using the settings as shown in the attached screenshot. Could you please have a look?

PS: I tried it with verion 16 and 17, both the same issue

I had the same issue in V16, it appears to be a bug.

Back in 2016, I was using Moving Linear Regression 16 periods crossing up 2 Period Simple Moving Average Linear Regression 16, it didnt work. It looks like its still not fixed.

A Condition Formula for the MLR10 of price crossing up through the MLR30 of price within the most recent 12 bars can be written as follows in TC2000 v17.

XUP(3 * FAVGC10 - 2 * AVGC10, 3 * FAVGC30 - 2 * AVGC30, 12)