Thanks for looking into this extensively.  I will begin to test these alternatives!

My understanding from Worden search is this:

"Volume Buzz is based on the 100-Period Simple Moving Average of Volume over the previous 100 days (so not including today).

"The current Volume is compared to a percentage of the average volume which is directly proportional to the percentage of the trading day which has already passed. So at 10:15 AM ET, the current volume would be compared to about 11.54% of the 100-Day Simple Moving Average of Volume ending yesterday. If the result is +25%, it would mean that current Volume is about 14.42% of the average volume instead of 11.54% of the average volume."

From this, I see that "Relative Volume Ratio" referred to above, is based on much smaller bytes of volume, being based on 5-minutes versus 30-minutes. 

Is there any way to come up with a formula for these smaller bytes?

Bruce, I recently discovered a chart which showed a list of Relative Volume Ratios useful in daytrading.

One example on this chart showed a high Relative Volume Ratio:

Volume 5-minute %: 92,335.7

Volume 30-minute %:16,992.1

Relative Volume Ratio: 26.19

Another example on this chart showed a low Relative Volume Ratio:

Volume 5-minute %: 10,663.3

Volume 30-minute %: 2,111.7

Relative Volume Ratio: 2.48

First, can you explain how the Relative Volume Ratio was arrived at mathematically?

Second, can you provide a formula for a Relative Volume Ratio based on the same math as used in the above examples?

Thanks, again.

traderlady

I am an intraday trader who bases one of my decisions on bases that may have formed during a time period within the 60 minutes before the Open to 15 minutes after the Open.

(BTW, 9:00 am ET reads 3:00 on my chart which is set to ET.)

It would be so helpful to be able to freeze frame this 75 minute time period, perhaps on a separate chart, so that even after 9:45am ET, a trader can look back at other candidates during this timeframe.

Thanks for passing along my suggestion to Worden.

traderlady

Even old dogs can learn new tricks!  :>)  Thanks, Bruce.

Thanks for the complete explanation.  I'll try that.

I am not sure how to follow your instructions for how to transform your original formula into a 1-Ago formula when I want to use the 1-Ago as a column.

(I already know how to plot the Magnitude formula on a chart and how to place the original as a column)

Hi Bruce,

Through search, I found this useful PCF Indicator coded by you.  I intend to use this transformed into a 1-Ago indicator as a column. 

I've tested the original below as a column and it does work that way.

IIF(L > H1, 1, IIF(H < L1, -1, IIF(L > MINH2.1, 2, IIF(H < MAXL2.1, -2, IIF(L > MINH3.1, 3, IIF(H < MAXL3.1, -3, IIF(L > MINH4.1, 4, IIF(H < MAXL4.1, -4, IIF(L > MINH5.1, 5, IIF(H < MAXL5.1, -5, IIF(L > MINH6.1, 6, IIF(H < MAXL6.1, -6, IIF(L > MINH7.1, 7, IIF(H < MAXL7.1, -7, IIF(L > MINH8.1, 8, IIF(H < MAXL8.1, -8, IIF(L > MINH9.1, 9, IIF(H < MAXL9.1, -9, IIF(L > MINH10.1, 10, IIF(H < MAXL10.1, -10, IIF(L > MINH11.1, 11, IIF(H < MAXL11.1, -11, IIF(L > MINH12.1, 12, IIF(H < MAXL12.1, -12, IIF(L > MINH13.1, 13, IIF(H < MAXL13.1, -13, IIF(L > MINH14.1, 14, IIF(H < MAXL14.1, -14, IIF(L > MINH15.1, 15, IIF(H < MAXL15.1, -15, IIF(L > MINH16.1, 16, IIF(H < MAXL16.1, -16, IIF(L > MINH17.1, 17, IIF(H < MAXL17.1, -17, IIF(L > MINH18.1, 18, IIF(H < MAXL18.1, -18, IIF(L > MINH19.1, 19, IIF(H < MAXL19.1, -19, IIF(L > MINH20.1, 20, IIF(H < MAXL20.1, -20, IIF(L > MINH21.1, 21, IIF(H < MAXL21.1, -21, IIF(L > MINH22.1, 22, IIF(H < MAXL22.1, -22, IIF(L > MINH23.1, 23, IIF(H < MAXL23.1, -23, IIF(L > MINH24.1, 24, IIF(H < MAXL24.1, -24, IIF(L > MINH25.1, 25, IIF(H < MAXL25.1, -25, IIF(L > MINH26.1, 26, IIF(H < MAXL26.1, -26, IIF(L > MINH27.1, 27, IIF(H < MAXL27.1, -27, IIF(L > MINH28.1, 28, IIF(H < MAXL28.1, -28, IIF(L > MINH29.1, 29, IIF(H < MAXL29.1, -29, IIF(L > MINH30.1, 30, IIF(H < MAXL30.1, -30, IIF(L > MINH31.1, 31, IIF(H < MAXL31.1, -31, IIF(L > MINH32.1, 32, IIF(H < MAXL32.1, -32, IIF(L > MINH33.1, 33, IIF(H < MAXL33.1, -33, IIF(L > MINH34.1, 34, IIF(H < MAXL34.1, -34, IIF(L > MINH35.1, 35, IIF(H < MAXL35.1, -35, IIF(L > MINH36.1, 36, IIF(H < MAXL36.1, -36, IIF(L > MINH37.1, 37, IIF(H < MAXL37.1, -37, IIF(L > MINH38.1, 38, IIF(H < MAXL38.1, -38, IIF(L > MINH39.1, 39, IIF(H < MAXL39.1, -39, IIF(L > MINH40.1, 40, IIF(H < MAXL40.1, -40, IIF(L > MINH41.1, 41, IIF(H < MAXL41.1, -41, IIF(L > MINH42.1, 42, IIF(H < MAXL42.1, -42, IIF(L > MINH43.1, 43, IIF(H < MAXL43.1, -43, IIF(L > MINH44.1, 44, IIF(H < MAXL44.1, -44, IIF(L > MINH45.1, 45, IIF(H < MAXL45.1, -45, IIF(L > MINH46.1, 46, IIF(H < MAXL46.1, -46, IIF(L > MINH47.1, 47, IIF(H < MAXL47.1, -47, IIF(L > MINH48.1, 48, IIF(H < MAXL48.1, -48, IIF(L > MINH49.1, 49, IIF(H < MAXL49.1, -49, IIF(L > MINH50.1, 50, IIF(H < MAXL50.1, -50, 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Wow, are we lucky to have a master mathematician at Worden!

traderlady
 

Bruce, could you please include me in your Clear Method-ish indicators via TCMail?  Thanks!

traderlady

Hi Bruce,

This morning I&#39;ve been following a forum discussion from years ago in which you offered the following formula:

ABS(L = MINL5) * 1 - NOT(L = MINL5) * (
ABS(L1 = MINL5) * 2 - NOT(L1 = MINL5) * (
ABS(L2 = MINL5) * 3 - NOT(L2 = MINL5) * (
ABS(L3 = MINL5) * 4 - NOT(L3 = MINL5) * (
ABS(L4 = MINL5) * 5
))))

When I try using it, there&#39;s an error message, "Formula error near the -"

Can you please correct this?

traderlady