Peter, You might also look at your QA software to see if it supports OLE. That is the protocol that MS uses to embed your data in in Excel spreadsheet. If your QA software can implemet OLE, you MIGHT be able link the data directly. You might be able to copy and paste from MS to QA using OLE, but it will be a manual process.
OLE can be tedious, but the links can remain in place so that you don't need to do re-copy and paste. Check out the OLE in the MS help. I'm guessing, but MS looks to be using OLE to create spreadsheets and to copy charts to Windows. A hybrid approach may be to export the MS data to an Excel spreadsheet, then use ODBC links from an SQL database to link to atable of data in Excel. Then point your QA software at the SQL db to access thattable. Access is also an SQL database with ODBC connectivity, so it should work the same way. Since tedium is the real opponent, I'd recommend yet another approach. 1) get AutoIT and write scripts to 2) accept input as to date, time, range, symbols 3) set scripts to start/open and read MS data, 4) send data to Excel 5) set scripts to start/open and execute your QA software, 6) store results in folders. You set these up as batch scripts using your OS shell scripting language and AutoIT scripts. I use the AutoIT tool to control reading EOD data and feeding it into MS and it works pretty well. The downside is that you need some skill at programming and a bit of learning curve making all the parts work. Good luck with the project and share your solution(s) with us when you figure all the parts out. epenak ________________________________ From: stuart_yg123 <[email protected]> To: [email protected] Sent: Monday, February 25, 2013 4:01 AM Subject: [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" <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 > ------------------------------------ Yahoo! Groups Links http://docs.yahoo.com/info/terms/
