[EquisMetaStock Group] Re: Formula to find stocks that made high at a particular year

["D Sathia Moorthy" <sathiamoorthyd@xxxxxxxxx>]

Dear pumrysh,

Thank you for your reply. Your reply has solved my problem partly. 
The exploration results using the formula shows all the securities 
and we have to select the securities with the value of 1. 

Is there any formula, that would give only the name of the securities 
which comply our conditions. 

Regards,

D Sathia Moorthy 













--- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@xxx> wrote:
>
> D Sathia Moorthy,
> 
> Part of the problem that you are going to run into is that 
requesting 
> the highest high for a particular year may not be the "all time 
high" 
> for the stock. 
> 
> You can explore for the all time high simply by using:
>  
> highest(high)
> 
> You can also look for the highest high in a particular year by 
> scanning with a formula like this:
> 
> X:=ValueWhen(1,Year()=2006,Highest(H));
> X
> 
> You can then check to see if this was the highest high by comparing 
> the value of the highest high to x. If it was the highest all time 
> high it would be true or give you a value of one. The formula is:
> 
> X:=ValueWhen(1,Year()=2006,Highest(H));
> X = highest(high)
> 
> If you get a value of zero in years after 2006 then you know that 
the 
> highest high did not occur in 2006.
> 
> I did run across a formula that you might find useful. 
> 
> {52 week HIGH & LOW}
> {From Wabbit at Equis Forum} 
> lastDay:=LastValue(DayOfMonth()); 
> lastMonth:=LastValue(Month()); 
> lastYear:=LastValue(Year())-1; 
> 
> x:=Year()>lastYear OR (Year()=lastYear AND (Month()>lastMonth OR 
Month
> ()=lastMonth AND DayOfMonth()>=lastDay)); 
> y:=x AND Alert(x=0,2); 
> i:=Cum(1)=1; 
> hi:=LastValue((HighestSince(1,y OR i,H)))*(BarsSince(x>0)>=-1); 
> lo:=LastValue((LowestSince(1,y OR i,L)))*(BarsSince(x>0)>=-1); 
> 
> {plot} 
> hi;lo;
> {end}
> 
> 
> Hope this helps,
> 
> Preston
>  
> 
> --- In equismetastock@xxxxxxxxxxxxxxx, "D Sathia Moorthy" 
> <sathiamoorthyd@> wrote:
> >
> > Hi friends,
> > 
> > I am new to this forum. I need help in using Explorer. I want the 
> know 
> > the explorer function that would find the stocks for the 
following;-
> > 
> > I want to find all those stocks that have made all time high at a 
> > particular year (Ex 2005).
> > 
> > Can any one help me in this regard.
> > 
> > Thanking you
> > 
> > Regards,
> > D Sathia Moorthy
> >
>



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/