TransWikia.com

calculating the std devation of portfolio

Personal Finance & Money Asked on December 26, 2020

If I have a portfolio with hypothetical time-weighted returns by month of the following:

Jan-20 = 2%
Feb-20 = 5%
Mar-20 = 50%
Apr-20 = 6%
May-20 = -5%
Jun-20 = 0%
Jul-20 = -10%
Aug-20 = 4%
Sep-20 = 20%
Oct-20 = 7%
Nov-20 = 30%

Then in excel can I just use the standard deviation function to get a std dev of 17.2% for the portfolio, or do I need to add 1 to all of these returns and then calculate the standard deviation i.e. Jan-20 = 1.2 and so on.

One Answer

enter image description here

Easy enough to just do in the spreadsheet and see the result is identical.

Correct answer by JTP - Apologise to Monica on December 26, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP