|
PureBytes Links
Trading Reference Links
|
Exploration filter for inactive securities:
---8<-----------------------------------
{ Date-cutoff - excludes inactive codes whose
last active date was before 19/Jan/2007 }
day:=19; { 1~31 Day of month cutoff }
mth:=01; { 1~12 Month cutoff }
y:=2007; { Year cutoff }
{ ***************************************** }
{ Date cutoff }
cutoff:=Year()>y
OR (Year()=y AND (Month()>mth
OR Month()=mth AND DayOfMonth()>=day));
{ Exploration filter }
cutoff
---8<-----------------------------------
jose '-)
http://www.metastocktools.com
--- In equismetastock@xxxxxxxxxxxxxxx,
"stockmarket1974" <stockmarket1974@xxx> wrote:
>
> can you tell how to filter only those stocks which have todays data.
> so that the exlorer does not give output result for stocks that have
> stoped trading but continue to be in the data folder.
>
> regards
> joshik
>
>
>
> --- In equismetastock@xxxxxxxxxxxxxxx, Gordon Sutherland <gosuth@>
> wrote:
>
> You could put the following code into the filter tab of an Exploration:
>
> Sum(Cum(1),500) > 500
>
> This should pass those stocks with more than 500 periods of data (approx
> two years).
>
> If you wish to filter for a list of stocks that have less than two years
> of data, then try:
>
> Cum(1) < 500
>
> I am sure there are other ways to achieve the same.
>
> Regards,
>
> Gordon Sutherland
>
>
>
> -----Original Message-----
> From: mwtang [mailto:mwtang@]
> Sent: Sunday, 13 July 2003 3:26 p.m.
> To: equismetastock@xxxxxxxxxxxxxxx
> Subject: [EquisMetaStock Group] Explorer fomular ?
>
>
> Hi ! Is there a way to write an explorer formula that can scan out
> securities which have only two years data i.e. new listing. So that I
> can separate the new and the old. Thanks in advance.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|