RE: Filtering out dead stocks

["michael" <mslist@xxxxxxxxxxxxxxxx>]

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
>