Downloads

• Recommend:

Avg User Rating 0

Popular in Spreadsheet

1. Outlook Duplicate Items Remover (ODIR) 30,252     
2. Residential Real Estate Excel Model 310     
3. Fast PRN to Excel Converter 52     
4. Excel Calendar Template 25,086     
5. Gnumeric 5,360     

See more popular software »

Portfolio Optimization

• Version: 3.0
• Downloads Count: 244
• License Type: Trial
• Price: $26
• Date Added: May 24, 2012
• Operating Systems: Microsoft Windows 9x, Microsoft Windows 98 SE, Microsoft Windows 98, Microsoft Windows ME, Microsoft Windows ME, Microsoft Windows NT 4.0, Microsoft Windows 2000 Professional, Microsoft Windows 2000Macintosh OS X, Macintosh OS X 10.4 (Tiger), Macintosh OS X 10.3 (Panther), Microsoft Windows XP Professional, Microsoft Windows XP, Microsoft Windows XP HomeMacintosh OS X, Macintosh OS X 10.4 (Tiger), Macintosh OS X 10.3 (Panther), Microsoft Windows NT 4.0, Microsoft Windows 2000 Professional, Microsoft Windows 2000, Microsoft Windows Server 2003, Microsoft Windows Vista Home Basic, Microsoft Windows Vista Home Premium (32 bit), Microsoft Windows Vista Home Basic (32 bit), Microsoft Windows Vista Business (64 bit), Microsoft Windows 7 Starter, Microsoft Windows 7 Home Basic, Microsoft Windows 7 Professional, Microsoft Windows 7 Enterprise, Microsoft Windows 7 Ultimate
• Requirements: Excel 97 or higher for Windows. Excel 2004 or 2011 for Mac OS X.
• Author: Business Spreadsheets

Before you download:

Click here to scan Windows for issues affecting performance »

Sponsored Link

• Description
• User Reviews

Description of Portfolio Optimization

The Portfolio Optimization template identifies the optimal capital weightings for a portfolio of financial investments that gives the highest return for the lowest risk based on the return risk profile and correlation between individual investments. The design of the portfolio optimization model enables it to be applied to either financial instrument or business stream portfolios. The portfolio optimization template is intuitive and flexible with help icons throughout to assist with input and interpretation of output results. Input of historical data for the analysis is supported by options to specify absolute prices or returns, number of current units held and a tool to download long time periods of financial market data for securities from the internet. Advanced optimization options include setting minimum and maximum constraints for weightings in the optimal portfolio and risk analysis options for overall volatility under the Sharpe ratio, downside risk or semi-deviation under the Sortino ratio and gain/loss under the Omega ratio. Optimization can be set to maintain at least the current level of return and specify a target return for which the probability of attaining is calculated via Monte Carlo simulation. The portfolio optimization results are displayed with weighting charts and return distributions as well as acquisition and liquidation actions required. Technical analysis is provided with back tested total return from signal trading and automatic optimization of technical period constants for each investment or the total portfolio that results in the highest back tested return. Technical analysis indicators with detailed charting and back testing analysis include simple moving average (SMA), rate of change (ROC), moving average convergence/divergence (MACD), relative strength index (RSI) and Bollinger Bands. The template is compatible with Excel 97-2010 for Windows and Excel 2011 or 2004 for Mac as a cross platform portfolio optimization solution.

Most recent User Reviews for Portfolio Optimization

Not a member? Register Now.

Add Your Review

Email Address

Password

Sign In

Forgot your password?

Submit your Review

How long have you used this software?
Days Weeks Months Years

On a scale of 1 to 5 stars, how would you rate this product?

		Superior
		Very Good
		Good
		Fair
		Poor

What are this product's strengths?

What are this product's weaknesses?

What's your overall evaluation?

Submit

Be the first to review Portfolio Optimization »