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

[pumrysh <no_reply@xxxxxxxxxxxxxxx>]

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@xxx> 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/