CalculatingBetasUsingRawData

CalculatingBetasUsingRawData - Calculating Betas Using Raw...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Calculating Betas Using Raw Data Beta is not a magical number and its calculation is not an exact science. Differences in returns and intervals used can impact the different beta estimates for companies. The internet exercise will take you through the basic calculation of a beta using Excel in order to demystify a company beta. The Yahoo Finance site is where you need to go to get financial information for companies, which is the raw data you need to calculate betas. Once you are at this site you need to find a box titled “Get Quotes” which you need to type in the stock symbol (if unsure of the stock symbol go to “Symbol Lookup”).To download financial data from the internet follow the detailed instructions. Data download instructions 1. In the Get Quotes box type in the stock symbol (for example Shell is SC and the S&P500 index is ^SPC). 2. Select the chart from the dropdown box to the right and click on the Get Quotes Button. Click on Historical Quotes which is located under the graphs of stock prices and stock volumes. 3.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/10/2010 for the course IAH 001 taught by Professor Wang during the Spring '10 term at Michigan State University.

Ask a homework question - tutors are online