TIP of the week - Time Adjusted Average Volume (TAAV) formula
This formula gives you an indication of how today's volume compares to the 20-day average volume... adjusted for the current time of day.
A value of 1 is average volume, values over one indicate above average volume, values under 1 indicate below-average volume. For example, a value of 2.11 would tell you that the stock has traded over two times its normal average volume for this time of day.
Volume / ((MovingAverage[MA,Volume,20,0,D] / 390) * (((Hour * 60) + Minute) - 570))
NOTES: This formula is only valid during market hours.
The calculation divides the daily average volume into minutes, so it doesn't account for normal volume fluctuations (such as high volume at open). It can be helpful in finding "most actives".
Check out the iBox for prior TIPs.
