Re: [R] [R-SIG-Finance] readcsvIts

From: Vorlow Constantinos <CVorlow_at_eurobank.gr>
Date: Tue, 22 May 2007 18:26:52 +0300


Thanks.

This appears to do the trick.

Best regards,
Costas

-----Original Message-----
From: Armstrong, Whit [mailto:whit.armstrong_at_hcmny.com] Sent: Tuesday, May 22, 2007 6:14 PM
To: Vorlow Constantinos
Cc: r-sig-finance_at_stat.math.ethz.ch
Subject: RE: [R-SIG-Finance] readcsvIts

I believe you need:

its(readcsvIts("brenthf.csv",informat="%d/%m/%Y %H:%S"))

> -----Original Message-----
> From: r-sig-finance-bounces_at_stat.math.ethz.ch
> [mailto:r-sig-finance-bounces_at_stat.math.ethz.ch] On Behalf Of
> Vorlow Constantinos
> Sent: Tuesday, May 22, 2007 10:52 AM
> To: r-help@stat.math.ethz.ch
> Cc: r-sig-finance_at_stat.math.ethz.ch
> Subject: [R-SIG-Finance] readcsvIts
>
> Hello,
>
> I am trying to read a .CSV file from Bloomberg of prices (for an "its"
> series) of the following format:
>
> Date Price
> 23/10/2006 09:59 57.291
> 23/10/2006 10:01 57.221
> 23/10/2006 10:02 57.201
> 23/10/2006 10:03 57.231
> 23/10/2006 10:04 57.191
> 23/10/2006 10:05 57.191
> 23/10/2006 10:06 57.141
> 23/10/2006 10:07 57.081
>
>
> I get the following:
>
> > its.format("%d/%m/%Y %X")
> [1] "%d/%m/%Y %X"
> > brent<-its(readcsvIts(filename="brenthf.csv"))
> Error in validObject(.Object) : invalid class "its" object:
> Missing values in dates
> >
>
> What am I doing wrong? Used %H:%S as well but nothing improved...
>
> The csv file looks fine...
>
> Using the latest versions of R and its library on windows XP.
>
> Thanks in advance,
> Costas
>
> -------------------------------------------------------
> tel: +30-210-3337273 (ext 17273)
> fax: +30-210-3337687
>
>
>
>
> Disclaimer:
> This e-mail is confidential. If you are not the intended
> recipient, you should not copy it, re-transmit it, use it or
> disclose its contents, but should return it to the sender
> immediately and delete the copy from your system.
> EFG Eurobank Ergasias S.A. is not responsible for, nor
> endorses, any opinion, recommendation, conclusion,
> solicitation, offer or agreement or any information contained
> in this communication.
> EFG Eurobank Ergasias S.A. cannot accept any responsibility
> for the accuracy or completeness of this message as it has
> been transmitted over a public network. If you suspect that
> the message may have been intercepted or amended, please call
> the sender.
>
>
> [[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.
>

This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and delete the message and any attachment(s) from your system. Thank you.



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. Received on Tue 22 May 2007 - 15:32:59 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 22 May 2007 - 16:31:34 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.