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. Read the full story
Popularity: 6% [?]



When it comes to writing computer programs or in this case automated trading systems translating English into programming code can be fraught with danger. Pseudo Code on the other hand refers to a more structured English for describing a process or program. It is important that you learn to write quality pseudo code as it will make a big difference when you come to coding your system your self or hiring a programmer.
It has been a little over a week now since I first installed Visual Studio 2008 Professional Edition. My first impressions are that this is a very solid program. Visual Studio 2008 was released in late November 2007 and by now most investment banks have migrated their development environments from Visual Studio 2005 to 2008.
In our previous article we used a simple method for importing stock quote data into Excel. Today we will look at a robust automated method for querying more data sources then just Yahoo finance. The Stock Market Functions Add-in for Excel is a free tool developed by by Randy Harmelink. The stock market functions Add-In allows you to import data from sites like Yahoo, Business Week, Reuters, Google, Bloomberg, MSN and many more. In the latest release there are beta features for several technical analysis functions like





