Thanks David.

You mentioned that I need to insert an extra cell and move the header over
one position. I tried for a few times but still coudnt figure out how. Can
you pls advise? Many thanks.
On Sun, Oct 10, 2010 at 11:55 AM, David Winsemius <dwinsemius@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.
>>
>
>

	[[alternative HTML version deleted]]

