XTS Modification

It would upload this data to a Postgresql server.



Regards,

SMS



 _____

From: malcolm croucher [mailto:malcolm.croucher at gmail.com]
Sent: Wednesday, October 22, 2008 8:02 PM
To: Wayne.W.Jones at shell.com
Cc: sms.chauhan at mu-sigma.com; r-sig-finance at stat.math.ethz.ch
Subject: Re: [R-SIG-Finance] XTS Modification



Would this package allow you to upload straight to a mysql or sql database ?

Regards

Malcolm

On Wed, Oct 22, 2008 at 4:10 PM, <Wayne.W.Jones at shell.com> wrote:



Another method would be to use the package RODBC.

Wayne





-----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 SMS CHAUHAn
Sent: 22 October 2008 14:40
To: r-sig-finance at stat.math.ethz.ch
Subject: [R-SIG-Finance] XTS Modification


Hi,

I am a newbie to R.

I am trying to write some stock data to a csv file.

Here is the code.



<code>

library(xts)

library(Defaults)

library(quantmod)

library(TTR)

getSymbols("IBM")

write.csv(IBM, file="IBM.csv")

</code>



Later I would use this csv file to write data into an SQL database. Here is
where I face the problem. In the tool I will be using, column headers have
to be mapped between csv and SQL fields. In the CSV file I get, the date
column does not have any column header. There is a workaround to edit the
csv and add the column header. But can I dynamically add the date id field
as a regular field in the xts data above before I write it to the csv.



Thanks,

SMS Chauhan


***********************************************************************
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies and the original message. Any
unauthorized review, use, disclosure, dissemination, forwarding, printing or
copying of this email or any action taken in reliance on this e-mail is
strictly prohibited and may be unlawful.

 The recipient acknowledges that Mu Sigma or its subsidiaries and associated
companies (collectively " Mu Sigma Inc), are unable to exercise control or
ensure or guarantee the integrity of over the contents of the information
contained in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and no binding
nature of the message shall be implied or assumed unless the sender does so
expressly with due authority of Mu Sigma. Before opening any attachments
please check them for viruses and defects.
 ***********************************************************************

      [[alternative HTML version deleted]]