Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I import a pdf file or page in an Excel cell? | Excel Discussion (Misc queries) | |||
import data from txt file to an existing excel file | Excel Discussion (Misc queries) | |||
Determine Excel file version with no file extension. | Excel Discussion (Misc queries) | |||
How come I can't import an .svc file(Open Office) to Excel file? | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) |