In financial/investment terminology, beta is a measurement of volatility or risk. Expressed as a numeral, it shows how the variance of an asset – anything from an individual security to an entire portfolio – relates to the covariance of that asset and the stock market (or whatever benchmark is being used) as a whole.  Or as a formula:

What is Beta?

Let's break down this definition further.  When you have exposure to any market, whether it's 1% of your funds or 100%, you are exposed to systematic risk. Systematic risk is undiversifiable, measurable, inherent and unavoidable.  The concept of risk is expressed as a standard deviation of return.  When it comes to past returns – be they up, down, whatever – we want to determine the amount of variance in them. By finding this historical variance, we can estimate future variance. In other words, we are taking the known returns of an asset over some period, and using these returns to find the variance over that period. This is the denominator in the calculation of beta. (Want to learn more about excel? Take Investopedia's excel courses online.) 

Next, we need to compare this variance to something.  The something is usually "the market." Although "the market" really means "the entire market" (as in all risk assets in the universe), when most people refer to "the market"  they are typically referring to the U.S. stock market and, more specifically, the S&P 500. In any event, by comparing our asset's variance to that of "the market," we can see its inherent amount of risk relative to the overall market's inherent risk: This measurement is called covariance.  This is the numerator in the calculation of beta. 

Interpreting betas is a core component in many financial projections and investment strategies. 


Calculating Beta in Excel

It may seem redundant to calculate beta, since it's a widely used and publicly available metric. But there's one reason to do it manually: the fact that that different sources use different time periods in calculating returns.  While beta always involves the measurement of variance and covariance over a period, there is no universal, agreed-upon length of that period. Therefore, one financial vendor may use five years of monthly data (60 periods over five years), while another may use one year of weekly data (52 periods over one year) in coming up with a beta number.  The resultant differences in beta may not be huge, but consistency can be crucial in making comparisons. 

To calculate beta in Excel:

  1. Download historical security prices for the asset whose beta you want to measure.
  2. Download historical security prices for the comparison benchmark.
  3. Calculate the percent change period to period for both the asset and the benchmark. If using daily data, it's each day; weekly data, each week, etc.
  4. Find the Variance of the asset using =VAR.S(all the percent changes of the asset).
  5. Find the Covariance of asset to the benchmark using =COVARIANCE.S(all the percent changes of the asset, all the percent changes of the benchmark).


Issues with Beta

If something has a beta of 1, it's often assumed that asset will go up or down exactly as much as the market. This definitely is a bastardization of the concept. If something has a beta of 1, it really means that, given a change in the benchmark, its sensitivity of returns is equal to that of the benchmark.  

What if there are not daily, weekly, or monthly changes to assess?  For example, a rare collection of baseball cards still has a beta, but it cannot be calculated using the above method if the last collector sold it 10 years ago, and you get it appraised at today's value.  By only using two data points (purchase price 10 years ago and value today) you would dramatically underestimate the true variance of those returns.  

The solution is to calculate a project beta using the Pure-Play method. This method takes the beta of a publicly traded comparable, unlevers it, then relevers it to match the capital structure of the project. 


  1. What is the formula for calculating beta?

    Learn about beta, how to calculate it, and how it's used as a risk measure with examples that include Apple and Tesla Inc. Read Answer >>
  2. What are the differences between delta hedging and beta hedging?

    Learn about hedging strategies, how to delta and beta hedge a security and the difference between delta hedging and beta ... Read Answer >>
  3. Why should I register as a Limited Liability Company (LLC) if I am self-employed ...

    Understand the difference between a company's levered beta and unlevered beta. Learn how debt affects a company's levered ... Read Answer >>
  4. How does Beta reflect systematic risk?

    Learn what systematic risk is, what beta is and how it is related to market indexes, and how beta reflects the systematic ... Read Answer >>
  5. What is the difference between standard deviation and variance?

    Understand the difference between standard deviation and variance; learn how each is calculated and how these concepts are ... Read Answer >>
Related Articles
  1. Investing

    Beta: Know the Risk

    Beta says something about measuring price risk in stocks, but how much does it say about fundamental risk factors too?
  2. Financial Advisor

    Calculating Beta: Portfolio Math For The Average Investor

    Beta is a useful tool for calculating risk, but the formulas provided online aren't specific to you. Learn how to make your own.
  3. Investing

    3 Cases When Beta Does Not Measure Volatility of Stocks

    Examine the theoretical and statistical relationship between beta and volatility to identify three factors that limit beta's explanatory value.
  4. Investing

    Smart Beta: Can Low Beta Equal High Risk?

    Low beta may not necessarily mean low risk when it comes to some smart beta strategies.
  5. Investing

    5 Low-Beta DJIA Stocks To Know

    Check out five low-beta stocks that can help you to diversify your portfolio.
  6. Investing

    Investopedia's Guide to Smart Beta ETF Investing

    Smart Beta may be one of those financial terms that raises the ire of many market participants, but its success in spawning a new class of exchange traded funds (ETFs) is indisputable.
  7. Investing

    Rising Rates Can Propel Smart Beta Bond ETFs

    Fixed income is viewed as the next smart beta growth frontier. Rising rates could help.
  8. Investing

    Are Smart Beta ETFs Hyped? (PRF, BLK)

    Pay attention to the percentage of smart beta ETFs that manage to survive after the next five years, proving or refuting the existence of a hype.
  9. Investing

    What You Should Know About Smart Beta ETFs

    What you need to know about smart beta ETFs and the strategies behind them.
  1. Beta

    Beta is a measure of the volatility, or systematic risk, of a ...
  2. Beta Risk

    Beta risk is the probability that a false null hypothesis will ...
  3. Smart Beta

    Smart beta investing combines the benefits of passive investing ...
  4. Smart Beta ETF

    A smart Beta ETF is a type of exchange-traded fund that uses ...
  5. Portable Alpha

    Portable alpha is a strategy in which portfolio managers separate ...
  6. International Beta

    International beta (often known as "global beta") is a measure ...
Hot Definitions
  1. Financial Risk

    Financial risk is the possibility that shareholders will lose money when investing in a company if its cash flow fails to ...
  2. Enterprise Value (EV)

    Enterprise Value (EV) is a measure of a company's total value, often used as a more comprehensive alternative to equity market ...
  3. Relative Strength Index - RSI

    Relative Strength Indicator (RSI) is a technical momentum indicator that compares the magnitude of recent gains to recent ...
  4. Dividend

    A dividend is a distribution of a portion of a company's earnings, decided by the board of directors, to a class of its shareholders.
  5. Inventory Turnover

    Inventory turnover is a ratio showing how many times a company has sold and replaces inventory over a period.
  6. Watchlist

    A watchlist is list of securities being monitored for potential trading or investing opportunities.
Trading Center