Edit Your Comment
Indicator to show daily volatility
Member Since Apr 05, 2016
12 posts
Mar 14, 2017 at 15:20
Member Since Feb 12, 2016
427 posts
Hi, personally I am not using indicator showing volatility, but I found some here - https://www.incrediblecharts.com/indicators/volatility_indicators.php ; Hope this will help 😄
Accept the loss as experience
Mar 14, 2017 at 19:08
Member Since Aug 11, 2014
20 posts
forex_trader_387595
Member Since Dec 27, 2016
14 posts
Mar 23, 2017 at 07:30
Member Since Dec 27, 2016
14 posts
Waoo here I found some steps of how to calculate the volatility in excel.
1. You need the closing data of the underlying from which you want to calculate the volatility. I have used Yahoo finance (free) to get them and pass them to Excel.
2. You have to calculate the natural logarithm of the daily yields obtained with the closing data and the square of those logarithms.
3. You have to get the average of the logarithms to be able to later calculate the mean deviation to the square of each value.
4. Finally calculate the average of the mean deviations squared and make its root and you are already a single step to get the volatility of the underlying.
I hope this information can serve you.
1. You need the closing data of the underlying from which you want to calculate the volatility. I have used Yahoo finance (free) to get them and pass them to Excel.
2. You have to calculate the natural logarithm of the daily yields obtained with the closing data and the square of those logarithms.
3. You have to get the average of the logarithms to be able to later calculate the mean deviation to the square of each value.
4. Finally calculate the average of the mean deviations squared and make its root and you are already a single step to get the volatility of the underlying.
I hope this information can serve you.
Mar 24, 2017 at 09:53
Member Since Mar 12, 2017
7 posts
bh61 posted:
Waoo here I found some steps of how to calculate the volatility in excel.
1. You need the closing data of the underlying from which you want to calculate the volatility. I have used Yahoo finance (free) to get them and pass them to Excel.
2. You have to calculate the natural logarithm of the daily yields obtained with the closing data and the square of those logarithms.
3. You have to get the average of the logarithms to be able to later calculate the mean deviation to the square of each value.
4. Finally calculate the average of the mean deviations squared and make its root and you are already a single step to get the volatility of the underlying.
I hope this information can serve you.
Is there a source for this or it's your own method?
forex_trader_367569
Member Since Oct 09, 2016
15 posts
Mar 26, 2017 at 07:02
Member Since Oct 09, 2016
15 posts
fxmills posted:
Well, these are three indicators that I can recommend:
Bollinger Bands
ATR Average True Range
Envelopes
Of course, these three main indicators that I mention are tools of technical analysis that are to be used together, since they will give us greater security when opening or closing a position, minimizing risks of confusing tendencies and being able to discard false alarms by comparison Between one or the other measuring instrument.
forex_trader_370040
Member Since Oct 19, 2016
8 posts
forex_trader_29148
Member Since Feb 11, 2011
1916 posts
Apr 04, 2017 at 14:45
Member Since Feb 11, 2011
1916 posts
bh61 posted:
Waoo here I found some steps of how to calculate the volatility in excel.
1. You need the closing data of the underlying from which you want to calculate the volatility. I have used Yahoo finance (free) to get them and pass them to Excel.
2. You have to calculate the natural logarithm of the daily yields obtained with the closing data and the square of those logarithms.
3. You have to get the average of the logarithms to be able to later calculate the mean deviation to the square of each value.
4. Finally calculate the average of the mean deviations squared and make its root and you are already a single step to get the volatility of the underlying.
I hope this information can serve you.
keep it stupid simple bro (KISS)
Member Since Apr 18, 2017
38 posts
May 03, 2017 at 06:16
Member Since Apr 18, 2017
38 posts
You may get thousands of trading indicators in this case, but they are too late! Whatever, I have seen Price Action trading strategy is very useful trading strategy, I get market trend status, flow rate with Forex market momentum all of info by using Price Action trading strategy here! Yes, I rely on my own trading knowledge not on any technical tool!
Member Since Apr 11, 2017
6 posts
*Commercial use and spam will not be tolerated, and may result in account termination.
Tip: Posting an image/youtube url will automatically embed it in your post!
Tip: Type the @ sign to auto complete a username participating in this discussion.