[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Metastockusers] Re: missing quotation (FORMULA)



PureBytes Links

Trading Reference Links

====================
Missing trading days
====================
---8<---------------------------

{ Explores for missing daily (weekday) bars }
{ ©Copyright 2003-2004 Jose Silva }
{ http://users.bigpond.com/prominex/pegasus.htm }

ChkVol:=0; {Zero-volume days = missing data days?  Yes=1, No=0}
VolMissing:=If(ChkVol,V=0,0);

limit:=1960;  {do not change limit year}
LimLeap:=Frac(limit/4)=0 AND Frac(limit/100)<>0
 OR Frac(limit/400)=0;
NoCount:=limit*365+Int(limit/4)
 -Int(limit/100)+Int(limit/400)-LimLeap;
leap:=Frac(Year()/4)=0 AND Frac(Year()/100)<>0
 OR Frac(Year()/400)=0;
y:=Year()*365+Int(Year()/4)
 -Int(Year()/100)+Int(Year()/400)-NoCount;
m:=
 If(Month()=2,31-leap,
 If(Month()=3,59,
 If(Month()=4,90,
 If(Month()=5,120,
 If(Month()=6,151,
 If(Month()=7,181,
 If(Month()=8,212,
 If(Month()=9,243,
 If(Month()=10,273,
 If(Month()=11,304,
 If(Month()=12,334,
 -leap)))))))))));
DayNr:=y+m+DayOfMonth();
WkDayCount:=
 Int((DayNr+3)/7)+   {Mon}
 Int((DayNr+2)/7)+   {Tue}
 Int((DayNr+1)/7)+   {Wed}
 Int((DayNr)/7)+     {Thu}
 Int((DayNr-1)/7);   {Fri}

WkDayCount-ValueWhen(2,1,WkDayCount)-1
 +VolMissing

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

jose '-)


--- In Metastockusers@xxxxxxxxxxxxxxx, "swing72000" <azer789@xxxx> 
wrote:
> HI,
> 
> DO you know the formula (explorer) for verify the missing quotation 
> from 31 december 2003 ( I just want to know if I have the 63 CLOSE 
> for my 3360 Nasdaq stock in my folder from 31 december 2003 to 30 
> march 2004)? 
> 
> (because I saw  today that my Datadownloader don't give me all the 
> missing quotation in view report !)
> 
> Thank you.



 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
     Metastockusers-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/