Platinum Customer
Joined: 7/28/2014 Posts: 14

I am trying to create a scan condition which is simply when the Rate of Change Indicator (for a Moving Linear Regression line) is greater than 0. For whatever reason, it s returning no results. I'm looking at my charts and they show positive ROC results whenever the Moving Linear Regression line is rising so I'm not sure what I'm doing incorrectly. Thanks


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

It is a bug. I can write a Condition Formula to work around the issue, but I would need to know the periods of both the ROC and the MLR.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 7/28/2014 Posts: 14

The weekly MLR is 13 and the ROC is 1. Thanks again


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

The value of a 1period rate of change (net) indicator applied to a 13period moving linear regression indicator applied to price can be written as follows.
(25 * C  36 * AVGC12.1 + 11 * C13) / 91
This would greater than zero when:
25 * C + 11 * C13 > 36 * AVGC12.1
And less than zero when:
25 * C + 11 * C13 < 36 * AVGC12.1
How to create and save a Condition (PCF) Formula
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 7/28/2014 Posts: 14

Thanks Bruce. I'll give that a shot and see how it works.


Platinum Customer
Joined: 7/28/2014 Posts: 14

Bruce,
Can I bother you for another formula. Again it is for when the rate of change indicator is greater than 0 but this time it will be for the Monthly chart when the MLR is 9 and the ROC is 1. Thanks
v


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

The value of a 1period rate of change (net) indicator applied to a 13period moving linear regression indicator applied to price can be written as follows.
(17 * C  24 * AVGC8.1 + 7 * C9) / 45
This would greater than zero when:
17 * C + 7 * C9 > 24 * AVGC8.1
And less than zero when:
17 * C + 7 * C9 < 24 * AVGC8.1
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 7/28/2014 Posts: 14

Bruce,
Can I get your help with another formula? Again it is for when the rate of change indicator is greater than 0 but this time it will be for a MONTHLY chart when the MLR is 9 and the ROC is 1.
Thanks again for all your help


Platinum Customer
Joined: 7/28/2014 Posts: 14

Never mind....just got your response.
Thanks again


Platinum Customer
Joined: 7/28/2014 Posts: 14

Bruce,
Can I bother you again for another iteration of this formula? I need to find when the Rate of Change indicator is greater than 0 for the DAILY chart when the MLR is 30 and the ROC is 2.
I'd like to be able to complete different iterations of this without having to continue to bother you however I can't really decipher how you are coming up the formulas. Maybe as a baby step, how would the same formula differ if I wanted it for when the ROC is 1.
Thanks again, I really appreciate your help.


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

Please try the following Indicator Formula for a ROC2 of an MLR30.
(59 * C + 56 * C1  168 * AVGC28.2 + 25 * C30 + 28 * C21) / 465
There is a generalized form of this for a 1 period rate of change of a moving linear regression given in the Slope of moving linear regression line topic where P is the period of the MLR.
((P * 2  1) * C  (P * 3  3) * AVGC(P1).1 + (P  2) * CP) / (P * (P + 1) / 2)
So if we had a ROC1 of a MLR30, we would get the following by substituting 30 for P.
((30 * 2  1) * C  (30 * 3  3) * AVGC(301).1 + (30  2) * C30) / (30 * (30 + 1) / 2)
Which comes out to the following if you calculate out each of the individual parts.
59 * C  87 * AVGC29.1 + 28 * C30) / 465
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 7/30/2007 Posts: 1,072

Nice!


Platinum Customer
Joined: 7/28/2014 Posts: 14

Thanks again Bruce.


Platinum Customer
Joined: 7/28/2014 Posts: 14

Bruce,
When creating an EasyScan, I can use the formulas that you gave me to identify when the ROC is greater than zero. However, it doesn't give the option to identify stocks when the ROC is just turning positive. Is there a way to create a condition that either identifies when 1)WEEKLY ROC crosses up through a zero horizontal line or 2) Prior WEEKLY ROC is less than zero an current WEEKLY ROC is greater than zero?
Thanks


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

You can create one bar ago versions of the formulas to check for the previous bar.
An easier method might be to plot the desired value based indicator as Custom PCF Indicator. Then you can click on it and select Create Scan Condition to check for it crossing up or down through zero.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 7/28/2014 Posts: 14

Got it! Thanks.
I'm a finance guy who is a tech dummy so this stuff is like another language to me. Appreciate all your assistance.


Platinum Customer
Joined: 7/28/2014 Posts: 14

Bruce,
Can you give me a hand on another formula please? I need a formula to find when the Rate of Change indicator is greater than 0 for the 4 HOUR chart when the MLR is 40 and the ROC is 2.
Thanks again


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

Please try the following Condition Formula with the time frame of the Condition Formula set to 4 hour.
79 * C + 76 * C1 + 35 * C40 + 38 * C41 > 228 * AVGC38.2
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 7/28/2014 Posts: 14

Bruce,
That returns a boolean result and not a value. I was hoping to calculate the ROC value like the formulas that you were able to provide above. Again, appreciate the help.


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

Please try the following Indicator Formula.
(79 * C + 76 * C1 + 35 * C40 + 38 * C41  228 * AVGC38.2) / 820
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 7/28/2014 Posts: 14

Nailed it Bruce. Thanks again.


Worden Trainer
Joined: 10/7/2004 Posts: 59,179

You're welcome.
Bruce Personal Criteria Formulas TC2000 Support Articles


Guest1 