Am confirming what Phil said ...
getSymbols(SPY, src=yahoo, from=2012-06-01)
[1] SPY
to.monthly(SPY) # looks correct
SPY.Open SPY.High SPY.Low SPY.Close SPY.Volume SPY.Adjusted
Jun 2012 129.41 136.27 127.14136.10 3644670300 134.42
Jul 2012 136.48 139.34 132.60
Actually Ulrich,
I am getting something different than you but equally incorrect.
to.monthly(SPY) # looks correct
SPY.Open SPY.High SPY.Low SPY.Close SPY.Volume SPY.Adjusted
Jun 2012 129.41 136.27 127.14136.10 3644670300 134.42
Jul 2012 136.48 139.34 132.60137.71
Works fine for me, even with your timezone.
Lines - 2013-01-30;100
+ 2013-01-31;101
+ 2013-02-01;102
library(xts)
Sys.setenv(TZ=Europe/Berlin)
x1 - read.zoo(con - textConnection(Lines), sep=;)
close(con)
as.POSIXct(index(x1))
[1] 2013-01-30 01:00:00 CET 2013-01-31 01:00:00 CET
[3]
Here's my session info.
I'll upgrade XTS and will let you know if I progress.
sessionInfo()
R version 2.15.1 (2012-06-22)
Platform: i686-pc-linux-gnu (32-bit)
locale:
[1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C
[3] LC_TIME=en_US.UTF-8LC_COLLATE=en_US.UTF-8
[5] LC_MONETARY=en_US.UTF-8
Works with xts 0.9-3:
Lines - 2013-01-30;100
+ 2013-01-31;101
+ 2013-02-01;102
require(xts)
Loading required package: xts
Loading required package: zoo
Attaching package: ‘zoo’
The following object(s) are masked from ‘package:base’:
as.Date, as.Date.numeric
x1 - read.zoo(con -