Beta calculation

#2
Simplest way to calculate the BETA of a stock

get the weekly/monthly/annual data of the particular stock and the corresponding index. Then use the function in excel =slope(company,index)
and bingo you get the beta
 
#3
Hello,
I am new to trading arena, but have done my homework by reading d theory.
Could anyone explain me what is Beta and what it signifies (keeping away the mathematical details!)

Thanks
 

oxusmorouz

Well-Known Member
#4
Could anyone explain me what is Beta and what it signifies (keeping away the mathematical details!
Hello rocky,
Let's have it this way. Suppose if a stock moves up by 30% when the market (/benchmark) moves up by 10%, would it be right if we say that the stock has outperformed the market because of it's implicit strength compared with the market, or is this out performance simply an outcome of higher volatility?

Putting it in other words, suppose you have a portfolio which has outperformed the market by the same ratio. Can this out performance be attributed to your stock selection and fund allocation skills, or simply a question of having more volatile stocks than the index?

If it is simply (and purely) a case of choosing stocks with higher volatility, then if the market moves down by 10%, it is highly probable that the portfolio will move down by ~ 30% too.

Note that beta measures only the systematic risk of the stock. There might be company/stock specific factors (unsystematic risk) which affects returns too.
 
Last edited:

Vlad

New Member
#5
It is very advisable to analyze your portfolio in terms of beta values, that is how much the stocks in your portfolio are correlated to each other. On average, about 70% av a share's price is correlated to the market it belongs to.

Theoretically you should rebalance your portfolio so that the stocks who are most correlated to the rest of the portfolio should be exchanged to minimize risk.
More info about betas (with no math): Portfolio analysis and beta values

/V
 
#6
Hi,
kbharadwaj
Thanks for the simple method.
but actually i need to calculate for all shares traded in NSE
This will become tedious.
I have market price from 2000 of all shares in database (also index)

I needed some simple formula to calculate beta
Alternatively if it is available in NSE Site or some site for all scripts it would be nice
 

Linus

Active Member
#7
Hi,
kbharadwaj
Thanks for the simple method.
but actually i need to calculate for all shares traded in NSE
This will become tedious.
I have market price from 2000 of all shares in database (also index)

I needed some simple formula to calculate beta
Alternatively if it is available in NSE Site or some site for all scripts it would be nice

Click on these links for Beta values of NSE Nifty and Sensex stocks -

NSE

BSE

ss
 

trader111

Active Member
#8
Note that beta measures only the systematic risk of the stock. There might be company/stock specific factors (unsystematic risk) which affects returns too.
very well put.
this applies to trading with all time frames, i.e. from short term to people who hold a position for 1 yr.
See GOOGLE as an example which astonishingly outperformed its benchmark index in the past but killed mercilessly many in the last 3 mnths.
 
Last edited:

Similar threads