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

[pumrysh <no_reply@xxxxxxxxxxxxxxx>]

D Sathia,

Yes the value of 1 is used in the explorer to signify a valid result.
You can sort these so that all "1's" are grouped together if that is 
easier for you. Use the filter to display just the valid securities.
Something like this should work:
{Place in Filter}
colA = 1

Preston

 

--- In equismetastock@xxxxxxxxxxxxxxx, "D Sathia Moorthy" 
<sathiamoorthyd@xxx> wrote:
>
> 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@> 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/