How would I find stocks where price has been above the 30MA for 6 months, one year or 2 years etc.

Thank you,

We can do this in a daily time frame for 6 months or one year, but not 2 years. There are 500 bars of a data available in each time at the start of each trading day. While this is about 2 years, by the time you actually calculate the moving average, you are about 34 trading days short.

We are going to use the technique described here.

Condition True at Least x Bars in a Row

Please look through the referenced article as it has step by step instructions. What follows will probably not make sense if you have not already done so.

The Period for the Custom PCF % True Indicator is going to be the number of bars in a row. So 126 for six months or 252 for a year for example.

The Boolean Formula is going to be a Condition Formula for price being above its 30 period simple moving average.

C > AVGC30

Make sure the Condition is for Greater Than 99.99. You can choose Scan in New Window if you immediately want to create a new EasyScan based on the condition.

Thank you Bruce.....tried C 252 > AVGC30 ....Gave me a bunch of stocks where price was under 30MA , NOT ABOVE.

The formula needs to be exactly as given.

C > AVGC30

The 252 will be used as the Period in the Custom PCF % True Indicator.

Assuming you have this done correctly, make sure the moving average on the chart is simple and that the moving average is of itself and not of something else (like another moving average).

Bruce,

How would the formula change if I wished to create a column listing the number of days price has been below its 10 SMA?

Thanks

Bruce,

   Many thanks for creating such detailed instructions like this:

Condition True at Least x Bars in a Row

http://support.tc2000.com/

Don

Somehow I goofed in the above post and made all of the lines clickable.

Only these were supposed to be clickable:

Condition True at Least x Bars in a Row

http://support.tc2000.com/

Bruce,

   It would be helpful to make these support articles a sticky so they are readily available and not forgotten.

http://support.tc2000.com/

  I really appreciate your efforts in creating this.

Don

donv98,
A stick topic has been added to this forum. A link has also added it to my signature.

klinger99
An Indicator Formula which actually returns a count of the number of bars is quite a bit more complicated to create than a condition which checks for something happening at least x bars in a row.

Days Since Last Peak (or other day-counting needs)

The following Indicator Formula maxes out at 60 bars in a row.

