How can I find a 52 week average of volume and price of any given stock? - Aussie Stock Forums

# Thread: How can I find a 52 week average of volume and price of any given stock?

1. ## How can I find a 52 week average of volume and price of any given stock?

Also Can Amibroker help with that?? I need to find the average liquidity of a given stock.

Thanks

2. ## Re: How can I find a 52 week average of volume and price of any given stock?

Also Can Amibroker help with that?? I need to find the average liquidity of a given stock.

Thanks
Plot a moving average on the volume....presto.

3. ## Re: How can I find a 52 week average of volume and price of any given stock?

Originally Posted by CanOz
Plot a moving average on the volume....presto.
But I need a single number average for a 52 week period not different averages at different times and need that for price as well.

4. ## Re: How can I find a 52 week average of volume and price of any given stock?

So, something like:

LiquidityCheck = MA( C * V, 50 );

5. ## Re: How can I find a 52 week average of volume and price of any given stock?

But I need a single number average for a 52 week period not different averages at different times and need that for price as well.
Have you tried on

www.yahoofinance.com

6. ## Re: How can I find a 52 week average of volume and price of any given stock?

Prices of last 52 weeks in Excel then =AVERAGE(highlight price column), push enter. Then in a different cell, do the exact same thing but highlight the Volume column instead.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
Aussie Stock Forums