Stuart, thank you very much for your reply.
The first proposal might work and I will try it. However, it is not really the favored solution. I have the MetaStock SDK and could read the MetaStock data into an Excel spreadsheet or write it into text files. But this will the usage of disc space as the data will be stored in two different file formats. I would like to avoid this by finding a solution to read the MetaStock data directly into my other quantitative analysis program. The second proposal is really interesting. With my other program, I could write data back into various file formats, among them Excel and also text files. Reading the data into MetaStock for charting and system testing by the msx.DLL would be a great help. Best regards Peter ________________________________ Von: stuart_yg123 <[email protected]> An: [email protected] Gesendet: 11:01 Montag, 25.Februar 2013 Betreff: [EquisMetaStock Group] Re: MetaStock data and ODBC Peter 1. Could you somehow integate the Enhanced System Tester in your testing? For example create a buy and hold "system" for the start and end dates that you want to test. You could then access the resulting ST_Data.mdb file using Microsoft Access. 2. Alternatively could your other software export quantitative data to a csv file? The msx DLL may be able to read the data www.kosinsky.info/msx/msxen.htm. The last time I checked the instuctions on the Russian page are slightly different to the English page. I used Google Translate to read www.kosinsky.info/msx/msx.htm. There is a multi-column reader for sale at www.metastockcsv.com/ Regards Stuart --- In [email protected], "PFertig" wrote: > > Hello, > > I would like to do some quantitative analysis with another software, which > does not read data in the MetaStock file format. One possibility would be to > convert the data to a csv or Excel file with the Downloader conversion > command. However, for many series this is a rather tedious task. My other > quantitative analysis software reads data from an ODBC database by SQL > commands. Does anybody know whether there is a tool to read MetaStock data > with an ODBC driver and SQL commands? > > Best regards > > Peter >
