Today we continue our brief look at the TraderXL Pro package and examine AnalyzerXL. In short AnalyzerXL allows you to apply technical analysis to price data. The technical analysis library is quite extensive with around 165 functions, experts and indicators. The best way to understand how AnalyzerXL operates is by way of example.
You can download a free 10 day trial of TraderXL Pro.
AnalyzerXL
The AnalyzerXL menu is shown below. As with most of the features of the addin the true complexity of this addin is abstracted away.
Before we run AnalyzerXL we use DownloaderXL to download the price data for our desired company. After the data is acquired it is a simple matter of selecting AnalyzerXL and a dialog box like the one shown below will appear.
In this dialog box you select the function, indicator or expert you wish to apply to your data. For this example we select the exponential moving average and click next. In this second dialog box we refine the variables as shown below:
After you are happy with all the settings then it is simply a matter of clicking the finish button and the output will be similar to the sheet shown below.
As you can see above the automatically generated graph needs some refinement however the power of having these pre-programmed functions available in Excel is a huge advantage.
You can download a free 10 day trial of TraderXL Pro.
With the ability to automate these functions with VBA and back and forward test strategies AnalyzerXL is a solid component in the TraderXL Pro package. The full list of functions, indicators and experts is shown below. (more…)
Popularity: 16% [?]
