R
Rob_NZ
Hi,
Im strugling with this whole VBA code which I'm slowly trying to
learn.
Heres what I wish to do
I have daily dates from 1-Jan-94 all the way to 31-Dec-03 in column A
(starting in row 5)
In column C, I have the daily share prices (also starting in row 5)
In column F, I wish to work out the average returns of the last 5 days
of each month i.e =average(x:x) where x=the share prices for the last 5
days of Jan, feb and so on.
I hope my explanation is clear.
I am trying to do all this in VBA Code and my worksheet name is called
"Results"
Can anyone help me out?
Cheers
Rob
Im strugling with this whole VBA code which I'm slowly trying to
learn.
Heres what I wish to do
I have daily dates from 1-Jan-94 all the way to 31-Dec-03 in column A
(starting in row 5)
In column C, I have the daily share prices (also starting in row 5)
In column F, I wish to work out the average returns of the last 5 days
of each month i.e =average(x:x) where x=the share prices for the last 5
days of Jan, feb and so on.
I hope my explanation is clear.
I am trying to do all this in VBA Code and my worksheet name is called
"Results"
Can anyone help me out?
Cheers
Rob