logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Historical Volume Breakout Code.. - Historical Volume Breakout Code..
Options
Go to last post Go to first unread
Previous Topic Next Topic
RockstarRky  
#1 Posted : Monday, March 24, 2014 1:30:27 PM(UTC)
RockstarRky

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/24/2014(UTC)
Posts: 6
Hello Traders and Metastock Coding Experts,

Let me say that I am new to Metastock exploration coding and need your help.

Here's what I am trying to do. I am trying to a build an exploration in Metastock. I want to find out the volume breakout in a particular time period for a stock.

Here's what the formula looks like for now, some of the codes are standard ones from Equis

+++++++++++++++++++++++++
Col A: Volume
Volume

Col B: Avg. Vol.
Mov(V,14,S)

Col C: Price
Close

Col D: % Change
ROC(CLOSE,1,Percent)

Col E: % Above
(VOLUME - Mov(V,14,S)) / Mov(V,14,S) * 100

Filter:
colA > colB

++++++++++++++++++++++++++

I want to find the particular time when the volume brokeout. But this formula just finds the stocks for the last time when the volume broke out and rejects others. So if some stock had an upsurge in the volume 2 days ago, then it won't find that stock! how do I fix this?? How can I find HISTORICAL VOLUME BREAKOUT?

Thanks in advance! Any help will be deeply appreciated!
Rocky
Back to top

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
Back to top  
henry1224  
#2 Posted : Tuesday, March 25, 2014 6:34:55 AM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 3 time(s) in 3 post(s)
Rocky, You should be looking for an event that has just occured such as a crossing of a signal.
It's ok to establish filters for your search

ColA: Volume filter
V>Mov(V,14,S)

Filter:
ColA=1

Or this is another way

Filter:
V>Mov(V,14,S)

You can see that there are several ways to write this.
Back to top
RockstarRky  
#3 Posted : Tuesday, March 25, 2014 11:49:48 AM(UTC)
RockstarRky

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/24/2014(UTC)
Posts: 6
Hello Henry Sir,

Thank you for your kind post on here. However, I would like to point out that my message was misunderstood. I do get stocks crossing the 14 day moving average of Volume. However, it only displays the security that has crossed the mov. avg volume on that particular day that the search is being done.

Let me explain by giving you an example.

Lets examine the symbol (LIVE) on Nasdaq. Here's the historical quotes for your convenience.

Dec 2, 20131.131.131.081.1017,649Nov 29, 20131.081.151.081.1331,458Nov 27, 20131.231.301.071.08372,723Nov 26, 20131.021.231.001.221,163,205Nov 25, 20130.991.020.980.9811,700Nov 22, 20130.941.060.940.99124,704Nov 21, 20130.970.970.950.9528,698Nov 20, 20131.001.000.950.9516,395Nov 19, 20130.971.010.970.9925,200Nov 18, 20131.001.020.990.9922,500Nov 15, 20131.061.081.001.0139,540Nov 14, 20130.971.030.971.0144,055Nov 13, 20131.011.070.951.00156,171Nov 12, 20130.971.010.951.0014,700
So if you see, on November 26th the volume was in millions. If I do a search in the exploration (date set at 26th November) then it shows the security in the results.
However, If I do the search either today or any day after these days, the results are totally different. What I want is Metastock to accept all the stocks and tell me WHEN the crossover happened for the given period (that's another question, how do I set the period?) OR atleast the last position this crossover happened! But it just plain rejects the security and moves on to the next one!

How can this be fixed?

Many thanks in advance!

Rocky
Back to top
wabbit  
#4 Posted : Tuesday, March 25, 2014 5:34:54 PM(UTC)
wabbit

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)
Alert()
Back to top
henry1224  
#5 Posted : Tuesday, March 25, 2014 6:42:21 PM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 3 time(s) in 3 post(s)
Rocky, Your code only looks at volume as a whole. It doesn't take bullish volume vs bearish volume into any sort of context.

If you look at any single bar it has an open ,high ,low and a close.
The bulls control from the open to the high and also from the low to the close
The bears control from the open to the low and from the high to the close
Back to top
RockstarRky  
#6 Posted : Tuesday, March 25, 2014 9:55:42 PM(UTC)
RockstarRky

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/24/2014(UTC)
Posts: 6
Hello Wabbit Sir,

how are you?

Welcome back to this forum. I noticed earlier that you were the topmost contributor on this website but hadn't logged in to this site for a long time. I think ever since Metastock was sold to this new company Innovative Market Analysis.

Ok, I have been a little bit confused about how to use the Alert function in Metastock Exploration. How do I connect it with the Volume in Column A?

I am trying to add this to the filter:

AND alert(Volume,)

and it keeps telling me that a "Number, variable assigned a number or LastValue() expected." How do I fix that respected sir?

Thank you in advance, and once again, Welcome back Wabbit Sir!!
Back to top
RockstarRky  
#7 Posted : Tuesday, March 25, 2014 9:58:35 PM(UTC)
RockstarRky

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/24/2014(UTC)
Posts: 6
Hello Henry Sir,

Thank you for your response on here. Like I said, please forgive my ignorance as I am new to trading in general and Metastock too.

So how do I fix this issue?

What I want to do is to find the "creepy upsurge" in volume (that usually goes unnoticed by general investors) that might happen in 14 or even 30 days.

Thanks in advance,

Rocky
Back to top
wabbit  
#8 Posted : Wednesday, March 26, 2014 2:15:26 AM(UTC)
wabbit

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)
Code:

Col A: VolumeVolume
Col B: Avg. Vol.Mov(V,14,S)
Col C: PriceClose
Col D: % ChangeROC(CLOSE,1,Percent)
Col E: % Above(VOLUME - Mov(V,14,S)) / Mov(V,14,S) * 100
Filter: test:=V>Mov(V,14,S);
Alert(test,2);
Back to top
RockstarRky  
#9 Posted : Wednesday, March 26, 2014 7:16:16 AM(UTC)
RockstarRky

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/24/2014(UTC)
Posts: 6
Good Morning Wabbit Sir,

Perfect!!

Let me apologize in advance if I sound like a nagging baby. I know I'm asking too much. For now the filter works perfectly but it shows the latest occurrence whether its negative or positive. The filter should be able to find the LATEST POSITIVE 1 day volume surge occurrence. Can we also have a date column where it will show us the date it occurred?, Another thing is that I don't want the decimals when the Day of the Month () or Month () or Year () formulae have been used. Is that possible?

I know I am asking too much now but I think you can do it. I have seen your posts on here and I know what you are capable of! Has Jose Silva Sir stopped using the website entirely? You guys had a great thing going on here! I saw the posts from earlier and I was amazed by your formulae creating geniuses!

Thank you in advance and sorry for any inconvenience I may caused,

Rocky

P.S. Please forgive me for using CAPS.
Back to top
wabbit  
#10 Posted : Wednesday, March 26, 2014 8:30:10 AM(UTC)
wabbit

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)
You've seen the use of the Alert() function, so armed with this knowledge and you User Manual, you should be able to create your own filter conditions.

As for the dates: it's not an easy thing to do in MS, due to the fact that all numbers are stored as float data-types which suffer from rounding precision loss, and the explorer always displays decimal places in its columns - - get used to reading them.
Back to top
RockstarRky  
#11 Posted : Wednesday, March 26, 2014 8:44:58 AM(UTC)
RockstarRky

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/24/2014(UTC)
Posts: 6
Thank You Wabbit Sir!

I will try and write the filter myself but for now this code will do! So I am updating this thread as resolved!!

Thank you for all your help!

Rocky
Back to top
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.

Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET