Monday, March 2, 2009

Portfolio Manager and Optimizer

This portfolio tool helps you construct a markowitz frontier for equities you have chosen from the list.  It also builds the CML (capital Market Line) from your risky-assets.

It finally shows you all mean-variance efficient portfolios that you can choose from, based on your risk aversion. For every possible risk, it gives the highest return and best asset allocation.

Note:
  1. The list is pre-canned 100 stocks of S&P 100 list. The returns shown were historic 10 yr monthly returns (Jan1998 to Dec2008).
  2. The optimization for mean variance frontier subject to constraints had been performed using Lagrange Multipiers and differential calculus.
  3. Discovering the market portfolio of chosen risk-assets was done using linear algebra involving matrix calc.
The next phase of it will include more complex and sophisticated extensions like black-litterman and Treynor-Black models.



3 comments:

  1. Great tool and effort.
    Would you be able to broaden the assets to include international mkts (ex: MSCI EAFE constituents)?

    ReplyDelete
  2. Looking for similar tool for my usage. is this open source?

    ReplyDelete
  3. good work! overlay this with portfolio level hedging and dynamic rebalancing along with more asset classes (REIT, GSCI)...you got here a commercial grade portfolio tool

    ReplyDelete