Beta Index
One of my foreign clients is asking me about the beta index for various U.S. companies within our industry. I don't have a clue how to figure it and can't find anything on Ameritrade. Can anyone tell me how to figure it without too much difficulty or where to find it for specific companies? Thanks.
Betas are calculated by plotting an index return (usually the S&P 500) vs an individual stocks return. You simply download the previous prices into excel and calculate the the slope of the companies returns relative to the S&P 500 returns.
What data should you use? Daily data often has a lot of noise and therefore isn't used. Most analysts use weekly returns of two to three years, or monthly returns for three to five years.
What data should you use? Daily data often has a lot of noise and therefore isn't used. Most analysts use weekly returns of two to three years, or monthly returns for three to five years.
Originally Posted by srs3,May 6 2008, 11:37 AM
You simply . . . calculate the the slope of the companies returns relative to the S&P 500 returns.
Originally Posted by srs3,May 6 2008, 11:37 AM
What� data should you use?� Daily data often has a lot of noise and therefore isn't used.� Most analysts use weekly returns of� two to three years, or monthly returns for� three to five years.
Trending Topics
^
The SLOPE function in excel gives the same output as the equation COVAR(company returns,S&P returns) / VARP(S&P returns).
I only included what data should be used in my previous post because the original poster asked how to figure out beta.
With regard to yahoo, an article in the stock section says they use 5 years of monthly returns.
The SLOPE function in excel gives the same output as the equation COVAR(company returns,S&P returns) / VARP(S&P returns).
I only included what data should be used in my previous post because the original poster asked how to figure out beta.
With regard to yahoo, an article in the stock section says they use 5 years of monthly returns.
Originally Posted by srs3,May 6 2008, 12:38 PM
The SLOPE function in excel . . .
Originally Posted by srs3,May 6 2008, 12:38 PM
. . . the equation COVAR(company returns,S&P returns) / VARP(S&P returns).
Originally Posted by srs3,May 6 2008, 12:38 PM
With regard to yahoo, an article in the stock section says they use 5 years of monthly returns.



