Just trying to be clearer on the problem faced, the dates in the 1st colume become 1,2,3,4 in excel as below, the screenshot of how data appears in excel is attached.
Open High Low Close Volume 1 18937.45 19187.61 18937.45 19002.86 0 2 19003.51 19003.51 18221.82 18542.55 0 3 18574.01 18582.74 18168.27 18168.27 0 4 18194.05 18285.73 18068.10 18193.41 0 5 18246.10 18887.56 18246.10 18850.92 0 . . On Sun, Oct 10, 2010 at 11:55 AM, David Winsemius <dwinsem...@comcast.net>wrote: > > On Oct 9, 2010, at 10:54 PM, missvanilla wrote: > > >> Dear all, >> >> I'm totally new to R. Recently I've been trying to use getYahooData in TTR >> package in order to download stock index daily open/high/low/close. The >> downloaded data is in the format of >> >> Open High Low Close Volume >> 2000-01-04 18937.45 19187.61 18937.45 19002.86 0 >> 2000-01-05 19003.51 19003.51 18221.82 18542.55 0 >> 2000-01-06 18574.01 18582.74 18168.27 18168.27 0 >> 2000-01-07 18194.05 18285.73 18068.10 18193.41 0 >> 2000-01-11 18246.10 18887.56 18246.10 18850.92 0 >> 2000-01-12 18780.17 18811.87 18626.92 18677.42 0 >> 2000-01-13 18667.18 18845.03 18667.18 18833.29 0 >> 2000-01-14 18882.99 19058.02 18733.83 18956.55 0 >> 2000-01-17 19025.62 19442.58 19025.62 19437.23 0 >> 2000-01-18 19412.47 19412.47 19145.17 19196.57 0 >> >> However, when I attempted to write the data to excel using write.table, >> dates in the first colume become 1,2,3,4 in the excel file. Same problem >> happened if write.csv was used. >> >> If you run these two lines of code you'll get what I meant.. before >> running >> the code, package TTR needs to be loaded. >> >> N225 <- getYahooData("^N225", 20000101, ) >>> write.table(N225,"Nikkei.xls",sep='\t', row.name = TRUE , col.name = NA) >>> >> > There is a well-described problem with write.table files going into Excel. > There is no leading item or tab on the first row. You need to insert an > extra cell and move the header over one position. Then you won't be > misinterpreting your row.names as dates. > > -- > David > > >> Appreciate your kind assistance! Thanks a lot in advance. >> >> -- >> View this message in context: >> http://r.789695.n4.nabble.com/Help-needed-for-getYahooData-in-TTR-package-writing-the-Yahoo-data-to-excel-tp2970017p2970017.html >> Sent from the R help mailing list archive at Nabble.com. >> >> ______________________________________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> >> and provide commented, minimal, self-contained, reproducible code. >> > >
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.