Stock Beta Calculation Excel (HINDI)

Описание: Stock Beta Calculation Excel is very important for investors and traders. For Intraday Trading and Swing Trading, it is better to choose high beta stocks as they tend to deliver higher returns compared to low beta stocks. Stock Beta Calculation Excel can be prepared based on the excel functions like Slope and Covariance. In this video, i have shared my Stock Beta Calculation Excel. In this, i have used slope excel function.

Normally, the beta of top 50 high beta stocks is available on NSE website but investors and traders find it difficult to calculate the beta value of other stocks. The value available on different websites are different and may not be accurate. In my opinion, minimum 90 data points are required to calculate the stock beta value. In Stock Beta Calculation Excel, i considered more than 90 data points.

The steps are as follows
1. You should download the closing stock price for the last 90 trading days.
2. Import closing value of index like NIFTY 50.
3. Enter these 2 values in excel sheet and you can easily the stock beta value.

You can also check my earlier videos on Stock Beta for interpretation and conclusion.

If you liked this video, You can "Subscribe" to my YouTube Channel. The link is as follows
https://goo.gl/nsh0Oh

By subscribing, You can daily watch a new Educational and Informative video in your own Hindi language.

For more such interesting and informative content, join me at:
Website: http://www.nitinbhatia.in/
T:   / nitinbhatia121  
G+: https://plus.google.com/+NitinBhatia

#NitinBhatia #StockBeta #Beta