[R] reading and formating irregular time series for VaR

[Gabor Grothendieck]

If you are using the zoo package and if we assume:
- your file contains a single time series and
- the last column is junk
then try this:

library(zoo)
DF <- read.csv("myfile.dat")
z <- zoo(as.matrix(DF[2:7]), as.Date(DF[[1]]))

Read the documents at the end of
   http://cran.r-project.org/src/contrib/Descriptions/zoo.html
for more info.

On 9/9/06, Anupam Tyagi <AnupTyagi at yahoo.com> wrote:
> Hi, I am trying to read the following type of data from a .csv file to form an
> irregular time series object. I want to use it with the VaR package. How do I
> read it in correctly to an irregular time series object? Anupam.
>
> date,Open,High,Low,Close,Volume,OpenInterest,Contract
> 1972-08-16,54.25,54.25,54.25,54.25,1,1,KC1973H
> 1972-08-17,54.25,54.25,54.25,54.25,0,1,KC1973H
> 1972-08-18,54.25,54.25,54.25,54.25,0,1,KC1973H
> 1972-08-21,54.25,54.25,54.25,54.25,0,1,KC1973H
> 1972-08-22,54.25,54.25,54.25,54.25,0,1,KC1973H
> 1972-08-23,54.25,54.25,54.25,54.25,0,1,KC1973H
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>