Skip to Content
0
Mar 14, 2013 at 06:16 PM

Trade Average

15 Views

Dear All,

I have an issue in calculating average.Now with the below scenario friends can you help me to achieve the result.

my critieria is:

created calendar days in day ranges like 1-5, 6-10..

I need to sum first say for eg the day range between 1-5 and then take average of the stock between the same range 1-5
and simialr for other day ranges.

days DayRange Trade 12/1/2011 5 12/2/2011 5 12/3/2011 5 12/4/2011 5 12/5/2011 5 12/6/2011 10 12/7/2011 10 12/8/2011 10 12/9/2011 10 12/10/2011 10 12/11/2011 15 12/12/2011 15 12/13/2011 15 12/14/2011 15 12/15/2011 15 12/16/2011 20 12/17/2011 20 12/18/2011 20 12/19/2011 20 12/20/2011 20 12/21/2011 25 12/22/2011 25 12/23/2011 25 12/24/2011 25 12/25/2011 25 12/26/2011 30 12/27/2011 30 12/28/2011 30 12/29/2011 30 12/30/2011 30 12/31/2011 30 1/1/2012 5 1/2/2012 5 1/3/2012 5 1/4/2012 5 1/5/2012 5 1/7/2012 10 1/8/2012 10 1/9/2012 10 1/10/2012 10 1/11/2012 15 1/12/2012 15 455 1/13/2012 15 213 1/14/2012 15 213 1/15/2012 15 213 1/16/2012 20 345 1/17/2012 20 353 1/18/2012 20 145 1/19/2012 20 2434 1/20/2012 20 234 1/21/2012 25 234 1/22/2012 25 234 1/23/2012 25 44 1/24/2012 25 12 1/25/2012 25 55 1/26/2012 30 22 1/27/2012 30 22 1/28/2012 30 1/29/2012 30 53 1/30/2012 30 75 1/31/2012 30 34 2/1/2012 5 56 2/2/2012 5 21 2/3/2012 5 23 2/4/2012 5 23 2/5/2012 5 23 2/6/2012 10 53 2/7/2012 10 143 2/8/2012 10 43 2/9/2012 10 67 2/10/2012 10 26 2/11/2012 15 26 2/12/2012 15 87 2/13/2012 15 54 2/14/2012 15 43 2/15/2012 15 321 2/16/2012 20 2/17/2012 20 2/18/2012 20 45 2/19/2012 20 32 2/20/2012 20 35 2/21/2012 25 25 2/22/2012 25 63 2/23/2012 25 214 2/24/2012 25 74 2/25/2012 25 32 2/26/2012 30 64 2/27/2012 30 32 2/28/2012 30 567

Appreciate your help guys

Thanks,

Sara44