Entering text into the input field will update the search result below

How To Calculate Stock Beta In Excel-Replicating Yahoo Stock Beta

Sep. 08, 2020 10:05 AM ETMETA
rvarb profile picture
rvarb's Blog
Please Note: Blog posts are not selected, edited or screened by Seeking Alpha editors.

Seeking Alpha Analyst Since 2013

Trader and blogger at


In a previous post, we presented a method for calculating a stock beta and implemented it in Python. In this follow-up post, we are going to implement the calculation in Excel. We continue to use Facebook as an example. Recall that,

In finance, the beta (market beta or beta coefficient) is a measure of how an individual asset moves (on average) when the overall stock market increases or decreases. As such, beta is a useful measure of the contribution of an individual asset to the risk of the market portfolio when it is added in small quantity. Thus, beta is referred to as an asset’s non-diversifiable risk, its systematic risk, market risk, or hedge ratio. Beta is not a measure of idiosyncratic risk. Read more

We utilize the following equation to calculate the stock beta,

Quantitative analysis of stock beta


  • rS is the stock return,
  • rM is the market return,
  • Cov denotes the return covariance and,
  • Var denotes the return variance.

We downloaded 5 years of monthly Facebook data from Yahoo Finance. We implemented the above equation in Excel and obtained a beta of 1.21

How to calculate stock beta in Excel

The picture below shows Facebook beta calculated by Yahoo Finance. It is 1.26. Our result agrees well with Yahoo’s result, although there is a small difference.

stock beta calculation using Excel

Click on the link below to download the Excel workbook.

Also, let us know what you think where the difference comes from.

Article Source Here: How to Calculate Stock Beta in Excel-Replicating Yahoo Stock Beta

Analyst's Disclosure: I/we have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.

Seeking Alpha's Disclosure: Past performance is no guarantee of future results. No recommendation or advice is being given as to whether any investment is suitable for a particular investor. Any views or opinions expressed above may not reflect those of Seeking Alpha as a whole. Seeking Alpha is not a licensed securities dealer, broker or US investment adviser or investment bank. Our analysts are third party authors that include both professional investors and individual investors who may not be licensed or certified by any institute or regulatory body.

Recommended For You

To ensure this doesn’t happen in the future, please enable Javascript and cookies in your browser.
Is this happening to you frequently? Please report it on our feedback forum.
If you have an ad-blocker enabled you may be blocked from proceeding. Please disable your ad-blocker and refresh.