Is there a way to code the slope of a moving linear regression line?  Thx

You can add a rate of change indicator to the chart and then change the data source of the ROC indicator to use the moving linear regression instead of price.

Change Data Source (3:38)

The period of the ROC indicator is going to determine the slope over Period bars. So setting the period to 1 is going to give you the slope from one bar to the next.

Thank you Bruce, I watched the video and was able to plot the slope in the chart window.  Is there a way to be able to create this in a PCF so that I could use it in a watchlist when the slope is above 0 I could see it?  I am interested in the MovLinR 30.  Thanks in advance

The following Indicator Formula assumes you are interested in the 1 period net rate of change in the 30 period moving linear regression.

(59 * C - 87 * AVGC29.1 + 28 * C30) / 465

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis

Could you do one for an 8, 20, and 100 period.

Thanks

1-Period Net Change in 8-Period Moving Linear Regression:

(5 * C - 7 * AVGC7.1 + 2 * C8) / 12

1-Period Net Change in 20-Period Moving Linear Regression:

(13 * C - 19 * AVGC19.1 + 6 * C20) / 70

1-Period Net Change in 100-Period Moving Linear Regression:

(199 * C - 297 * AVGC99.1 + 98 * C100) / 5050

The generalized form would appear to be as follows. I thought I did this calculation in the forums previously, but I don't seem to be able to find it.

((P * 2 - 1) * C - (P * 3 - 3) * AVGC(P-1).1 + (P - 2) * CP) / (P * (P + 1) / 2)

Bruce,

I wanted to do the calculation for an 1 period change in a 5 period moving linear regression, but unless I'm thick I can't follow the fomula.  It makes sense on the 100 period;

(P * 2 - 1) or (100 * 2 - 1)  = 199

&

C - (P * 3 - 3) or (100 * 3- 3) = 297 

but if I do the same for an 8 period;

 (P * 2 - 1) or (8 * 2 - 1) = 15     (your formula above shows 5

C - (P * 3 - 3) or (8 * 3 - 3) = 21   (your formula above shows 7

Ultimately I want an 5 period, can you help me understand what I am missing?

Thx

Substituting 5 for P results in the following Indicator Formula.

((5 * 2 - 1) * C - (5 * 3 - 3) * AVGC4.1 + (5 - 2) * C5) / (5 * (5 + 1) / 2)

Which can be simplifed down to the following.

(9 * C - 12 * AVGC4.1 + 3 * C5) / 15

Substituting 8 for P results in the following Indicator Formula.

((8 * 2 - 1) * C - (8 * 3 - 3) * AVGC7.1 + (8 - 2) * C8) / (8 * (8 + 1) / 2)

Which can be simplified down to the following.

(15 * C - 21 * AVGC7.1 + 6 * C8) / 36

Which can be further simplified to the following (by dividing by the numerator and denominator by 3).

(5 * C - 7 * AVGC7.1 + 2 * C8) / 12

Thanks Bruce - got it.  I was not dividing the numerator and denominator.

You don't need to divide the numerator and denominator. Even the long formula resulting from just substituting the period for P should work (although it is probably less efficient than the other two formulas).

I am new to these formulas and still learning to write them and was wondering how to have an up/down boolean formula to flash up or down  based on the change(+ or -) in moving linear regression slope over a certain time. (ie. 75 and 100 for a five-minute period)..  I tried using the rate of change on the MLR but would like to simplify it further to determine when the slope changes positive or negative. Thanks.

Add a 2-period moving average to the MLR. You can then click on the MLR and select Create Scan Condtiion for the MLR crossing through its moving average.

Create Conditions from Your Chart (5:25)

When the MLR is crossing down through its moving average then the slope has changed from up to down.

When the MLR is crossing up through its moving average then the slope has changed from moving down to up.