+ Reply to Thread
Results 1 to 3 of 3

Standard Deviation, Portfolio Returns Shortcuts

  1. #1
    Registered User
    Join Date
    06-16-2015
    Location
    New York, NY
    MS-Off Ver
    11
    Posts
    1

    Standard Deviation, Portfolio Returns Shortcuts

    Can anyone help me with the following formulas? I understand how to do the calculations but not the shortcuts.. You need to take the returns along with their weight in the portfolio and then calculate std.dev, variance, and return.

    Screen Shot 2015-06-16 at 12.40.56 AM.png
    Last edited by davidvanpatten; 06-16-2015 at 12:50 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Standard Deviation, Portfolio Returns Shortcuts

    Hi there... and welcome to the Excel Forum. Unfortunately I don't understand what you want to do. Forget about the weights for the minute. Are you saying that you want the SD, Variance and "return" of 15, 10, -12, -4 and 3? If not, please explain again. Also, what do you understand by "return"?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Standard Deviation, Portfolio Returns Shortcuts

    Quote Originally Posted by davidvanpatten View Post
    Can anyone help me with the following formulas? I understand how to do the calculations but not the shortcuts.. You need to take the returns along with their weight in the portfolio and then calculate std.dev, variance, and return.
    Attachment 401284
    For your example:

    C7, portfolio sd: =SQRT(C8)
    C9, portfolio return: =SUMPRODUCT(B1:B5,C1:C5)

    Your example does not provide sufficient information to calculate the portfolio variance (C8).

    To learn how to do the calculations, Click here [1] for an explanation with 3 assets and N assets.


    -----
    [1] www.ewp.rpi.edu/hartford/~youneh/INVII/Week%204/mv_analysis_2up.pdf

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting real time stock quotes from google finance / yahoo finance in excel
    By Navin Agrawal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2012, 12:41 PM
  2. Finance HW Plz Help
    By skizz135 in forum Excel General
    Replies: 1
    Last Post: 05-27-2009, 07:25 PM
  3. FINANCE Formula Help
    By JCH in forum Excel General
    Replies: 1
    Last Post: 04-10-2006, 12:35 AM
  4. Replies: 1
    Last Post: 01-16-2006, 04:15 AM
  5. finance functions
    By Star in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2005, 03:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1