[EquisMetaStock Group] Need some help with the following explorer code

["nand_rathi" <nand_rathi@xxxxxxxxx>]

Hello All

Greetings

I need some help with the code below as I am at complete loss why is
giving me incorrect result..

I am using the following code in explorer to determine the lowest low
value in last 52 weeks. I picked up most of the code from couple of
posting in this group.

For a particular security I have data loaded up to Apr 7th 2008. The
following code is returning the lowest value which occurred on Feb 28,
2007, which obviously is incorrect..

I have checked the data manually over and over, (the lowest low is on
Jan 22, 2008)

I need some help to solve this bug, obviously I am doing something
wrong here.

Appreciate the help very much.

regards

N

---- code for colA

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:= ValueWhen(1, x=1, Lowest(L));
y


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

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/