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 at 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.