Beta must be relative to something, like sp 500 index. Or your portfolio. With that, you can calculate any beta if you have two columns of data. 1) stock price 2) benchmark. Assuming you had 99 rows, it would look like this in excel.
Beta =COVAR(A1:A99,B2:B99)/VAR(B1:B99)
Happy computing.
I can see the current Beta for a stock but were can I get longer term Betas: 3yr, 5yr and 10 yr?
