Thread: what is the excel formula for market volatility?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
  
Posts: 837
Default what is the excel formula for market volatility?
If you mean as defined at http://en.wikipedia.org/wiki/Volatility_%28finance%29
you could use the array formula (committed with Ctrl-Shift-Enter)
=STDEV(LOG(data))*SQRT(tradingDaysPerYear)
to get annualized volatility.

Jerry

"Dyn" wrote:

anybody knows the formula??
Reply With QuoteReply With Quote