The simple, common approach to estimating volatility is historical standard deviation. Here is a thread about the decision to include/exclude the mean return: https://trtl.bz/2kLRK7z
David's XLS is here: https://trtl.bz/2kOmHb6
David's XLS is here: https://trtl.bz/2kOmHb6