Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/23/2006(UTC)
Posts: 22
Location: Melbourne, Australia
|
How do I create a exploration to find a volume spike that is at least twice the size of the average volume I would also want it to reject any that dont meet the criteria. Thank you in advance to anyone that can help.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Well my approach to this problem is fairly straight-forward and methodical....
[list:714ec071e1][*:714ec071e1]First, I would read the MS Users Manual that came shipped with my legitimate copy of MetaStock, then
[*:714ec071e1]I would download the Equis Formula Primer from the downloads section and work my way through it, whilst
[*:714ec071e1]Reading through this forum (yes, we know the search function has gone awry - but that will be fixed in the new forum version coming soon(?)), then
[*:714ec071e1]I would have a go at writing this indicator myself, and post a request for help here if I ran into difficulties doing any of the above (I would also post my source code so others may see where I made any mistakes, or could coach you on ways to improve your code)[/list:u:714ec071e1]
But.... that's just me. You might strike it lucky and find that someone might be kind enough to do all your work for you...
[/sarcasm]
Benny, please also have a read of the forum rules.
wabbit :D
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/23/2006(UTC)
Posts: 22
Location: Melbourne, Australia
|
I have looked at the manuel that came with my legitmate copy of metastock and I have looked at the forum rules but I must admit I dont know all of them off the top of my head, So thanks for all your help (sarcasm). So to get back to the topic as the last post was off it I will say that I have tried but I cant even get close to getting a formula to work for me and I was hoping someone who has already got this worked out could post it here or direct me to a place that i could find it. So thank you in advance to anyone that can help.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/23/2006(UTC)
Posts: 22
Location: Melbourne, Australia
|
i tried this code V/Mov(V,100,S) with a filter of colA AND
CLOSE>1 but it isnt what i am after as you can tell from my first post on this thread
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Try this then:
1. Be nice.... we're here to help you.
2. Create a new Exploration:
{ColA}
V/Mov(V,100,S)
{Filter}
ColA>1 AND CLOSE>1
(I take it you are only looking for stocks valued at $1.00 + ?)
Have a look through these forums for 'Boolean Logic' or do a Google.
In your orginal filter condition you said, "ColA AND CLOSE>1" MS interprets this as, "If ColA equals 1 AND Close greater than 1" then return true. You might have been thinking, "(ColA AND Close)>1" which would not have the desired effect either.
Boolean logic and their operators are EXTREMELY POWERFUL and need to be used with care and understanding.
wabbit :D
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/23/2006(UTC)
Posts: 22
Location: Melbourne, Australia
|
Thanks for the fast reply wabbit but what I am looking for I belive has nothing to do with the code I or filter I have. I want to find stocks (any price) that show large spikes like the one on my chart or that are at least 3 times more than the average volume. The catch is I want the exploration look only for spikes that have happned on the day I search.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
{ColA}
V/Mov(V,100,S)
{Filter}
ColA>1
Sort the results of the exploration by Column A and you will see the stocks with the highest ratio of volume to average volume (the volume spikers) will be at the top (or bottom) of the list (depending on which way you sort them).
wabbit :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
.. and I would also drop the MA periods to say 21?
Try:
{ColA}
V/Mov(V,21,S)
{Filter}
ColA>1
wabbit :D
P.S. A note of caution about this exploration... Sometimes volume search results are skewed by such events option expiry etc, so analyse the results carefully.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hi Benny-
There are several volume derived explorations you might want to check out. We have talked about this in the past... maybe coming up with a dozen or more unique references. Chaikin's indicators are a good place to start.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey benny.... something like below might be what your after..... your view of average volume might differ somewhat so change the 10 to suit..... also notice i used 's' instead of 'e'..... i'm a simple kinda guy......
odds are the blue line is what your after......the 3* is for your 3 times.... the other columns were just for clarity and can be discarded...... included a 4* also..... 10 sma of volume and volume.... that exploration will only return the securitys that meet the conditions.....
btw, thats one heck ofa mean lookin avatar wabbit has, ain't it......h
Exploration notes
Col A: 3 times [color=blue:ad80427f4b]V>(3*Mov(V,10,S))[/color]
Col B: 4 times V>(4*Mov(V,10,S))
Col C: 10 v sma Mov(V,10,S)
Col D: V
Filter colA OR colB
Filter enabled Yes
Periodicity Daily
Records required 500
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
oh yeah, now i get it..... its meta'morphis or wabbitmorphis...... [color=green:43b96725e4]wabbit [/color]has turned green ..... kinda like the incredible hulk does when he gets mad...... hehehe..... didn't think we'd catch that did ya wabbit.......h
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
dont get mad... get even!
wabbit :D
|
|
|
|
|
|
| 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.
