logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Bismarck1871  
#1 Posted : Thursday, October 13, 2005 4:33:43 AM(UTC)
Bismarck1871

Rank: Newbie

Groups: Registered, Registered Users
Joined: 10/13/2005(UTC)
Posts: 1

Hi All, I was wondering if someone knows a quick way to export the results from system tester into an excel file. So what i want is to be able to export the results that I get after, lets say an optimization, into an excel file. I definitely do not want to do this by copy-paste. There is also the tedious way of saving things as html, but that's not efficient either. Essentially I would want to take the order and equity tabs for each result and put it in an excel sheet. My assumption is that there has to be an easy way to accomplish this. I hope there is someone knowledgable out there who can help. Thanks in advance!
StorkBite  
#2 Posted : Thursday, October 13, 2005 6:55:48 AM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
Hey 1871- Welcome to the forums! I think this question has been asked many times recently and the concesus is that there is no 'easier' way to do it at the present time. I'll forward this to the wish list and we can all hope that someone will see it prior to releasing version 10!
mstt  
#3 Posted : Thursday, October 13, 2005 8:43:18 AM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Bismark It may not be appropriate for the systems you're testing but there is another possible approach you could take. If the Trade Equity tools can run your optimised formulas then moving the results to Excel is as simple as copy and paste up to 4 exploration results. Trade Equity is an indicator-based equity curve tool that explorations exploit to generate various trade statistics about all securities in the portfolio under test. The indicators available are for long or short systems only, not both, and the user options available are somewhat less sophisticated than those for the Enhanced System Tester. I find that Trade Equity results, summarised in Excel, give me a better idea of how a system is performing than the EST on its own. There is an MFL-only version of Trade Equity, but the dll assisted versions run somewhat faster and are preferable for that reason. However you can still disect the tools, and even build your own explorations for more esoteric trade stats if you want. TradeSim it's not, but for a freebie you'd hardly expect it to be. You can find formulas and supporting dlls at either of the following two links. In the event that the links get removed you can write to me at rlarsen@man.quik.co.nz for further directions. www.metastocktools.com www.metastocktips.co.nz Roy
Jose  
#4 Posted : Thursday, October 13, 2005 11:10:23 AM(UTC)
Jose

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth

Was thanked: 2 time(s) in 2 post(s)
mstt wrote:
TradeSim it's not, but for a freebie you'd hardly expect it to be.
The equity indicators/explorations may be free, but that doesn't take anything away from this most valuable indicator. Plotting Roy's Equity Trade indicator below a chart, provides an instantaneous view (profit, drawdown, etc) of the system signals' performance for that chart. Nothing else (TradeSim, System Tester) can do that in MetaStock. jose '-
Users browsing this topic
Guest (Hidden)
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.