How to Calculate the Standard Deviation of a Portfolio

PDF download Download Article
PDF download Download Article

The standard deviation of a portfolio represents the variability of the returns of a portfolio. [1] To calculate it, you need some information about your portfolio as a whole, and each security within it.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/79\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-1.jpg\/v4-460px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-1.jpg","bigUrl":"\/images\/thumb\/7\/79\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-1.jpg\/aid6176823-v4-728px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    First we need to calculate the standard deviation of each security in the portfolio. You can use a calculator or the Excel function to calculate that. [2]
    • Let's say there are 2 securities in the portfolio whose standard deviations are 10% and 15%.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4b\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-2.jpg\/v4-460px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-2.jpg","bigUrl":"\/images\/thumb\/4\/4b\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-2.jpg\/aid6176823-v4-728px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    We need to know the weights of each security in the portfolio.
    • Let's say we've invested $1000 in our portfolio of which $750 is in security 1 and $250 is in security 2.
    • So the weight of security 1 in portfolio is 75% (750/1000) and the weight of security 2 in portfolio is 25% (250/1000).
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/07\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-3.jpg\/v4-460px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-3.jpg","bigUrl":"\/images\/thumb\/0\/07\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-3.jpg\/aid6176823-v4-728px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Correlation can be defined as the statistical measure of how two securities move with respect to each other. [3]
    • Its value lies between -1 and 1.
    • -1 implies that the two securities move exactly opposite to each other and 1 implies that they move in exactly the same way in same direction.
    • 0 implies that there is no relation as of how the securities move with respect to each other.
    • For our example, let's take correlation as 0.25 which means that if one security increases by $1, the other increases by $0.25.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1c\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-4.jpg\/v4-460px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-4.jpg","bigUrl":"\/images\/thumb\/1\/1c\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-4.jpg\/aid6176823-v4-728px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Variance is the square of standard deviation. [4]
    • For this example, variance would be calculated as (0.75^2)*(0.1^2) + (0.25^2)*(0.15^2) + 2*0.75*0.25*0.1*0.15*0.25 = 0.008438.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-5.jpg\/v4-460px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-5.jpg","bigUrl":"\/images\/thumb\/6\/69\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-5.jpg\/aid6176823-v4-728px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Standard deviation would be square root of variance. [5]
    • So, it would be equal to 0.008438^0.5 = 0.09185 = 9.185%.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/10\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-6.jpg\/v4-460px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-6.jpg","bigUrl":"\/images\/thumb\/1\/10\/Calculate-the-Standard-Deviation-of-a-Portfolio-Step-6.jpg\/aid6176823-v4-728px-Calculate-the-Standard-Deviation-of-a-Portfolio-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    As we can see that standard deviation is equal to 9.185% which is less than the 10% and 15% of the securities, it is because of the correlation factor:
    • If correlation equals 1, standard deviation would have been 11.25%.
    • If correlation equals 0, standard deviation would have been 8.38%.
    • If correlation equals -1, standard deviation would have been 3.75%.
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How and why would I diversify a portfolio?
    Donagan
    Top Answerer
    Diversify by investing in many different kinds of assets at the same time: stocks, bonds, and commodities, as well as mutual funds and exchange-traded funds that invest in those assets. Do this because these various assets will appreciate in value at different rates, thus protecting you by offsetting temporary losses in one asset class with simultaneous gains in another.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 3
  • Question
    Why is a standard deviation of portfolio important?
    Donagan
    Top Answerer
    It is important to people who are interested in stability of income. It allows comparison of the stability of one investment to that of another.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 1
  • Question
    Which portfolio(s) is/are good to create?
    Donagan
    Top Answerer
    That depends on your goals and your tolerance for risk. If your desire for capital appreciation outweighs your fear of losing any money, you'll accumulate an aggressive portfolio of "growth" stocks. If you're more interested in safety than impressive gains, you'll buy blue-chip stocks and index funds. Discuss this with a fee-only advisor.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 0
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Make Money with Sweatcoin
      How to
      Calculate an Annual Percentage Growth Rate
      How to
      Calculate NPV
      How to
      Calculate Dividends
      How to Find the Maturity Value for an Investment
      How to Delete a Robinhood Account
      How to
      Calculate Annualized Portfolio Return
      How to
      Set Up a Stop‐loss Order
      How to
      Calculate Beta
      How to
      Start Investing
      How to
      Calculate Bond Accrued Interest
      How to
      Start an Investment Club
      How to
      Calculate Intrinsic Value
      How to
      Annualize a Quarterly Return
      Advertisement

      References

      1. ↑ https://www.investopedia.com/terms/s/standarddeviation.asp
      2. ↑ https://www.wallstreetmojo.com/portfolio-standard-deviation/
      3. ↑ https://slickbucks.com/articles/portfolio-standard-deviation/#tab-con-10
      4. ↑ https://www.investopedia.com/ask/answers/071515/how-can-i-measure-portfolio-variance.asp
      5. ↑ https://www.investopedia.com/terms/p/portfolio-variance.asp

      About This Article

      Thanks to all authors for creating a page that has been read 136,043 times.

      Did this article help you?

      Advertisement