[R-SIG-Finance] timeSeries 2 zoo convert

R. Michael Weylandt michael.weylandt at gmail.com
Tue Apr 17 19:43:36 CEST 2012


Following up on what Josh said, does it work with the built-in data
set MSFT provided by timeSeries?

library(xts)
library(timeSeries)

data(MSFT)

head(MSFT)
head(as.xts(MSFT))
head(as.zoo(MSFT))

all give the same dates for me.

Michael

On Tue, Apr 17, 2012 at 1:39 PM, Joshua Ulrich <josh.m.ulrich at gmail.com> wrote:
> On Tue, Apr 17, 2012 at 12:27 PM, Costas Vorlow <costas.vorlow at gmail.com> wrote:
>> Hello,
>>
>> What is the "best"   way to convert an timeSeries object to .zoo?
>>
> Generally, as.zoo is preferred.
>
>> Say I have  the following timeSeries object:
>>
>>> is(x)
>> [1] "timeSeries" "structure"  "vector"
>>> head(x)
>> GMT
>>            DAAA
>> 1983-01-03 11.77
>> 1983-01-04 11.79
>> 1983-01-05 11.79
>> 1983-01-06 11.74
>> 1983-01-07 11.74
>> 1983-01-10 11.75
>>>
>>
>> When I try to convert it to zoo, I can not retain the dates info. I tried:
>>
>>        a<-as.Date(index( x ))
>>        xz<-as.zoo(x)
>>        index(xz)<-a
>>
>> but dates change.
>>
>>  head(xz)
>>            DAAA
>> 1970-01-02 11.77
>> 1970-01-03 11.79
>> 1970-01-04 11.79
>> 1970-01-05 11.74
>> 1970-01-06 11.74
>> 1970-01-07 11.75
>>
> That's because you changed the dates.  Look at the output of:
>
> R> index(x)
>  [1] 1 2 3 4 5 6 7 8 9 10
>
> There's no index.timeSeries method, so index.default is dispatched.
> xz <- as.zoo(x) should be sufficient.
>
>
>> This used to work with last year's libraries but it seems it doesn't anymore:
>>
>>                a<-index(as.zoo(x))
>>                xz<-as.zoo(x)
>>                xnew<-aggregate(xz, as.Date, identity)
>>
>> Error in as.Date.default(index(x)) :
>>  do not know how to convert 'index(x)' to class "Date"
>>
> This is different from your example above.  Further, this works for me
> on R-2.15.0 with timeSeries_2130.92, timeDate_2131.00, and zoo_1.7-7.
> Your R version is a year old and timeDate and zoo are a couple minor
> versions behind.  Maybe updating will solve your problem?
>
>>
>> Any help, extremely welcome.
>>
>> thanks in advance,
>> Costas
>>
>>
>>> sessionInfo()
>> R version 2.13.0 (2011-04-13)
>> Platform: i386-pc-mingw32/i386 (32-bit)
>>
>> locale:
>> [1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United
>> States.1252
>> [3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C
>> [5] LC_TIME=English_United States.1252
>>
>> attached base packages:
>> [1] graphics  grDevices datasets  stats     utils     methods   base
>>
>> other attached packages:
>>  [1] fImport_2110.79              timeSeries_2130.92
>>  [3] timeDate_2130.93             fMarkovSwitching_1.0
>>  [5] Rdonlp2_0.3-1                rcom_2.2-3.1
>>  [7] rscproxy_1.3-1               quantmod_0.3-17
>>  [9] TTR_0.21-0                   Defaults_1.1-1
>> [11] PerformanceAnalytics_1.0.3.2 xts_0.8-2
>> [13] zoo_1.7-4
>>
>> loaded via a namespace (and not attached):
>> [1] grid_2.13.0     lattice_0.19-33 tools_2.13.0
>>>
>>
>>
>> --
>>
>> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
>> |c|o|s|t|a|s|@|v|o|r|l|o|w|.|o|r|g|
>> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
>>
>
>
> --
> Joshua Ulrich  |  FOSS Trading: www.fosstrading.com
>
> R/Finance 2012: Applied Finance with R
> www.RinFinance.com
>
> _______________________________________________
> R-SIG-Finance at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions should go.



More information about the R-SIG-Finance mailing list