|
PureBytes Links
Trading Reference Links
|
John,
To pinpoint two dates:
day1:= Input("Enter First Date - mmddyy",010100,123199,010101);
m1:= Int(day1/10000);
d1:= Int(day1/100) - (m1*100) ;
y1:= If(Mod(day1,100)>30, 1900+Mod(day1,100), 2000+Mod(day1,100));
day2:= Input("Enter Second Date - mmddyy",010100,123199,010101);
m2:= Int(day2/10000);
d2:= Int(day2/100) - (m2*100) ;
y2:= If(Mod(day2,100)>30, 1900+Mod(day2,100), 2000+Mod(day2,100));
val1:= ValueWhen( 1, Month() = m1 AND DayOfMonth() = d1 AND Year() =
y1, <your value> );
val2:= ValueWhen( 1, Month() = m2 AND DayOfMonth() = d2 AND Year() =
y2, <your value> );
Dusant
--- In Metastockusers@xxxxxxxxxxxxxxx, "johnm_milton" <johnm_milton@xx
..> wrote:
> Dear friends,
> I have a question. (hoping my english is good enough)
> I want to develop a simple explorer wich will indicate the percent
> variations between two specific dates (or dates + minutes for
> intraday data) for a list of equities.
> Now using the valuewhen function the difficulty is that I have to
> calculate the number of days (or group of minutes for intraday data)
> from the last value. Another difficulty is that not all the equities
> are updated at the same time so the last value is not the same for
> all the equities in the list.
> I wonder if there is a function which allows this; I mean simply
> indicating dd+mm+yy+minute for starting and end of calculation.
>
> I thank you in advance for your help.
> John
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/zMEolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|