Discussions
»
Product and Service Development
»
Formula Assistance
»
EXPLORATION EXCLUDING SHARES THAT HAVE NOT TRADE TODAY
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/13/2005(UTC)
Posts: 87
Location: perth australia
|
Hi,
It seems simple enough but at the moment I have a mental block on this simple formula.
I want to explore shares but exclude those that have not traded today. I tried V> 0 but the explorer only looks at share volume of the last price bar and so includes all shares even if they have not traded for a while.
Hope someone can help
Norman :shock:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth
Was thanked: 2 time(s) in 2 post(s)
|
Try this exploration filter:
[code:1:7b1b9739e7]
{ Date-cutoff - excludes inactive codes whose
last active date was before 26/May/2005 }
day:=26; { 1~31 Day of month cutoff }
mth:=05; { 1~12 Month cutoff }
y:=2005; { Year cutoff }
{ ***************************************** }
{ Date cutoff }
cutoff:=Year()>y
OR (Year()=y AND (Month()>mth
OR Month()=mth AND DayOfMonth()>=day));
{ Exploration filter }
cutoff
AND V>0
[/code:1:7b1b9739e7]
jose '-)
http://www.metastocktools.com
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/13/2005(UTC)
Posts: 87
Location: perth australia
|
Hi Guys,
Thanks for that. I had already tried Richards dll but it filters on stocks that have traded within the last x calendar days which doesnt solve the issue finding a share that has not traded today.
But your code works Jose. Thanks once more for your help.
Cheers
Norman
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
EXPLORATION EXCLUDING SHARES THAT HAVE NOT TRADE TODAY
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
