Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5,441
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I import a pdf file or page in an Excel cell? MikaellaP Excel Discussion (Misc queries) 1 October 13th 09 05:02 PM
import data from txt file to an existing excel file shaji Excel Discussion (Misc queries) 1 September 12th 09 04:15 PM
Determine Excel file version with no file extension. tjlumpkin Excel Discussion (Misc queries) 2 July 23rd 09 06:59 AM
How come I can't import an .svc file(Open Office) to Excel file? beezer Excel Discussion (Misc queries) 1 August 28th 06 12:05 AM
Would Like to Automate Batch File Creation and Text FIle Import socrtwo Excel Discussion (Misc queries) 2 August 18th 06 03:54 PM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"