[R] R-help Digest, Vol 93, Issue 5

[Joshua Ulrich]

On Fri, Nov 5, 2010 at 6:00 AM,  <r-help-request at r-project.org> wrote:
> Send R-help mailing list submissions to
>        r-help at r-project.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        https://stat.ethz.ch/mailman/listinfo/r-help
> or, via email, send a message with subject or body 'help' to
>        r-help-request at r-project.org
>
> You can reach the person managing the list at
>        r-help-owner at r-project.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of R-help digest..."
>
>
> Message: 121
> Date: Fri, 5 Nov 2010 09:28:51 +0100
> From: spela podgorsek <spelca27 at gmail.com>
> To: r-help at r-project.org
> Subject: [R] as.xts
> Message-ID:
>        <AANLkTinu6A-Y3O9Jw+jHypRAD+1tsRHZunNoWWu295XC at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> hey
>
> I am trying to turn a dataframe into xts with the function:
> as.xts,
> but it returns the error:
>
> Error in as.POSIXlt.character(x, tz, ...) :
> character string is not in a standard unambiguous format
>
> could someone give me some pointers please
>
> the data is coming from a spreadsheet via the excel, and has 5 columns
> of data (date (with the date and time), open, high, low, close) (excel
> format)
>
> ela
>

as.xts.data.frame expects the rownames of the data.frame to contain
the dates/times.  It would probably be easier to use the xts
constructor on your data.frame:

xData <- xts(Data[,-1],Data[,1])  # assumes "date" in first column

You will need to ensure that Data[,"date"] is a time-based class (e.g.
Date, POSIXt).  If it is character, you will need to convert it to a
time-based class before calling xts().

Best,
--
Joshua Ulrich  |  FOSS Trading: www.fosstrading.com

>
> _______________________________________________
> R-help at r-project.org 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.
>
> End of R-help Digest, Vol 93, Issue 5
> *************************************
>