I am preparing an excel sheet based on the indicator and while working on Super Trend, the formula for it seems to be incorrect. I request you to help me out in resolving this issue.
Following are the steps I am doing while calculating Super Trend Formula
----------------------------------------------------------------------
1. First I am calcualting True Range
2. 1st value of true range is daily high - daily close
3. Other values of true range are largest of
abs(current high - current low),abs(current high - previous close),
abs(current low - previous close)
4.Next I have calculated Average True Range
5.1st value of average true range is a 14-day average of true range
6. Other values of average true range are given by
ATR (t)=ATR(t-1) X (n-1) + TR/n
7. Period n is 14
8. Next I am calcuating ATR Multipleirt by multiplying Average True Range times Multiplier
9. The default value of Multipleir i am using is 1.5
10. Next I am calculating Medium Price i.e High + Low /2
11. Next I am calculating Uptrend = Medium Price + ATR Multipleir
12. DownTrend - Medium Price - ATR Multipleir
But i am not getting correct results despite following above steps please help me in resolving the issue urgently....
Also, I am kinda new in traderji (from posting thread perspective) so i am into wrong thread then pls suggest where i can raise it.
Many THnaks for your help in advance....
Following are the steps I am doing while calculating Super Trend Formula
----------------------------------------------------------------------
1. First I am calcualting True Range
2. 1st value of true range is daily high - daily close
3. Other values of true range are largest of
abs(current high - current low),abs(current high - previous close),
abs(current low - previous close)
4.Next I have calculated Average True Range
5.1st value of average true range is a 14-day average of true range
6. Other values of average true range are given by
ATR (t)=ATR(t-1) X (n-1) + TR/n
7. Period n is 14
8. Next I am calcuating ATR Multipleirt by multiplying Average True Range times Multiplier
9. The default value of Multipleir i am using is 1.5
10. Next I am calculating Medium Price i.e High + Low /2
11. Next I am calculating Uptrend = Medium Price + ATR Multipleir
12. DownTrend - Medium Price - ATR Multipleir
But i am not getting correct results despite following above steps please help me in resolving the issue urgently....
Also, I am kinda new in traderji (from posting thread perspective) so i am into wrong thread then pls suggest where i can raise it.
Many THnaks for your help in advance....