| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 11/22/2008
Posts: 23
|
Hi,
According to my understanding, Williams %R is calculated as follows. however, when I calculate it on excel with the following formula, the results are different than the indicator value on SF chart. Does SF do something else in addition to the following formula?
Thanks.
HC = Highest High [in %R Periods] - Close [today]
HL = Highest High [in %R Periods] - Lowest Low [in %R Periods]
%R = HC / HL * -100
|
|
Gold Customer
Joined: 11/22/2008
Posts: 23
|
Furthermore, William %R does not always equal reverse of stocchastic with %K and%D 1.
|
|
Gold Customer
Joined: 11/22/2008
Posts: 23
|
Sorry...I meant to say "Furthermore, William %R does not always equal reverse of stocchastic with %K and%D 1 on SF".
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
It's not the reverse of the Stochastic, it's the Stochastic - 100. If you can provide an example where this isn't the case please post it and we'll follow up and figure out what's going on.
|
|
Gold Customer
Joined: 11/22/2008
Posts: 23
|
Thanks. Where do I email the file? Whom should I address to?
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
You can send it to support@worden.com, Attn: StockGuy.
But if you plot a Stochastic (%K set to 1) and Williams%R for the same period, you can see that the value of Williams%R is always the Stochastic value - 100.
|
|
Gold Customer
Joined: 11/22/2008
Posts: 23
|
Thanks. I just sent it to you.
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
From what I can tell you're not using any closing values in your calculation, but I could be wrong.
Column J is =((Hn-Bn)/(Hn-Ln)*-100)
And column B in your spread sheet is "ROC (%Adj) 21. Why are you using that instead of the closing value for the period?
Have you taken a look at the stochastic and Williams %R values on the chart? Williams is always the Stochastic - 100.
|
|
|
Guest-1 |