Discussions
»
Special Interest Groups
»
Advanced Coding Techniques
»
coding a system: write data to external file but outside of Buy/Sell/Short/Cover
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 2/6/2008(UTC)
Posts: 10
|
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
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
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 [:D]
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 2/6/2008(UTC)
Posts: 10
|
Hi Wabbit, thanks and yes indeed that's a great help.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/30/2006(UTC)
Posts: 15
Location: North Carolina
|
Since you asked, my book will be out in August 2009, MS code is throughout.
Volatility-Based Technical Analysis
John Wiley & Sons Publishers
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Special Interest Groups
»
Advanced Coding Techniques
»
coding a system: write data to external file but outside of Buy/Sell/Short/Cover
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
