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.
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.
Once you are happy with your strategy code you then enter your testing settings as shown in the dialog box below.
After you have entered your settings then it is simply a matter of selecting your data series and generating a detailed report.
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.
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.
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.
Popularity: 28% [?]
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.
I usually don