Thank you. I will give it a try. I did not mean to write EMA but I didn't see it until after I posted, I just wanted SMA.. But thanks for letting me know how to amend that.

I appreciate your help.  I will start testing it out and I hope ti gives the results I was looking for.  Thanks again.

Thank you -. I would start with just 6 days as that is closest to 5 days we use on the EMA, and go from there. I only need to identify the slope of the 5dma to weed out hits I do not want. I only want stocks with a price that closed above the 5dma line for the first time in X days when the LRS slope of the 5dma is positive, OR stocks with a price that closed under the 5mda line for the first time in X days when the slope is negative. We can try to define the degree of the slope as > 5% or < -5% and then tweak from there but I don&#39;t think it matters too much.  X days can be 5 or 6 but I can also tweak that later.

I know that this sounds like I asking you to write a formula for me - I am sorry for that.  I have tried to research the coding but honestly its over my head. I know what I am trying to do in lay terms. Coding it so a computer can identify these patterns it is more challenging.  I think the LRS of the MA is the trick to identifying the direction of the MA line as either "pointing up" or "pointing down" as we discussed in the link you put up above.  I appreciate your guidance either way.

I think what I want is to determine the linear regression slope on the moving average. 

I had this formula which you helped me with, but it isn&#39;t narrow enough.

(C > AVGC5 AND C1 <= AVGC5.1 AND AVGC5 > AVGC5.1) OR (C < AVGC5 AND C1 >= AVGC5.1 AND AVGC5 < AVGC5.1)

I want to make sure the slope of the moving average is defined because I only want hits that had a crossover above the MA when the slope grade is positive and cross under the MA when the slope grade is negative. And I want that crossover to have happened today, or within the last 2 days. 

If we don&#39;t need to define the LRS and can do this another way, great, but based on what i read in these fora that seemed to be one way to do it that made sense to me.

Thanks for your help

How would you turn this into a 5 day slope?  I guess if I wanted to screen for greater than 5% I just change < to >?  Or more precise i want to take a 5 day simple moving average with a slope greater than 5%.

And if I wanted to find a stock with a closing price that closed on the other side of the slope line either in the last 1 or 2 days?   Meaning, 3 days ago it was under the slope and today it is above the slope.

Technically I would want to find stocks that just recently closed above the slope line with a >5% slope AND stocks that recently closed below slopes <-5% if slopes can be measured in positive and negative slopes

You helped me before on something similar 5 years ago but it was a different version of TC and the formulas i had are lost now.  Trying to refine/rebuild it.

TIA!