Dear friends
I need help here; I have daily data on trading volume- which i hope to develop some measure. the first step is to take a monthly average and spread it through every trading day. for example take stock A-i would wish to obtain the average volume for month 1 and the spread that average on every day. the real issue is that the sheet has about 60000 lines and so doing a manual work would take alot of effort and time. kindly help me with how i can program this task.
Date volume Monthly_average
6-Jan-09 697 28762.36842
7-Jan-09 1835 28762.36842
8-Jan-09 500 28762.36842
9-Jan-09 114300 28762.36842
12-Jan-09 800 28762.36842
13-Jan-09 14100 28762.36842
14-Jan-09 3100 28762.36842
15-Jan-09 132034 28762.36842
16-Jan-09 33000 28762.36842
19-Jan-09 34000 28762.36842
20-Jan-09 49900 28762.36842
21-Jan-09 3500 28762.36842
22-Jan-09 3275 28762.36842
23-Jan-09 21513 28762.36842
26-Jan-09 112300 28762.36842
27-Jan-09 16431 28762.36842
28-Jan-09 2700 28762.36842
29-Jan-09 2000 28762.36842
30-Jan-09 500 28762.36842