Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135
|
Trying to implement wilder smoothing on excel but the value differs from ms value. How does ms compute wilder smoothing? Anyone has a excel for wilder smoothing?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
for X period Wilder's Smoothing:
first value:
sum the first X data points and divided by X.
This is the same as the first value of a simple moving average.
All subsequent values of Wilder's Smoothing:
MA + (data - MA)/x
where:
MA = value of the Wilder's Smoothing on the previous bar
data = the current value of the data set being averaged.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
