I have the following cell matrix
'24/09/2000' [4.1583]'22/10/2000' [3.9389]'19/11/2000' [4.3944]'17/12/2000' [3.9313]'14/01/2001' [3.9313]'11/02/2001' [3.9313]'11/03/2001' [4.0339]}
I can easily convert the above data points to monthly averages; through the calculation of the weighted average between successive observations.
For instance for the first observation I have
where 24 is the 24 days from month Octomber and 6=(last date of the month-24=30-24) The only problem is how to treat the last observation:
One way is to extrapolate but I do not consider this method reliable. The above values are prices. So could I apply some other way? Maybe forecasting taking into account seasonality?
Any help/code provided will greatly appreciated