ABS(C < AVGC10) * (ABS(C1 >= AVGC10.1) + ABS(C1 < AVGC10.1) * (ABS(C2 >= AVGC10.2) * 2 + ABS(C2 < AVGC10.2) * (ABS(C3 >= AVGC10.3) * 3 + ABS(C3 < AVGC10.3) * (ABS(C4 >= AVGC10.4) * 4 + ABS(C4 < AVGC10.4) * (ABS(C5 >= AVGC10.5) * 5 + ABS(C5 < AVGC10.5) * (ABS(C6 >= AVGC10.6) * 6 + ABS(C6 < AVGC10.6) * (ABS(C7 >= AVGC10.7) * 7 + ABS(C7 < AVGC10.7) * (ABS(C8 >= AVGC10.8) * 8 + ABS(C8 < AVGC10.8) * (ABS(C9 >= AVGC10.9) * 9 + ABS(C9 < AVGC10.9) * (ABS(C10 >= AVGC10.10) * 10 + ABS(C10 < AVGC10.10) * (ABS(C11 >= AVGC10.11) * 11 + ABS(C11 < AVGC10.11) * (ABS(C12 >= AVGC10.12) * 12 + ABS(C12 < AVGC10.12) * (ABS(C13 >= AVGC10.13) * 13 + ABS(C13 < AVGC10.13) * (ABS(C14 >= AVGC10.14) * 14 + ABS(C14 < AVGC10.14) * (ABS(C15 >= AVGC10.15) * 15 + ABS(C15 < AVGC10.15) * (ABS(C16 >= AVGC10.16) * 16 + ABS(C16 < AVGC10.16) * (ABS(C17 >= AVGC10.17) * 17 + ABS(C17 < AVGC10.17) * (ABS(C18 >= AVGC10.18) * 18 + ABS(C18 < AVGC10.18) * (ABS(C19 >= AVGC10.19) * 19 + ABS(C19 < AVGC10.19) * (ABS(C20 >= AVGC10.20) * 20 + ABS(C20 < AVGC10.20) * (ABS(C21 >= AVGC10.21) * 21 + ABS(C21 < AVGC10.21) * (ABS(C22 >= AVGC10.22) * 22 + ABS(C22 < AVGC10.22) * (ABS(C23 >= AVGC10.23) * 23 + ABS(C23 < AVGC10.23) * (ABS(C24 >= AVGC10.24) * 24 + ABS(C24 < AVGC10.24) * (ABS(C25 >= AVGC10.25) * 25 + ABS(C25 < AVGC10.25) * (ABS(C26 >= AVGC10.26) * 26 + ABS(C26 < AVGC10.26) * (ABS(C27 >= AVGC10.27) * 27 + ABS(C27 < AVGC10.27) * (ABS(C28 >= AVGC10.28) * 28 + ABS(C28 < AVGC10.28) * (ABS(C29 >= AVGC10.29) * 29 + ABS(C29 < AVGC10.29) * (ABS(C30 >= AVGC10.30) * 30 + ABS(C30 < AVGC10.30) * (ABS(C31 >= AVGC10.31) * 31 + ABS(C31 < AVGC10.31) * (ABS(C32 >= AVGC10.32) * 32 + ABS(C32 < AVGC10.32) * (ABS(C33 >= AVGC10.33) * 33 + ABS(C33 < AVGC10.33) * (ABS(C34 >= AVGC10.34) * 34 + ABS(C34 < AVGC10.34) * (ABS(C35 >= AVGC10.35) * 35 + ABS(C35 < AVGC10.35) * (ABS(C36 >= AVGC10.36) * 36 + ABS(C36 < AVGC10.36) * (ABS(C37 >= AVGC10.37) * 37 + ABS(C37 < AVGC10.37) * (ABS(C38 >= AVGC10.38) * 38 + ABS(C38 < AVGC10.38) * (ABS(C39 >= AVGC10.39) * 39 + ABS(C39 < AVGC10.39) * (ABS(C40 >= AVGC10.40) * 40 + ABS(C40 < AVGC10.40) * (ABS(C41 >= AVGC10.41) * 41 + ABS(C41 < AVGC10.41) * (ABS(C42 >= AVGC10.42) * 42 + ABS(C42 < AVGC10.42) * (ABS(C43 >= AVGC10.43) * 43 + ABS(C43 < AVGC10.43) * (ABS(C44 >= AVGC10.44) * 44 + ABS(C44 < AVGC10.44) * (ABS(C45 >= AVGC10.45) * 45 + ABS(C45 < AVGC10.45) * (ABS(C46 >= AVGC10.46) * 46 + ABS(C46 < AVGC10.46) * (ABS(C47 >= AVGC10.47) * 47 + ABS(C47 < AVGC10.47) * (ABS(C48 >= AVGC10.48) * 48 + ABS(C48 < AVGC10.48) * (ABS(C49 >= AVGC10.49) * 49 + ABS(C49 < AVGC10.49) * (ABS(C50 >= AVGC10.50) * 50 + ABS(C50 < AVGC10.50) * (ABS(C51 >= AVGC10.51) * 51 + ABS(C51 < AVGC10.51) * (ABS(C52 >= AVGC10.52) * 52 + ABS(C52 < AVGC10.52) * (ABS(C53 >= AVGC10.53) * 53 + ABS(C53 < AVGC10.53) * (ABS(C54 >= AVGC10.54) * 54 + ABS(C54 < AVGC10.54) * (ABS(C55 >= AVGC10.55) * 55 + ABS(C55 < AVGC10.55) * (ABS(C56 >= AVGC10.56) * 56 + ABS(C56 < AVGC10.56) * (ABS(C57 >= AVGC10.57) * 57 + ABS(C57 < AVGC10.57) * (ABS(C58 >= AVGC10.58) * 58 + ABS(C58 < AVGC10.58) * (ABS(C59 >= AVGC10.59) * 59 + ABS(C59 < AVGC10.59) * 60)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

That is awesome. Thanks so much!

Bruce,

  Many thanks for creating the sticky and signature link.

They make finding the support articles immediate.

Don

You're welcome.