View Single Post
  #3   Report Post  
Zeelotes
 
Posts: n/a
Default Array Formulas for Geometric Standard Deviation and Sharpe

Jerry: Thanks. The formula works perfectly. The purpose of this formula
is to determine the volatilty on a series of monthly stock / index returns.
Many in the investing community have found this approach to be optimal for
determining the historical volatility of a particular trading strategy.

Ron: Yes, you are right. The method I'm employing is exactly based on the
presentation by Sharpe himself. I am annualizing the results using the
SQRT(12) at the end of the formula.