[R-SIG-Finance] disaggregating weekly to daily series

Adrian Dragulescu adrian_d at eskimo.com
Wed Nov 14 04:40:41 CET 2007


You need a data.frame with the correspondece between your daily dates and
weekly dates.

week        day
1999-02-19  1999-02-15
1999-02-19  1999-02-16
... etc ...

than do: merge(correspondence.df, weekly.df, by="week", all.y=TRUE)

Adrian

On Wed, 14 Nov 2007, Ian Seow wrote:

> Hi guys, was wondering if there was any elegant function to transform
> a weekly financial timeseries into a daily series. The tricky part
> about the daily series is that it is irregular - it doesn't include
> trading holidays and weekends. Both date vectors weekly and daily are
> given.
>
> For instance:
>
> Weekly series:-
>
> 1999-02-19    128.72
> 1999-02-26    129.15
> 1999-03-05    131.76
> ... etc ...
>
> To this
>
> Daily series:-
>
> 1999-02-15    128.72
> 1999-02-16    128.72
> 1999-02-17    128.72
> 1999-02-18    128.72
> 1999-02-19    128.72
> 1999-02-22    129.15
> 1999-02-23    129.15
> 1999-02-24    129.15
> ... etc ...
>
> Thanks.
>
> Rgds
> Ian Seow
>
> _______________________________________________
> R-SIG-Finance at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only.
> -- If you want to post, subscribe first.
>



More information about the R-SIG-Finance mailing list