Hi all I am wondering if you can please assist me, I am running the below scans – however I am wanting to ensure the results are within ‘30% of the 150 week highs’… I have mucked around and come up with the below scan including condition of:

TIMEFRAME (WEEKLY)
c9 = close/highest[150](high)>0.7 and close/highest[150](high)<1

But it seems to be resulting a few stocks that are 40%+ from their 3 year highs…. can you anyone please offer advise? The main aim is trending stocks, within 30% of 3 year highs…

The full scan I run is below: thanks in advance

_________________________________________________________________

//TIMMMMMBOS

ma50=exponentialaverage[50]
ma150=exponentialaverage[150]
ma200=exponentialaverage[200]
indicator3 = Average[40](Volume)

c1 = Close > exponentialaverage[50]
c2 = ma50>ma150
c3 = ma150>ma200
c4 = summation[20](ma200>ma200[1])=20
c5 = Close/lowest[250](low)>1.3
C6 = (close > 2)
C7 = (close < 10)
C8 = (indicator3 > 50000)

TIMEFRAME (WEEKLY)
c9 = close/highest[150](high)>0.7 and close/highest[150](high)<1

TrendTemplate = c1 and c2 and c3 and c4 and c5 and c6 and c7 and c8 and c9

screener[TrendTemplate]