Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
first column: daily closes
second column: calculate the daily returns (percent change from prior day)
third column: logarithm of daily returns
fourth column: sample standard deviation of logarithm of daily returns over the last 252 days
fifth column: multiply sample standard deviation with the square root of 252 to obtain the annualized volatility
B) Average true range
Basically you take the true range and calculated an exponential or a simple moving averages of the true range.
first column: calculate Max(high, prior close)
second column: calculate Min( low, prior close)
third column: subtract second column from first column (this is the true range)
fourth column: calculate a N-period simple moving average from the third column
If you wish to use an EMA instead of the SMA for calculating the average, this is possible. The original ATR was based on an EMA, because Welles Wilder had to calculate it manually. The EMA is based on a simple recursive formula, so it is less work to calculate it manually than a SMA. Wilder was just lazy. With PCs you can use both EMA or SMA.
