Re: Filtering out dead stocks

["Lionel Issen" <lissen@xxxxxxxxx>]

when I entered the items in Col A, B, C, I got an error message.

when I just entered the items for the filter  (nothing in any of the other
cols) it worked.

Is the last line of the filter formula "Test=1" necessary?

I was able to locate some errant securities and delete them.

thanks for your help.
Lionel Issen
lissen@xxxxxxxxx
----- Original Message -----
From: "michael" <mslist@xxxxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Tuesday, October 03, 2000 2:11 PM
Subject: RE: Filtering out dead stocks


> The entire formula must be in the Filter.  Here is how I set it up.
>
> {ColA}
> Year()
> {ColB}
> Month()
> {ColC}
> DayOfMonth()
>
> {Filter}
> y1:=2000;
> m1:=7;
> dt:=25;
>
> test:=If(Year()<>y1,1,If(Month()<>m1,1,If(DayOfMonth()<>dt,1,0)));
>
> Test=1
>
>
> That should work.  The Explorer does not recognise variables from one
column
> to the next.
>
> Michael
>
>
>
>
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Lionel Issen
> Sent: Tuesday, October 03, 2000 11:51 AM
> To: metastock@xxxxxxxxxxxxx
> Cc: support@xxxxxxxxx
> Subject: Re: Filtering out dead stocks
>
>
> Michael:
> I tried to enter  this in an exploration.
>
> Method 1: all the functions in ColA and test in Filter
> result error function for d1 (not recognized function)
> I tried rearranging the functions with d1 as the first, y1 as the second
and
> m1 as the 3rd.
> this gave me an error function message again.
>
> Method 2. entered each formula in a separate column.  This gave me an
error
> message in the test formula at y1.
>
> Any suggestions?
> Lionel Issen
> lissen@xxxxxxxxx
> ----- Original Message -----
> From: "michael" <mslist@xxxxxxxxxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: Monday, September 25, 2000 10:26 AM
> Subject: RE: Filtering out dead stocks
>
>
> > Here is how I do it...
> >
> > y1:=2000;
> > m1:=7;
> > dt:=25;
> >
> > test:=If(Year()<>y1,1,If(Month()<>m1,1,If(DayOfMonth()<>dt,1,0)));
> >
> > Test=1
> >
> > Since the Explorer does not allow the Input Function, you will need to
> enter
> > the Year, Month, and Day as the variables y1,m1,and dt, respectively.
> >
> > Hope this helps.
> >
> > Michael
> >
> > -----Original Message-----
> > From: owner-metastock@xxxxxxxxxxxxx
> > [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Tony
> > Sent: Monday, September 25, 2000 9:49 AM
> > To: metastock@xxxxxxxxxxxxx
> > Subject: Filtering out dead stocks
> >
> >
> > Is there anyway of making a filter that tests to see that the most
> > recent data is equal to today's trade date.
> >
> > I keep getting stocks such as Hadco show up on my explorations even
> > though the stock no longer exists. I am tired of manual using the
> > Downloader to filter such stocks.
> >
> > I simply want to filter out stocks whose last trade date is prior to
> > today or I guess today - 1.
> >
> > Thanks
> >
>
>