logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Price drop 20% from highest high to lowest low in 60 days - Price drop 20% from highest high to lowest low in 60 days
Options
Go to last post Go to first unread
Previous Topic Next Topic
mark91345  
#1 Posted : Wednesday, November 11, 2015 7:36:58 PM(UTC)
mark91345

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
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
MS Support  
#2 Posted : Thursday, November 12, 2015 6:16:13 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 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
Back to top
mark91345  
#3 Posted : Friday, November 13, 2015 3:10:41 PM(UTC)
mark91345

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 Go to Quoted Post
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
Back to top
MS Support  
#4 Posted : Friday, November 13, 2015 3:33:00 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 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.
Back to top
Users browsing this topic
Guest (Hidden)
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.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET