[R-SIG-Finance] Help with getSymbols from csv data file

Joshua Ulrich josh.m.ulrich at gmail.com
Sat Jan 28 02:58:07 CET 2012


Hi Jun,

Specifying the date format via setSymbolLookup fixes it.  I'm not sure
if there is a more general solution.

setSymbolLookup(test=list(src="csv",format="%Y-%m-%d"))
getSymbols('test',src='csv')

Best,
--
Joshua Ulrich  |  FOSS Trading: www.fosstrading.com



On Fri, Jan 27, 2012 at 7:40 PM, Jun Zhu <junzhu98 at yahoo.com> wrote:
> I did a simple test to read from csv file using the following commands:
> getSymbols('GOOG')write.csv(file='test.csv', data.frame(GOOG) )getSymbols('test',src='csv')head(TEST)
> I am puzzled by the result that always show the same date which is 'today'.Any help on this will be greatly appreciated.
> thanks,
> Jun
> ===== result ===============2012-01-27    646.50    647.00   621.23     622.46     5822600        622.462012-01-27    629.75    633.80   616.91     623.14     4395600        623.142012-01-27    623.50    629.39   621.12     625.96     2400000        625.962012-01-27    631.22    632.89   626.50     629.64     1875200        629.642012-01-27    626.26    626.95   621.06     624.99     2307300        624.992012-01-27    631.98    631.98   625.68     628.58     1909300        628.582012-01-27    626.63    634.00   622.12     632.91     2761700        632.912012-01-27    640.99    640.99   631.46     639.57     6276500        639.572012-01-27    590.53    591.00   581.70     585.99    10576300        585.992012-01-27    586.00    588.66   583.16     585.52     3412900        585.522012-01-27    586.32    587.68   578.00
>  580.93     3055800        580.932012-01-27    577.51    578.71   566.38     569.49     4987700        569.492012-01-27    571.98    574.48   564.55     568.10     3226200        568.10
>
>
>
>
>        [[alternative HTML version deleted]]
>
>
> _______________________________________________
> R-SIG-Finance at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions should go.



More information about the R-SIG-Finance mailing list