Discussions
»
Product and Service Development
»
Formula Assistance
»
Price drop 20% from highest high to lowest low in 60 days
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/6/2009(UTC)
Posts: 36
Location: Los Angeles
Thanks: 4 times
|
I am trying to find stocks that have dropped by at least 20% from "highest High" to "lowest Low", over a 60-day period, AND that have ranged in CLOSING prices between $2 to $10 over the past 60 days. Also, I'd like to also ensure that Volume has >= 100,000 daily average over a 30-day period.
I have part of the formula, but need help with the rest:
((HHV(H,30) - LLV(L,30)) / HHV(H,30) >= 0.20 AND HHVBars(H,30) > LLVBars(L,30))
Thanks,
Mark McPherson
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Views messages in topic : 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
Hi,
You can try the following formula to see if this meets your criteria:
((HHV(H,60) - LLV(L,60)) / HHV(H,60) >= 0.20 AND HHVBars(H,60) > LLVBars(L,60)) AND LLV(C,60) >= 2 AND HHV(C,60) <= 10 AND Mov(V,30,S) >= 100000
|
|
|
|
|
|
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 your quick response. I am wondering... do I really need the "HHVbars" portion. Maybe I don't quite understand its purpose, since the first part of the formula is going back 60 days looking at High/Low.
Originally Posted by: MS Support  Hi,
You can try the following formula to see if this meets your criteria:
((HHV(H,60) - LLV(L,60)) / HHV(H,60) >= 0.20 AND HHVBars(H,60) > LLVBars(L,60)) AND LLV(C,60) >= 2 AND HHV(C,60) <= 10 AND Mov(V,30,S) >= 100000
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Views messages in topic : 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
Seems like it could be redundant in some cases, but perhaps for example a security could spike up, then down, then back up again. That most recent spike up could also be a 20% move so the additional criteria would ensure it would only capture the ones where the Low value is more recent than the High value.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Price drop 20% from highest high to lowest low in 60 days
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.
