HI AIMagic!
I'm sorry for these long delays in responses! It's these summer months that keep me occupied with so many different things that I forget to check back in here.
But once again your eye is sharper than an eagles! Yes, I've modified the Williams%R to suit my purposes. My formula gives me a higher range than zero to -100 in the standard W%R formula. Since I like to use the histogram for visualization it's just easier for me to see the extremes in movement. The exact numbers for W%R in the standard method don't matter as much as the high and low bars on my histogram chart. I'm still getting the gist of price extremes and overbought/oversold conditions as measured by W%R, but in a way I can visualize easier. The 8 day sma just works best for this method. I'm sure I've experimented with other sma's in the past but it's been so long I can't give you a precise breakdown of those results.
Thanks again for the penetrating study of the spreadsheet and please keep the questions coming. Keeps me sharp. :-)
Market Data 
Markets 
