import file so that it is a actual csv file, no excel cell version
 

How can I import a spreadsheet file from finance.yahoo.com for the history
prices of a stock and import it into my charting software. My charting
software reads ASCII "DOHLCV" or D,O,H,L,C,V or "Date", "O", "H", "L", "C",
"V" . I have tried for a week trying to manipulate the data to be read by my
charting software but it will not take it. When downloading data it
automatically opens excel 97 spreadsheet and inserts the data. I save it as a
CSV file but my charting program will not read it and when I open the file it
is not in text form but cell form. I cannot even change it or save it into
text; comma seperated values. I can make a test file in Notepad or Wordpad in
text form with CSV and the charting program will read it. Example Excel
Download saved as CSV file: 11/19/2009 19.97 20.23 19.46 19.67 76800 19.67
but each value is in its own cell. The test file my charting software will
read:
20060515,26.250,26.790,25.320,25.340,19100
Please help.
Thanks

import file so that it is a actual csv file, no excel cell version
 

Burt,

Try changing the file extension from .csv to .txt before using Excel's file
open command. That should take you through a dialog.

HTH,
Bernie
MS Excel MVP


"broncoburt" wrote in message
...
How can I import a spreadsheet file from finance.yahoo.com for the history
prices of a stock and import it into my charting software. My charting
software reads ASCII "DOHLCV" or D,O,H,L,C,V or "Date", "O", "H", "L",
"C",
"V" . I have tried for a week trying to manipulate the data to be read by
my
charting software but it will not take it. When downloading data it
automatically opens excel 97 spreadsheet and inserts the data. I save it
as a
CSV file but my charting program will not read it and when I open the file
it
is not in text form but cell form. I cannot even change it or save it into
text; comma seperated values. I can make a test file in Notepad or Wordpad
in
text form with CSV and the charting program will read it. Example Excel
Download saved as CSV file: 11/19/2009 19.97 20.23 19.46 19.67 76800 19.67
but each value is in its own cell. The test file my charting software will
read:
20060515,26.250,26.790,25.320,25.340,19100
Please help.
Thanks