Re: [R] Help needed for getYahooData in TTR package & writing the Yahoo data to excel

2010-10-10 Thread Gabor Grothendieck
On Sun, Oct 10, 2010 at 8:09 AM, David Winsemius wrote: > > On Oct 10, 2010, at 5:27 AM, vanilla fantasy wrote: > >> 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. > > I ca

Re: [R] Help needed for getYahooData in TTR package & writing the Yahoo data to excel

2010-10-10 Thread David Winsemius
On Oct 10, 2010, at 5:27 AM, vanilla fantasy wrote: 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. I can affirm that there was at one time a jpg since you copied me an

Re: [R] Help needed for getYahooData in TTR package & writing the Yahoo data to excel

2010-10-10 Thread vanilla fantasy
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 1

Re: [R] Help needed for getYahooData in TTR package & writing the Yahoo data to excel

2010-10-10 Thread vanilla fantasy
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 wrote: > > On Oct 9, 2010, at 10:54 PM, missvanilla wr

Re: [R] Help needed for getYahooData in TTR package & writing the Yahoo data to excel

2010-10-09 Thread David Winsemius
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

[R] Help needed for getYahooData in TTR package & writing the Yahoo data to excel

2010-10-09 Thread missvanilla
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 18