Forum Discussion
Stock data type and beta calculation
Excel has a linked data type for stocks on the data tab. One of the fields available is called beta. there are many ways to calculate beta. Can you tell me how it is being calculated here? Thank you
sedelstein Completely useless Excel attachment. Double-check to be sure that you attached what you intended. For a general description, complete with a good example, see "How do you calculate beta in Excel?" (click on title).
completely useless add in. I know how to calculate beta from return series.
The attachment shows what the excel linked data type returns. It gives you a beta. Doesn't tell you the benchmark or the time period used in the calculation.