TheTrend 

Apply this code to an exploration for a ticker. In the 2nd Col you'll see the date of the yearly high or low IF the 3rd or 4th column is different from 0.   Code NewHigh = H > Ref(HHV(H,250),-1); NewLow = L < Ref(LLV(L,250),-1); Filter =1; AddColumn(IIf(NewHigh,H,0) ,"Yearly High ?"); AddColumn(IIf(NewLow,L,0),"Yearly Low ?"); Hope that helps.

thanx for the code. it explores all the quotes for the desired time period and post all result.

can i filter the zero result and get only the hi or lo dates.

wud i use any filter or put any condition?

regards
sr

sr114 

thanx for the code. it explores all the quotes for the desired time period and post all result. can i filter the zero result and get only the hi or lo dates. wud i use any filter or put any condition? regards sr

You can filter that in Excel very easily or re-formulate the code to give you buy or sell signals and then run a scan i/o an exploration.

Actually no need to run a scan, just use this updated code for exploration:

 

Code

NewHigh = IIf( H > Ref(HHV(H,250),-1),1,0); NewLow = IIf(L < Ref(LLV(L,250),-1),1,0); Clr = IIf(NewHigh,colorGreen,colorRed); Filter =NewHigh ==1 OR NewLow ==1; AddColumn(IIf(NewHigh,H,L) ,"Yearly High / Low",1.2,colorDefault,Clr);

It gives you 1 column with green cells for highs and red cells for lows, how nice is it ?

TheTrend 

Actually no need to run a scan, just use this updated code for exploration:   Code NewHigh = IIf( H > Ref(HHV(H,250),-1),1,0); NewLow = IIf(L < Ref(LLV(L,250),-1),1,0); Clr = IIf(NewHigh,colorGreen,colorRed); Filter =NewHigh ==1 OR NewLow ==1; AddColumn(IIf(NewHigh,H,L) ,"Yearly High / Low",1.2,colorDefault,Clr); It gives you 1 column with green cells for highs and red cells for lows, how nice is it ?

The Trend

thats was a big help for me. a heartfelt gratitude for u

regards
sr