DYO: Round to nearest price example

Q:  I need to round the ATR value to the nearest .25 for the mini S&P. Then I need to add it to the high of up candles and subtract it from the low of down candles placing a dot. If you could help I would greatly appreciate it.

A: 

Line A reads the ATR value and Line B adjusts it by the 0.67 factor. Line C makes this into a price at the 0.25 multiple.

Line D tells whether the candle is an Up or Down candle. Line E and F will add the offset to the High of the Up candle, and Line G and H will subtract the offset from the Low of a Down candle.