Forum Discussion
sedelstein
Jan 23, 2021Copper Contributor
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
Jan 23, 2021Copper Contributor
It is often done by calculating the slope of a linear regression of stock returns against a reference index like the S&P 500. I am very familiar with this calculation and cannot get anywhere close to what is being produced by this linked data type