[R-SIG-Finance] [xts] merge function weird behaviour

Anass Mouhsine anass.mouhsine at gmail.com
Fri Dec 10 09:12:08 CET 2010


Hi all,

I encountered a weird behaviour of merge function while using it with 
xts objects.
I have multiple xts objects (10 timeseries) that I want to merge in 
order to conduct a multivariate analysis.
Here is an example with only two timeseries

#Let us define the time series
 > t1
                                        Close
2007-01-02                  97.87
2007-01-03                  97.32
2007-01-04                  96.04
2007-01-05                  95.97
2007-01-07                  95.69
2007-01-08                  96.23
 > t2
                                        Close
2007-01-02                  94.59
2007-01-03                  94.38
2007-01-04                  92.55
2007-01-05                  92.37
2007-01-07                  92.23
2007-01-08                  92.89
 > c(class(t1),class(t2))
[1] "xts" "zoo" "xts" "zoo"

#I do the merge using merge.xts
 > t<-merge(t1,t2)
 > t
                                        Close                 Close
2007-01-02                  97.87                     NA
2007-01-02                     NA                  94.59
2007-01-03                  97.32                  94.38
2007-01-04                  96.04                  92.55
2007-01-05                  95.97                     NA
2007-01-05                     NA                  92.37
2007-01-07                  95.69                     NA
2007-01-07                     NA                  92.23
2007-01-08                  96.23                  92.89

# I don't see where the problem lays since both xts objects have the 
same index
 > index(t1)
[1] "2007-01-02" "2007-01-03" "2007-01-04" "2007-01-05" "2007-01-07" 
"2007-01-08"
 > index(t2)
[1] "2007-01-02" "2007-01-03" "2007-01-04" "2007-01-05" "2007-01-07" 
"2007-01-08"

# I tried using join but with no satisfying result
 >t<-merge(head(t1),head(t2),join='inner')
 > t
            CHFJPY..2007.....Close AUDJPY..2007.....Close
2007-01-03                  97.32                  94.38
2007-01-04                  96.04                  92.55
2007-01-08                  96.23                  92.89

I am really out of tricks here :-[ .

So if someone is kind enough as to point me towards the right direction, 
it would make my day.

Thx in advance,

Anass



More information about the R-SIG-Finance mailing list