This function should really have more formal arguments -- especially the format argument.
As it is, the `format` will be set to "". You should be able to pass `format` through the dots, but there's a syntax bug preventing that from working (`list(...)[["format"]] <- NULL`). As it is, the only way to load your data using getSymbols.csv is to set the `format` argument in the Symbol Lookup table. (I saved the text from your e-mail in a file at "~/tmp/worik.txt") setSymbolLookup(worik=list(src='csv', format='%Y-%m-%d')) getSymbols('worik', dir='~/tmp', auto.assign=FALSE, extension='txt') WORIK.Open WORIK.High WORIK.Low WORIK.Close WORIK.Volume 2011-12-28 1.5968 1.5987 1.5762 1.5827 0 2011-12-29 1.5831 1.5846 1.5695 1.5724 0 2011-12-30 1.5726 1.5877 1.5704 1.5861 0 2011-12-31 1.5850 1.5861 1.5850 1.5861 0 2012-01-01 1.5850 1.5861 1.5820 1.5861 0 2012-01-02 1.5871 1.5875 1.5768 1.5802 0 2012-01-03 1.5800 1.5837 1.5726 1.5818 0 2012-01-04 1.5819 1.5865 1.5796 1.5813 0 2012-01-05 1.5812 1.5854 1.5730 1.5795 0 2012-01-06 1.5796 1.5871 1.5745 1.5859 0 2012-01-07 1.5854 1.5854 1.5782 1.5782 0 2012-01-08 1.5808 1.5866 1.5808 1.5866 0 2012-01-09 1.5867 1.5910 1.5807 1.5815 0 WORIK.Adjusted 2011-12-28 1.58745 2011-12-29 1.57705 2011-12-30 1.57905 2011-12-31 1.58555 2012-01-01 1.58405 2012-01-02 1.58215 2012-01-03 1.57815 2012-01-04 1.58305 2012-01-05 1.57920 2012-01-06 1.58080 2012-01-07 1.58180 2012-01-08 1.58370 2012-01-09 1.58585 HTH, Garrett On Mon, Sep 17, 2012 at 4:12 PM, Worik Stanton <worik.stan...@gmail.com> wrote: > Friends > > I have a file of data: > > "Date","Open","High","Low","Close","Volume","Adjusted" > "2011-12-28",1.5968,1.5987,1.5762,1.5827,0,1.58745 > "2011-12-29",1.5831,1.5846,1.5695,1.5724,0,1.57705 > "2011-12-30",1.5726,1.5877,1.5704,1.5861,0,1.57905 > "2011-12-31",1.585,1.5861,1.585,1.5861,0,1.58555 > "2012-01-01",1.585,1.5861,1.582,1.5861,0,1.58405 > "2012-01-02",1.5871,1.5875,1.5768,1.5802,0,1.58215 > "2012-01-03",1.58,1.5837,1.5726,1.5818,0,1.57815 > "2012-01-04",1.5819,1.5865,1.5796,1.5813,0,1.58305 > "2012-01-05",1.5812,1.5854,1.573,1.5795,0,1.5792 > "2012-01-06",1.5796,1.5871,1.5745,1.5859,0,1.5808 > "2012-01-07",1.5854,1.5854,1.5782,1.5782,0,1.5818 > "2012-01-08",1.5808,1.5866,1.5808,1.5866,0,1.5837 > "2012-01-09",1.5867,1.591,1.5807,1.5815,0,1.58585 > > When I use getSymbols(.., src="csv") > > The dates are incorrect. The first date is "2012-09-18" > > It seems that in getSymbols.csv uses: > > as.Date(fr[, 1], format = format, ..., origin = "1970-01-01") > > Looking more closely... > >> as.Date("2011-12-28", origin="1970-01-01", format="") > [1] "2012-09-18" > > That is what I see. > > But either of... >> as.Date("2011-12-28", origin="1970-01-01") > [1] "2011-12-28" >> as.Date("2011-12-28") > [1] "2011-12-28" >> > > give me what I expect. > > What am I doing wrong? > > cheers > Worik > > -- > it does not matter I think that I shall never see > how much I dig and dig A billboard lovely as a tree > this hole just Indeed, unless the billboards fall > keeps getting deeper I'll never see a tree at all > > _______________________________________________ > R-SIG-Finance@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. _______________________________________________ R-SIG-Finance@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.