Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 11/25/2006(UTC) Posts: 2
|
I am somewhat new to Metastock and am runnning into an unusual problem. I wanted to set up an Exploration to get average volume to ensure I only looked at stocks with >500k shares a day, but was seeing too much skew due to a single volume spike. I looked and looked, but there is no function for median. Has anyone made a formula to get a median value from an array? I want to get the median volume from athe last 50 days.
Thanks in advance!
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users Joined: 7/12/2007(UTC) Posts: 134 Location: Perth Western Australia
|
Matrim,
Try this in the exploration.
ColumnA
Mov(V,50,S);
Filter {1st Option}
Mov(V,50,S)>500000; {50day Simple Moving Average of the volume is greater than 500k}
Filter {2nd Option}
LLV(Mov(V,50,S),50)>500000; {Lowest value of the 50day SMA of the volume over the last 50 days is greater than 500K}
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 11/25/2006(UTC) Posts: 2
|
Thank you for the help, but this still does not address the actual intent of the formula. However, I have since thought about it and wonder if I am being overly stringent.
Even if there is a volume surge on just a couple days, I think having 50+ days should effectively remove the significance of any single day.
I will try this for a while and see if this will minimize the amount of stocks I look at.
matirm
|
|
|
|
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.