I want to divide one series "x1" tail listed below by a second series "x2",
but the dates are not aligned, even though the start and end dates are the
same (I get a positions different error).  If I align them by days,
duplicate dates appear to fill in between monthly values.  Should I use
aggregate() to reconfigure the monthly series?  If so, which value of the
aggregate() argument FUN should I use to list only the last day of the month
(obviously not mean or sum)?    Thanks much for any help.

 

Unaligned series:

 

> tail(x1)

GMT

           WILL5000IND

2010-07-31    16421.36

2010-08-31    16509.87

2010-10-01    17094.89  <- out of sequence (Friday)

2010-10-31    17881.22

2010-12-01    18349.44

2010-12-31    19099.87 <- out of sequence

 

> tail(x2)

GMT

               TS.1

2010-07-31 14632.61

2010-08-31 14689.75

2010-09-30 14745.52

2010-10-31 14794.91

2010-11-30 14834.44

2010-12-31 14861.00

 

Aligned series:

 

> tail(x1a)

GMT

           WILL5000IND

2010-12-24    18349.44

2010-12-27    18349.44

2010-12-28    18349.44

2010-12-29    18349.44

2010-12-30    18349.44    <-Should be 2010-11-30, delete dates up to here in
this list

2010-12-31    19099.87 

 

> tail(x2a)

GMT

               TS.1

2010-12-24 14834.44

2010-12-27 14834.44

2010-12-28 14834.44

2010-12-29 14834.44

2010-12-30 14834.44

2010-12-31 14861.00

 

 


	[[alternative HTML version deleted]]

