• You mean the one used to estimate the historical Vol using open-close and Hi-Lo? see the attached spreadsheet for an example. NumXL 1.5X currently supports EWMA, and comparing the two methods, they are very close, although EWMA show better sensitivity to recent market moves.

    Nevertheless, Yang-Zhang is on the feature list to add to NumXL future releases

    Comment actions Permalink
  • I found a book on for volatility trading - it talks about Yang-Zhang and other methods for estimating historical volatility.

    Volatility Trading

    Comment actions Permalink
  • To be complete, we better support the following methods as well:

    1. Parkinson (1980) estimator
    2. Garman and klass (1980) estimaror
    3. Rogers, Stachell and Yoon (1994) estimator
    4. yang and Zhang (2000) estimator
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post