For black box testing, I was hoping that I could replicate the ADX + DI+ and DI- indicators that are provided in trading platforms such as ThinkOrSwim, ScottradeElite etc.

However, I noticed that even after applying the formula I found on WikiPedia, I noticed that initially calculated data tends to be off by a large margin when compared to ThinkOrSwim or ScottradeElite.

Example spreadsheet is based on HIMX @ Google Drive. In the spreadsheet, you will see the ADX + DI oscillators that I calculated. Here is the screenshot of my calculated ADX + DI HIMX in self calculated spreadsheet

Below is the screenshot based on ScottradeElite and ThinkOrSwim for HIMX HIMX in ScottradeElite HIMX in ThinkOrSwim

The period for the ADX & DI are 14 periods.

I have been spending countless hours, trying to figure out why my calculated results would deviate from the existing trading platforms. However, I have not been able to spot mistake. Can anyone help me out by pointing out what I am missing? Thanks a bunch!


closed as off-topic by bcf, olaker Aug 3 '15 at 19:12

  • This question does not appear to be about quantitative finance within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    $\begingroup$ I'm voting to close this question as off-topic because OP is attempting to implement technical analysis indicators, which is not pertinent to quant finance. $\endgroup$ – bcf Aug 3 '15 at 17:27

I think wiki calculated upon new way and your excel calculated upon Wilder way (Wilder book).

I have same issue when use both method. Look like new Metastock 5 software offer both method.

  • $\begingroup$ Which part is the new way? Because I did state that I applied what I found from the Wiki? $\endgroup$ – Antony May 21 '15 at 1:44

Not the answer you're looking for? Browse other questions tagged or ask your own question.