# How to scan for stocks with volume of the current day n times the average volume of the previous m days?

#### hQrGrIg8lY

##### New member
I see the following code to scan for average volume above a threshold. I'd like to scan stocks who today's volume is n times the average volume of previous m days.

`Average()` does not have a parameter to skip the current day.

Does anybody know how to adjust the code to do the task that I want to solve?

Code:
``````input price = volume;
input length = 50;
input averageType = {default Simple, Exponential, Weighted, Wilders, Hull};
input choice2 = {default "greater than", "less than"};
input Choice   = 1000000;

def avg;
switch (averageType) {
case Simple:
avg = Average(price, length);
case Exponential:
avg = ExpAverage(price, length);
case Weighted:
avg = wma(price, length);
case Wilders:
avg = WildersAverage(price, length);
case Hull:
avg = HullMovingAvg(price, length);
}

plot scan;

switch (choice2) {
case "greater than":
scan = avg > choice;
case  "less than":
scan = avg < choice;
}``````

Solution
avg[1] > choice

Basically, with a 3 day average, for example; on day 4 it will average days 3, 2, and 1. It will not include day 4 in the average. Therefore, the incomplete sum of daily volume, while the market is still open for the current day, will not drag down the average. This is your goal, correct?
You can probably just offset it by [1]

You can probably just offset it by [1]
Do you mean to use
Code:
``Average(price[1], length)``
?

avg[1] > choice

Basically, with a 3 day average, for example; on day 4 it will average days 3, 2, and 1. It will not include day 4 in the average. Therefore, the incomplete sum of daily volume, while the market is still open for the current day, will not drag down the average. This is your goal, correct?

87k+ Posts
170 Online

## The Market Trading Game Changer

Join 2,500+ subscribers inside the useThinkScript VIP Membership Club
• Exclusive indicators
• Proven strategies & setups
• Private Discord community
• Exclusive members-only content
• 1 full year of unlimited support

What is useThinkScript?

useThinkScript is the #1 community of stock market investors using indicators and other tools to power their trading strategies. Traders of all skill levels use our forums to learn about scripting and indicators, help each other, and discover new ways to gain an edge in the markets.

How do I get started?

We get it. Our forum can be intimidating, if not overwhelming. With thousands of topics, tens of thousands of posts, our community has created an incredibly deep knowledge base for stock traders. No one can ever exhaust every resource provided on our site.

If you are new, or just looking for guidance, here are some helpful links to get you started.

What are the benefits of VIP Membership?