Hi, I'm trying to analyse system results in XL and as such need to output these results to XL from Metastock 9.0

But in the system window I can only see areas to write code for Buy, Sell, Sell Short, Buy to Cover. Is there a coding space to write generic code which is not triggered by these four events? (eg. write to file the following header info "Days profitable", "Profit %" etc. )

I'm trying to follow the book by Stridsman which seems to have some very valid ideas, however all the examples are in Tradestation Easylanguage. I'm certainly happy with MS though, perhaps someone can recommend a book which uses MS as its principal source of code ideas and examples?

 

Cheers!

Phil

 

Hi Phil,

Welcome to the Forum.

When you run an Enhanced System Test the results are stored in a database "ST_DATA.mdb"  This data source can be easily opened using MS Access or MS Excel and its tables analysed.  If using Excel, remember that its relational database and hence there are dependencies that have to be maintained.  It has been a while since I have trawled through the database, so have forgotten exactly what it contains, needless to say though, all the information you see in the EST comes from the database, somewhere!

BTW: DO NOT CHANGE ANYTHING IN THE TABLES as this can have some unwanted, nasty side-effects.  It is a really good idea to take a backup of the file before establishing any connections to it.



Hope this helps.

wabbit

---

"The question of whether a computer can think is no more interesting than the question of whether a submarine can swim."
Edsgar W. Dijkstra

 

MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC C, 11 PRO w/QC & MDK
For custom MetaStock programming : http://www.wabbit.com.au
My SkyPE status :
My SkyPE account : wabbit.com.au

Hi Wabbit, thanks and yes indeed that's a great help.

Since you asked, my book will be out in August 2009, MS code is throughout.

Volatility-Based Technical Analysis

John Wiley & Sons Publishers

---

K