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

B

broncoburt

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top