An embedded and charset-unspecified text was scrubbed... Name: not available Url: https://stat.ethz.ch/pipermail/r-sig-finance/attachments/20070522/28011a37/attachment.pl
readcsvIts
2 messages · Vorlow Constantinos, Armstrong, Whit
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.