[R-SIG-Finance] How to get data from different time zones (e.g. USA, EU, Asia) in the same format

Gabor Grothendieck ggrothendieck at gmail.com
Sun Aug 17 14:53:11 CEST 2008


merge.zoo does that:

merge(z1, z2)

See ?merge.zoo

Note that unlike zoo in the core of R which can only merge two objects
at a time merge.zoo
can merge multiple objects so if L is a list of such zoo objects you can write:

do.call("merge.zoo", L)



On Sun, Aug 17, 2008 at 8:19 AM, Bastian Offermann
<bastian2507hk at yahoo.co.uk> wrote:
> Hello,
>
>
>
> I am currently analyzing market data retrieving data sets from yahoo with
> the get.hist.quote function in the Performance Analytics package.
>
>
>
> ############ Data Import Sheet ##############
>
>
>
> ticker<-c("^GSPC", "^GDAXI")
>
>
>
>
>
> # Time horizon
>
>
>
> from <- "1992-01-03"              # of type "YYYY-MM-DD"
>
> till <- "2007-12-31"
>
>
>
> # Return frequency
>
>
>
> freque <- c("d", "w", "m", "y")
>
> fq <- 1                             # input 1 for "d", 2 for "w" etc.
>
>
>
>
>
> # Benchmark
>
> benchmark <- get.hist.quote(ticker[1], start = from, end = till,
> compression=freque[fq], quote="Close")
>
> benchmark2 <- get.hist.quote(ticker[2], start = from, end = till,
> compression=freque[fq], quote="Close")
>
>
>
> Now, both benchmarks are zoo objects with an attached index. Unfortunately,
> due to holidays etc both series do neither have identical indices nor the
> same length (in most cases, sometimes they do by chance).
>
> I have been trying to address this problem for quite some time now, but
> cannot find a solution to it.
>
>
>
> The problems arise as I usually store each series in a matrix format where
> the rows contain the assets and the columns the respective quotes or returns
> for a certain trading interval.
>
>
>
>            Quote 1 .. Quote 2 .. Quote N
>
> Asset1
>
>
>
> Asset 2
>
>
>
> ..
>
> ..
>
> ..
>
>
>
> Asset N
>
>
>
> Etc.
>
>
>
> What I ultimately want to do is to match both series, i.e. same time indices
> and same length.
>
>
>
> Do you have an idea how to overcome this? Thanks in advance.
>
>
>
> regards
>
>
>        [[alternative HTML version deleted]]
>
> _______________________________________________
> 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