Hi Peter,

Firstly have a look at the attached quote to quantify which definition of "range" you will use.

"From Wikipedia, the free encyclopedia
Jump to: navigation, search
Average True Range (ATR) is a technical analysis indicator developed by J. Welles Wilder, based on trading ranges smoothed by an N-day exponential moving average.

The range of a day's trading is simply high − low. The true range extends it to yesterday's closing price if it was outside of today's range:

true range = max(high,closeprev) − min(low,closeprev)
The average true range is then an N-day exponential moving average of the true range values. Wilder recommended a 14-period smoothing. Note this is by his reckoning of EMA periods (see the EMA article on that), meaning an α=1/14.

The idea of ranges is that they show the commitment or enthusiasm of traders. Large or increasing ranges suggest traders prepared to continue to bid up or sell down a stock through the course of the day. Decreasing range suggests waning interest."

Using range as High - Low:-

1) {Column A} Mov(HIGH-LOW,15,S) {S=simple moving average}
2) {Column B} ((HIGH-LOW)/Mov(HIGH-LOW,15,S))*100
3) {Column C} CLOSE/(HIGH-LOW)

Using Wilder's ATR (a standard indicator as supplied by MetaStock):-

1) {Column A} ATR(15)
2) {Column B} (ATR(1)/ATR(15))*100
3) {Column C} CLOSE/ATR(1)

As for the answer to question 4.......I'll leave you to work on that but suggest you look/download the MetaStock Formula Primer under the files section above or research Online Help above.

Hope this helps.

Cheers,

oz