News Focus
News Focus
Followers 2
Posts 82
Boards Moderated 0
Alias Born 09/03/2021

Re: None

Thursday, 06/09/2022 6:40:27 AM

Thursday, June 09, 2022 6:40:27 AM

Post# of 8735
Hi Myst,

I hope you're well. I will try to share my experiences trading XDEV in the coming weeks. In the interim, did you arrive at 8 days look back period for the Williams %R for a reason?

Additionally, I noticed, when calculating Williams %, you are using the 8 day SMA of the HIGH and LOW and not the MAX and MIN of the HIGH the LOW.

You use AVERAGE(BD2:BD9)

Others use MAX(BD2:BD9) and MIN(BE2:BE9)

Did you find using the 8 day SMA rather than the MAX or MIN better? Did you choose to use the 8 SMA of the HIGH and the LOW instead of the MAX and MIN for a reason?

I think your way of calculating Williams %R contains more information by distinguishing between overbought and oversold and REALLY overbought and oversold periods.

Calculation using AVERAGE:



Calculation using "MIN" and "MAX":



All the best,

Alex

Discover What Traders Are Watching

Explore small cap ideas before they hit the headlines.

Join Today