Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/19/2011(UTC)
Posts: 4
|
Hey guys,
I need a formula for metastock and I am not able to make it. pls help.
I need an EXPLORE formula which should scan the stocks which have fallen more than 5 percent from last day close and whose volume should be more than 50% of average volume of last three days.
There is a default similar formula in the software but it is for bullish breakout, I need it for bearish one.
Thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Does "fallen more than 5 percent from last day close" mean today's close is >5% down from yesterday's close?
Perhaps you should post the bullish formula, so as to give a better idea of what you're looking for, in opposite terms.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/19/2011(UTC)
Posts: 4
|
THANKS Johnathan,
Following are the details of that BULLISH formula:-
FORMULA : Equis - Price and Volume Breakout
WHAT IT DOES : Displays securities where the price increased 5% and the volume is 50% above a 50-day moving average.
Column A - CLOSE
Column B - Ref(CLOSE,-1)
Column C - ROC(CLOSE,1,percent)
Column D - VOLUME
Column E - Mov(VOLUME,50,EXPONENTIAL)
Column F - ((VOLUME - Mov(VOLUME,50,EXPONENTIAL)) /
Mov(VOLUME,50,EXPONENTIAL)) * 100
Filter - colC >= 5 AND colD >= (colE*1.5)
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/19/2011(UTC)
Posts: 4
|
THANKS Johnathan,
Following are the details of that BULLISH formula:-
FORMULA : Equis - Price and Volume Breakout
WHAT IT DOES : Displays securities where the price increased 5% and the volume is 50% above a 50-day moving average.
Column A - CLOSE
Column B - Ref(CLOSE,-1)
Column C - ROC(CLOSE,1,percent)
Column D - VOLUME
Column E - Mov(VOLUME,50,EXPONENTIAL) Column F - ((VOLUME - Mov(VOLUME,50,EXPONENTIAL)) / Mov(VOLUME,50,EXPONENTIAL)) * 100 Filter - colC >= 5 AND colD >= (colE*1.5)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Try this in the FILTER tab:
ROC(C,1,%)<-5
and V>mov(V,3,e);
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/19/2011(UTC)
Posts: 4
|
Thanks a lot, Thank you very much.Its Working.
|
|
|
|
|
|
| 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.
