Results 1 to 3 of 3

Thread: I need help with plotting efficient frontier in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    66

    I need help with plotting efficient frontier in Microsoft Excel

    How to plot efficient frontier from sets of data containing expected return, average return, variance, standard deviation, covariance and correlation.

  2. #2
    Join Date
    Jul 2011
    Posts
    642

    Re: I need help with plotting efficient frontier in Microsoft Excel

    The fundamental idea of the efficient frontier of investment, is that, given a series of expected returns and risk, combining them properly, you can find the minimum risk portfolio, and from this, all possible combinations of efficient investment . This is because an appropriate diversification of our portfolio, we can help reduce risk and enhance expected returns. It is very complicated in Excel.

  3. #3
    Join Date
    Jun 2011
    Posts
    641

    Re: I need help with plotting efficient frontier in Microsoft Excel

    The efficient frontier of investment shows the infinite combinations of risk and return we can achieve with this group of eleven actions. The yellow dot up and to the right, any portfolio that is on the curve is efficient. This is due, if we take a point that is below, there will be a portfolio on the curve have the same return but lower risk.

Similar Threads

  1. A software for Vinyl Cutting/Plotting except Corel
    By Upendra in forum Windows Software
    Replies: 8
    Last Post: 05-04-2012, 06:48 AM
  2. Replies: 6
    Last Post: 17-02-2012, 12:18 PM
  3. Replies: 4
    Last Post: 13-02-2011, 09:37 AM
  4. Efficient Macro Recorder Excel Lite cannot function with Windows 7
    By Mariah-Simpson in forum Windows Software
    Replies: 4
    Last Post: 21-04-2010, 04:15 AM

Posting Permissions

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