RSS Feed

TraderXL Pro Package – BacktestingXL

2

BacktestingXL is one of the components in TraderXL Pro that convinced me to buy the program. I am still learning how best to write my own strategies and integrate BulkQuotesXL, AnalyzerXL and BacktestingXL. For the purpose of this review I will use the tether line sample strategy to explore the features of this addin. The image below shows a screenshot of BacktestingXL menu items.

MenuBackTestXL

You can download a free 10 day trial of TraderXL Pro.

For this review I simply opened up the tethered line strategy from the samples directory of BacktestingXL. The screenshot below shows the VBA code for the strategy.

StratergyCode

Once you are happy with your strategy code you then enter your testing settings as shown in the dialog box below.

Settings

After you have entered your settings then it is simply a matter of selecting your data series and generating a detailed report.

CreateDetailReport

After the report is generated the key metrics from the strategy test will be shown in a new worksheet. As you can see below all the key metrics are covered.

SumStrat

To get a detailed visual perspective of how your strategy performed you can click on the Data Series worksheet and a graph will appear as shown below.

DataSeries

After my initial investigation with BacktestingXL I think that this will be a very useful component however I will reserve my final judgement until I have had a chance to develop and test my own strategy with it.

You can download a free 10 day trial of TraderXL Pro.


2 comments »

  1. Backtesting is a very important component of any strategy. Specially if you are a technical trader. However, not because a system has a large proportion of winners it will be profitable. You need to study carefully the drawdowns and how the system perform in different conditions.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trading Wisdom

If I am bullish, I neither buy on reaction, nor wait for strength; I am already in. I turn bullish at the instant my buy stop is hit, and stay bullish until my sell stop is hit. Being bullish and not being long is illogical. — Ed Seykota