Average volume above 50 day average volume

[keithmj]

Getting the 50 day average volume is pretty simple. However, I'm having a bit of a struggle figuring out how to get the average volume that's above the 50 day average volume.

My original thought was to sum up the volume bars that were above the 50 day average. Something like:

big_vol = if volume > avg_vol then volume + big_vol;

Since I can't use the variable within the definition of the variable, that won't work. I'm thinking in terms of a regular programming language and having a hard time doing what I want within the limits of a scripting language. Can anyone lend a hand?

 

[TradersCustom]

I'm a little confused as to what exactly you're trying to accomplish -

• Is your 50 day average volume simply the 50 volume SMA on the daily aggregation period?
• Are you then trying to find out what the 'average volume' is for the daily bars which exceed this 50 day average?

 

[SleepyZ]

Getting the 50 day average volume is pretty simple. However, I'm having a bit of a struggle figuring out how to get the average volume that's above the 50 day average volume.

My original thought was to sum up the volume bars that were above the 50 day average. Something like:

big_vol = if volume > avg_vol then volume + big_vol;

Since I can't use the variable within the definition of the variable, that won't work. I'm thinking in terms of a regular programming language and having a hard time doing what I want within the limits of a scripting language. Can anyone lend a hand?

See if this helps. You can view the test bubbles to see where the computations originated.

plot vavg  = VolumeAvg().VolAvg;
def vabove = if volume > vavg then vabove[1] + volume else vabove[1];
def vcount = if volume > vavg then vcount[1] + 1 else vcount[1];
addlabel(1, "Vol above VolAvg || " + vabove + " ||  # " + vcount + " || Avg Above " + round(vabove/vcount,0), color.white);

input test = yes;
AddChartBubble(test, low * .995, vcount + "\n " + vabove + "\n" + volume, Color.GRAY);

 

[keithmj]

Not exactly. Sorry if that was confusing.

I have the 50 day volume average:
plot avg_vol = Average(volume, 50);

From there, I want to get the average volume that is above that 50 day average. So, I need to figure out how many days the volume was above the 50 and count the total sum of volume from each of those days. Then divide that total by the number of days it was over the 50.

I've been playing around with it since I posted and think I'm getting somewhere. I may be on the right track, but not quite there yet.

 

[SleepyZ]

Not exactly. Sorry if that was confusing.

I have the 50 day volume average:
plot avg_vol = Average(volume, 50);

From there, I want to get the average volume that is above that 50 day average. So, I need to figure out how many days the volume was above the 50 and count the total sum of volume from each of those days. Then divide that total by the number of days it was over the 50.

I've been playing around with it since I posted and think I'm getting somewhere. I may be on the right track, but not quite there yet.

That is what the above code and label display is when the volume is above the 50 day average, it is accumulated along with the count of those bars to create the average

 

[keithmj]

Yes, thankyou again! I figured it out, but your way looks more elegant. I'm going to give your way a closer look.