[R-SIG-Finance] XTS Modification

[stefano iacus]

This book may be of some interest as well

http://www.springer.com/statistics/computational/book/978-0-387-74730-9

stefano

On 22/ott/08, at 17:05, Tyler Hammond wrote:

>
> You can also look into Rdbi and RdbiPgSQL from http:// 
> bioconductor.org.
> For inserting large datasets, psql with \copy is much faster.
>
>
> On 2008 Oct 22, at 10:53 AM, Jeff Ryan wrote:
>
>> Take a look at:
>>
>> http://cran.r-project.org/web/packages/RPostgreSQL/index.html
>>
>> or as Wayne mentioned RODBC.
>>
>> I have used neither yet.
>>
>> You might find it faster to use the database's own bulk import
>> mechanism with the csv files though.
>>
>> Jeff
>>
>> On Wed, Oct 22, 2008 at 9:46 AM, SMS CHAUHAn <sms.chauhan at mu-sigma.com 
>> > wrote:
>>> 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]]
>>>
>>> _______________________________________________
>>> 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.
>>>
>>> _______________________________________________
>>> 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.
>>>
>>>
>>>
>>>
>>> --
>>> Malcolm A.B Croucher
>>>
>>>
>>> ***********************************************************************
>>> 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]]
>>>
>>> _______________________________________________
>>> 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.
>>>
>>
>>
>>
>> -- 
>> Jeffrey Ryan
>> jeffrey.ryan at insightalgo.com
>>
>> ia: insight algorithmics
>> www.insightalgo.com
>>
>> _______________________________________________
>> 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 email is confidential, does not constitute investment advice, is
> only for the use of the intended recipient and should not be
> redistributed, except with the sender's consent. If you received this
> email in error, please notify us immediately by telephone; receipt by
> anyone other than the intended recipient is not a waiver of any
> work-product or attorney-client privilege. All email to and from
> Millburn Ridgefield Corporation and its affiliates is monitored,
> stored and made available to regulators if requested.
> ######################################################################
>
> _______________________________________________
> 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.