Convert comma separated data into cells in Excel xls spreadsheet. See
example below.

This is an operation I have done in the past but cannot do now. Using
Excel 2004 for Mac. To duplicate my problem do the following:

Goto to Yahoo finance. Type in AAPL (Apple stock symbol)
Select Historical Data
Select data period...use short period like Jan 1 2006 to May 3 2006
Scroll to the bottom and select  info that lets you see data as comma
separated spreadsheet.

Now...somehow get this in to an Excel .xls workbook.

---

Request for Question Clarification by pafalafa-ga on 04 May 2006 14:32 PDT

Are you able to save the comma-delimited data as a file on your local system?

If so, it should be a relatively easy matter to open it up as an Excel spreadsheet.

pafalafa-ga

---

Request for Question Clarification by pafalafa-ga on 05 May 2006 07:34 PDT

Pete,

I downloaded the AAPL data with no problem...it opens right up in Excel.


The part of your question I'm having a hard time understanding is this:

>>Scroll to the bottom and select info that lets you see data as comma
separated spreadsheet...<<


When I access historical stock data at Yahoo Finance, at the bottom of
the table is a simple hypertext link that says  "Download To
Spreadsheet".

Once I click on that, everything works just at it should.  Are you
seeing the same link?


paf



P.S.  Here's what the AAPL data looks like off of the Excel
spreadsheet (though it may not format properly here):


Date	         Open	High	Low	Close	Volume	   Adj. Close*
4-May-06	71.22	72.89	70.46	71.13	30729300	71.13
3-May-06	71.83	71.95	70.18	71.14	24535400	71.14
2-May-06	70.15	71.98	70.11	71.62	27559400	71.62
1-May-06	70.77	71.54	69.16	69.6	26799300	69.6
28-Apr-06	69.38	71.3	69.2	70.39	27144200	70.39
27-Apr-06	67.73	69.86	67.35	69.36	30212400	69.36
26-Apr-06	66.65	68.28	66.4	68.15	25388800	68.15
25-Apr-06	65.96	66.59	65.56	66.17	18895100	66.17
24-Apr-06	66.85	66.92	65.5	65.75	25251000	65.75
21-Apr-06	68.19	68.64	66.47	67.04	28178100	67.04
20-Apr-06	69.51	70	66.2	67.63	59535100	67.63
19-Apr-06	66.82	67	65.47	65.65	38786900	65.65
18-Apr-06	65.04	66.47	64.79	66.22	28387300	66.22
17-Apr-06	66.51	66.84	64.35	64.81	25783500	64.81
.
.
.
and so on...

Save the file with a csv extension and excel will be able to open it.

Otherwise, in Excel go to Data from the menu and go from "text to columns"

Change the Commas to Tabs ( #09 or &h09 )

The CSV protocol is fiendishly complicated

Which language version do you work with? In the german version, for
example, the meaning of comma and decimal point are reversed. You can
change this in the international part of the options.

Simply take the comma delimited file open it and paste it into an
excel sheet. Then highlight the column you just pasted and go to Data
Text To Columns, choose delimited, click next, choose delimited
"other" and type ',' into it. You should see below showing you the
separation. Click next and finish and the comma delimitation should be
in a few columns. If this does not work let me know. Hope it helps.