Is it possible to estimate a beta value of a time series data (stock) using the CAPM model on NumXl?

• 공식 댓글

  

  Mohamad

  2017년 01월 31일 20:36 (편집된 시간 2021년 08월 04일 20:42)

  Check out the white paper on calculating CAPM beta using the regression functions in NumXL

  https://numxl.com/blogs/calculating-capm-beta/

   

  댓글 작업 고유 링크
• 

  Mohamad

  2013년 03월 31일 20:14 (편집된 시간 2021년 08월 04일 20:43)

  To estimate the CAPM beta, you need to regress (SLR) between the two-time series: market returns and your asset returns.

  Asset Return = risk-free return + beta * Market Return

  You can use the NxRegress function to compute the slope (i.e. Beta) for the two-time series. See the function reference page and example:

  https://support.numxl.com/hc/en-us/articles/215811083-NxRegress-Simple-Linear-Regression-Function

  You can even compute the beta value for different dates (using prior data) and examine the variation of beta over time.

  0

  댓글 작업 고유 링크

댓글을 남기려면 로그인하세요.