+ Reply to Thread
Results 1 to 2 of 2

Optimal Portfolio Diversification?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Optimal Portfolio Diversification?

    This might not be the best place to look for an answer because the question is more about asset allocation and designing an optimal portfolio, but I've noticed quite a few pretty intelligent people around here so I figure I'd ask.

    So I through the use of data, I have come up with rating scores of a number of different securities. I took the 5 (15 in one case) best scores in 7 different sectors in order to create my optimal portfolio. Now my question comes on how I should weight my investments in these securities.

    Each sector will have equal weight, but the weight of the securities within each sector is what I need to come up with.

    Any ideas? Possibly using the standard deviation of the group of securities in each sector to help determine weights?

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Optimal Portfolio Diversification?

    Search for Efficient Frontier tools in Excel to help you with the math. I had to create one for a class way back when, and I don't know how much of finance you know. Essentially, this process finds the best weighting of investments to reach a target return with minimized risk. You are on the right track, it uses standard deviations of the returns as part of the calculations.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. Solver: Optimal Portfolio
    By leviathan86 in forum Excel General
    Replies: 3
    Last Post: 11-20-2013, 06:20 PM
  2. Optimal
    By SynGC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2012, 10:17 AM
  3. Optimal Portfolio Macro/Program
    By bkopeikin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2008, 02:11 PM
  4. [SOLVED] Computing Mutual Fund Diversification
    By bilvihur@hvc.rr.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-16-2006, 09:10 AM
  5. [SOLVED] Lookings for optimal coefficient
    By The Surfer in forum Excel General
    Replies: 2
    Last Post: 11-16-2005, 12:45 AM

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