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, >
