Raymond,

Try below;

{ 1 is Jan , 2 is Feb ....6 is June etc}

month = 6 ;

year()=2007;

dayofmonth()=17 ;

from

lamkeng

Raymond

There are several ways to check the date of the last bar of data. One method that I sometimes use samples the date of the last bar of an index or security that is known to be current. With that information it's easy to check each security in a test or exploration and flag those that do (or do not) have current data. With the code below you'd need to insert a functioning path name for the security and check my quickly typed code syntax.

[code] {Last Date Check} DayRef:=LastValue(Security("C:\....\XAO",DayofMonth())); MonthRef:=LastValue(Security("C:\....\XAO",Month())); YearRef:=LastValue(Security("C:\....\XAO",Month())); LastValue(DayofMonth())=DayRef AND LastValue(Month())=MonthRef AND LastValue(Year())=YearRef; */cose* There are also a number of other ways to achieve the same result, as there are for most MetaStock tasks. Roy MetaStock Tips & Tools

Hi Roy,

I tried your coding but I could not get the result of Security() function as expected. List below is the indicator I used for testing (last trading date of security 060410 =10/04/2006 and last trading date of security 070522 = 22/05/2007):

yref1:=LastValue(Security("G: estData EST\060410",Year()));
mref1:=LastValue(Security("G: estData EST\060410",Month()));
dref1:=LastValue(Security("G: estData EST\060410",DayOfMonth()));
yref2:=LastValue(Security("G: estData EST\070522",Year()));
mref2:=LastValue(Security("G: estData EST\070522",Month()));
dref2:=LastValue(Security("G: estData EST\070522",DayOfMonth()));
date1:=dref1+mref1/100+(yref1-100*Int(yref1/100))/10000;
date2:=dref2+mref2/100+(yref2-100*Int(yref2/100))/10000;
date1;
date2

Same value=15.0607 (last trading date of current security) returned for date1 and date2 but not the reference dates 10.0406 and 22.0507 correspondingly. Please correct me if there is anything wrong in my codings.

Raymond

Hi Roy,

Thanks to your code and also thanks to Mark Pyle's GV.DLL, they are really what I needed.[:)]

Raymond

Thanks wabbit, NexusDate.dll is wonderful, much simpler. Thanks to Richard Dale's sharing.

But I wonder why lastvalue(security("...",year())) could not return the year of last trading date of the reference security. It seems that the data array returned by the reference security will either be trimmed or padded (with values equal to that of last trading date) to the date of the current security. I wonder whether it is the intention of Metastock or it is a bug in Metastock.

Raymond[:)]

Raymond, there is a way around the Security() function's data padding.

It involves taking advantage of the highly unlikely event that a security's OHLC values will repeat on the following trading day:

---8<------------------------------------------------------------

{ Security's OHLC reference }
Op:=Security("G: estData EST\060410",O);
Hi:=Security("G: estData EST\060410",H);
Lo:=Security("G: estData EST\060410",L);
Cl:=Security("G: estData EST\060410",C);

{ Security's trading days }
trade:=Op<>Ref(Op,-1)
AND Hi<>Ref(Hi,-1)
AND Lo<>Ref(Lo,-1)
AND Cl<>Ref(Cl,-1);

{ Day/Month/Year of trading day }
Day:=ValueWhen(1,trade,DayOfMonth());
Mth:=ValueWhen(1,trade,Month());
Yr:=ValueWhen(1,trade,Year());

{ Outputs }
Yr;Mth;Day

---8<------------------------------------------------------------

jose '-)