ATR is one of the best volatility based stop methods. You can easily probably find excel code to optimize/backtest it. You mention the word volatility and you bring in the options people.