Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/6/2009(UTC)
Posts: 36
Location: Los Angeles
Thanks: 4 times
|
I want to create a formula that does this:
For stocks that are (currently) priced between $5 to $15 per share,
find those which have had at least a 20% drop over the past 90 days.
Additionally, these stocks should have an average volume of 50,000 (over 90 days).
If possible, I would prefer to measure using the LOW from 90 days ago until now.
|
|
|
|
|
|
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)
|
The following formula should meet your criteria:
C >= 5 AND C <= 15 AND ROC(L,90,%) <= -20 AND Mov(V,90,S) >= 50000
|
 1 user thanked MS Support for this useful post.
|
|
|
|
| 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.
