[R-sig-finance] Re: average values for time series
Massimo Sabbatini
sabbatini at deanovell.unian.it
Fri Apr 29 12:19:34 CEST 2005
Dear all,
I kind of solved the problem:
if I set
Sys.setlocale("LC_ALL", "en")
then priceIts works. It's a locale issue, then. But I have no clue how
to properly fix it. Do you have suggestions ?
Best regards,
Massimo
Achim Zeileis wrote:
> On Fri, 29 Apr 2005 09:01:33 +0200 Massimo Sabbatini wrote:
>
>
>>Dear all,
>>I followed Dirk's suggestions and got:
>>
>> > IBM <- priceIts("IBM",quote="Close")
>>Errore in validObject(.Object) : invalid class "its" object: Missing
>>values in dates
>>
>>I tried with other securities but I get the same error.
>>
>>x1 <- priceIts(instrument=c("^ftse"), start="1998-01-01", quote =
>>"Close") Errore in validObject(.Object) : invalid class "its" object:
>>Missing values in dates
>>
>>I would appreciate if you could give me any hints.
>
>
> I cannot reproduce the error above using its 1.0.4 and R 2.1.0. For me
> the above works smoothly.
> Z
>
>
>>Best regards,
>>Massimo
>>
>>
>>
>>Dirk Eddelbuettel wrote:
>>
>>>On 27 April 2005 at 06:37, Jonathan Q. wrote:
>>>| New to R, currently use FAME. One of the things I like about FAME
>>>| is that if I have a series, say the near month for a commodity, I
>>>| can set the series property so when i view weekly data, the data
>>>| is the average of the daily data. alternatively, for other series
>>>| like stock
>>>
>>>There are probably several ways to do that.
>>>
>>>| prices I can have the series always display the last value (i.e.,
>>>| monthly would take last value in month vs the average). also able
>>>| to
>>>
>>>The its package does that pretty well:
>>>
>>>
>>>
>>>>library(its) ## verbose output suppressed here
>>>>IBM<-priceIts("IBM",quote="Close") ## fetches from Yahoo!
>>>>head(IBM)
>>>
>>> IBM Close
>>>1991-01-02 112.12
>>>1991-01-03 112.50
>>>1991-01-04 112.12
>>>1991-01-07 110.25
>>>1991-01-08 109.00
>>>1991-01-09 106.87
>>>
>>>
>>>>head(extractIts(IBM, find="last", period="week"))
>>>
>>> IBM Close
>>>1991-01-04 112.12
>>>1991-01-11 108.12
>>>1991-01-18 117.62
>>>1991-01-25 122.62
>>>1991-02-01 126.87
>>>1991-02-08 129.50
>>>
>>>
>>>>head(extractIts(IBM, find="last", period="month"))
>>>
>>> IBM Close
>>>1991-01-31 126.75
>>>1991-02-28 128.75
>>>1991-03-28 113.87
>>>1991-04-30 103.00
>>>1991-05-31 106.12
>>>1991-06-28 97.12
>>>
>>>I just taught myself how to the other part with zoo -- pretty slick:
>>>
>>>
>>>
>>>>library(zoo) ## once again verbose output nixed
>>>>IBMzoo <- zoo(IBM) ## turn its object into zoo object
>>>>head(aggregate(IBMzoo, format(dates(IBM), "%Y-%m"), mean))
>>>
>>>
>>>1991-01 115.4127
>>>1991-02 132.2053
>>>1991-03 123.3240
>>>1991-04 109.6800
>>>1991-05 104.2241
>>>1991-06 100.8970
>>>
>>>
>>>This runs aggregate() over the zoo() object where the on-the-fly
>>>factor is computed from the underlying POSIXt date representation,
>>>and the aggregating function, here mean, is then passed over each
>>>unique factor set.
>>>
>>>Hope this helps, Dirk
>>>
>>
>>_______________________________________________
>>R-sig-finance at stat.math.ethz.ch mailing list
>>https://stat.ethz.ch/mailman/listinfo/r-sig-finance
>>
>
>
More information about the R-sig-finance
mailing list