Discussions
»
Product and Service Development
»
Formula Assistance
»
Volume last 10 days x-times higher than prev. 190 days (excluded the last 10 days)
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 12/19/2012(UTC)
Posts: 54
Location: Austria
|
Hi, may some one can help me. I try to do a SCAN for MS with the criteria. The last 10 days MA of the Volume should be at least 10 times higher than the previous days, for example the last 190 days. BUT!!! Yeah, BUT! the last 10 days should not be included in the sum of the last -11 days to -190 days. What is it good for? Stocks at the bottom which are at least about 8 month not very attractive are now getting a ten times higher Volume. So, at least someone is fu** interessted in this stock. Any idea how i can cumulate the last volume-days of the days ago: -11 to -190. Mov(V, 10, S) > 10 * Mov(V, 11 days ago too 190 days ago, S) But, how can i do this in a correct formula : ))) Ref () I dont know how to use this for only a piece of the past days, so i repeate myself 132 times. Volume last 10 days compared to the volume of day 11 to day 190 (days ago). : ))) Kind regards, Clemens
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
HiClemens
Something like this might be what you are looking for. Your explanation did not stretch to saying whether the previous 190 days volume was a simple moving average or any one of several other possibilities, so I've assumed an SMA of all previous 190 bars. Note that there are generally several ways that any MetaStock solution can be coded and my example is only one example.
I suspect that you'll get very few hits on large-cap stocks, probably more with low-cap though. Please make sure you understand what this code does do and doesn't do before you come back and report that it doesn't work. And if you do come back for further help be sure to include all rules rather than one or two generalities. While some of us are experienced mind readers it's always helpful if the rules are in writing as well.
M10:=Mov(V,10,S);
M190:=Mov(V,190,S);
M10 > 10*Ref(M190,-10);
Roy
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 12/19/2012(UTC)
Posts: 54
Location: Austria
|
Hi Roy, I ll try it right now. In the meantime I tired this one, may YOU can tell me if this is "the same" like your code (i dont understand it by now), and I havent tested it. Yes, it is at least for stocks which are at the bottom, for example after a crash, so right now there may be at least no result ( result = 0). ColA: Mov(V, 190, S) ColB: Mov(V, 10, S) ColC: (V + Ref(V, -1) + Ref(V, -2) + Ref(V, -3) + Ref(V, -4) + Ref(V, -5) + Ref(V, -6) + Ref(V, -7) + Ref(V, -8) + Ref(V, -9) + Ref(V, -10)) / 11 Filter: colB > 10 * (((colA * 190) - colC)/179) So it is the sum of only 179 days, i calculate the last 11 days out of it, the average is the / 179. Yeah... hmm is this "thought" correct, i was never good in math, so I try the financial market challenge. : -))
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 12/19/2012(UTC)
Posts: 54
Location: Austria
|
Hi Roy, finally it is the same result!! So ... : ))) We made it! Memorial Production Partners Lp (MEMP)Memorial Production Partners Lp (MEMP) Is a result, if you look at the chart, or the volume... hmm... : - )) so now i can predict the future!
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Volume last 10 days x-times higher than prev. 190 days (excluded the last 10 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.
