[midulster]

Hi,

I'm using Metatrader on Alpari and am just starting demoing the SIS and RTS. Never having been a fan of hard work (unlike 'the man' whose dedication to do all this without IT is amazing) I knew I'd probably give up collecting the ADX/ADXR values each night so I've been trying to semi-automate the process. I also don't believe that either of the 2 ADX indicators I've used in Metatrader are calculating correctly so I wanted to calculate the results myself.

First step was to get out the OHLC for the 23 forex pairs I'm trying to follow, so I've written an Expert Advisor that can be attached to any chart and on the arrival of the next tick it writes the OHLC and the ATR(14) as calculated by Metatrader for the 23 pairs into the Experts log (I then stop the EA so I don't end up with a HUGE log file with repeats of the same data). The log is just a simple text file that after a 10 second clean up can be opened in Excel. I then copy and paste from this into my main ADX spreadsheet which has a couple of macros to copy paste the data into a worksheet for each pair and sort the resulting ADX/ADXR values into descending order on one worksheet. So I now have ordered ADX/ADXR values in under 3 minutes.

I've attached the EA for anyone who wants it (though note it only works when the market is open ie not at the weekends). Though as Dale has said before I'm not posting the spreadsheet here because it does contain information not freely available in the public domain, especially if the ADX indicators for Metatrader ARE wrong. If you have the book I'd be happy to email you the spreadsheet and especially if you are prepared to dig into its calculations and confirm that they are doing what the book says. This is my concern, that EVEN THOUGH my spreadsheet produces the SAME RESULT AS THE BOOK, it is producing SIGNIFICANTLY different results than any other source of ADX values. And though it would be nice to think that I'm right and the rest of the world is wrong that hasn't been the case in my life so far, so any help in verifying my work to date would be greatly appreciated.