Discussions
»
Product and Service Development
»
Formula Assistance
»
How to find Volume averaged at 500,000 over 90 days & priced at $5.00 or less
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users Joined: 1/6/2009(UTC) Posts: 36 Location: Los Angeles
Thanks: 4 times
|
I have tried reading (and understanding) the Metastock manual, but I am still stumped.
What I am trying to do is to find stocks whose volume AVERAGES 500,000 or more, over a 90-day period, and that are priced at $5.00 or less.
I think this should be simple, but I shouldn't talk, as I can't figure it out.
Please help!
Thanks, Mark
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 11/7/2005(UTC) Posts: 602
|
How about something like:
a1:=((Sum(V,90)/90)>500,000); a2:=(C<5); a3:=a1*a2; a3
Change each variable to your liking.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users Joined: 1/6/2009(UTC) Posts: 36 Location: Los Angeles
Thanks: 4 times
|
Thank you for this.
I tried copy/pasting this into the explorer, but I get an error.
Am I supposed to copy it exactly as it's shown?
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 10/26/2009(UTC) Posts: 76 Location: Toronto, Canada
|
Here, copy this into the FILTER tab of the explorer (Make sure you set "Load number of bars" to "1000" to be safe):
x:= Mov(V,90,S)>500,000;
y:= 5.00>H;
x and y
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users Joined: 1/6/2009(UTC) Posts: 36 Location: Los Angeles
Thanks: 4 times
|
Hi,
Thanks for the formulas; however, I have Metastock 9.1 and I guess entering formulas has changed a lot.
I guess all I want to do is find stocks whose AVERAGE Volume over the last 90 days is 500,000 shares. Forget price.
Can anyone help?
|
|
|
|
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)
|
Large numbers don't have separators. Use 500000 not 500,000
wabbit [:D]
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 5/25/2010(UTC) Posts: 55
|
Isn't Volume in hundreds (e.g. 500k would be 5000)?
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 10/26/2009(UTC) Posts: 76 Location: Toronto, Canada
|
oops my mistake..... use 500000 not 500,000
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
How to find Volume averaged at 500,000 over 90 days & priced at $5.00 or less
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.