[EquisMetaStock Group] Re: specify closing price for a specific date in exploration editor

["bellamy_29m" <bellamy_29m@xxxxxxxxx>]

Tomas,

Have a look at the ValueWhen function; it can be really useful here.

Try something along the lines of:

ValueWhen(1,Year()=2002 AND Month()=1 AND DayOfMonth()=1,C)

BE WARNED THOUGH: if the date set is not a trading day for this stock 
it will return N/A.  You might be better off using date functions, 
along the lines of:

varDay:=1;
varMonth:=1;
varYear:=2002;

x:=(DayOfMonth()>=varDay AND Month()=varMonth AND Year()=varYear) OR 
(Month()>varMonth AND Year()=varYear) OR Year()>varYear;

ValueWhen(1,x=1 AND Ref(x,-1)=0,C)

ANOTHER WARNING: before the date specified the function will return 
N/A... but that shouldnt cause too many problems.  If it does, ask 
for assistance....


Hope this helps.

wabbit

<snip>



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

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

<*> 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/