2. Try the Excel Text Import Wizard. Choose Delimited File Type. Comma Delimiter.
6. The file is also archived in the Files section of this group under Command Line Utilities. Hope it works for you. Stuart --- In [email protected], tangianto sayuti <tangianto@...> wrote: > > 1. done > 2. that csv file open by excel not split into columns, just 1 coloumn > 3. - > 4. - > 5. - > 6. doesn't have that page archived. It doesn't seem to be available on the > live web, either. > > someone have more simple way ? and solve this ? or converter tools could i > use and download ? > > Thanks Stuart > > > > > ________________________________ > From: stuart_yg123 <[email protected]> > To: [email protected] > Sent: Monday, August 20, 2012 4:32 PM > Subject: [EquisMetaStock Group] Yahoo CSV data > > > Â > > > I normally convert as follows: > > 1. Download the Yahoo csv data. > 2. Open the csv file in Excel to split into columns. > 3. Sort date descending. > 4. Copy all the data and paste into Yahoo CSV Data.xlsx spreadsheet. I have > uploaded the Excel file to this group's Files section. > 5. Copy the data that is combined into one cell and paste into a text file. > 6. I use MsCmdLineUtils to convert the text file into MetaStock. See > http://www.oocities.org/mimansoor/MsCmdLineUtils.html. For support see > http://groups.google.com/group/metastockcmdlineutils/ > > Fortunately I don't need to do this often.. > > Regards > > Stuart > > --- In [email protected], "tangianto" <tangianto@> wrote: > > > > Hi All, > > > > i;m download data from yahoo finance history for sectoral index (mining, > > finance,etc) > > > > the problem is that file on csv, > > > > that;s can;t convert by downloader,.. > > > > have solution ? > > > > converter tools from csv to ascii ? > > > > or others ways ?? > > > > Indonesia stock market data. > > > > Thanks, > > >
