Dear all,

I have the following cell matrix

A={

` '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

`24*4.1583+ 6*3.9389`

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:

`11*4.0339+?`

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

thanks

## Best Answer