Portfolio Optimization

The Portfolio Optimization template optimizes capital weightings for portfolios of financial investments that maximizes return and minimizes risk. Technical analysis constant parameters are optimized to maximize back tested returns on signal trading.

Portfolio Optimization 3.0
Publisher: Business Spreadsheets License: Shareware
Version: 3.0 Date Added: 10 September, 2012
File Size: 376.0 KB Downloads: 36
Price: $26.00 Editor Rating: 5 Stars
Systems: Mac OS X, Macintosh, Win2000, Win7 x32, Win7 x64, Win98, WinVista, WinVista x64, WinXP

Advertisement

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.

Portfolio Optimization 3.0 Related Software

Portfolio Optimization 3.0 Keyword
Portfolio Optimization 3.0 Publisher's Products
  • Customer Invoice Template 1.0
    A customer invoice management system with order tracking and sales reporting.
  • Portfolio Performance Monitoring 2.0
    The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. Amount and timing of investment and divestment transactions are taken into account in performance calculations.
  • Project Planning and Management 2.0
    The Project Planning and Management template is designed as a generic solution to plan and manage any project from start to finish. Automated features include Gantt scheduling, participant workbook creation, and progress update from remote files.
  • Real Option Valuation 1.0
    The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios.
  • Investment and Business Valuation 1.0
    The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios.
  • Bond Yield Calculator 2.0
    The Bond Yield Calculator for Excel or OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.
  • Regression Analysis and Forecasting 1.0
    The Multiple Regression Analysis and Forecasting model provides a solid basis for identifying value drivers and forecasting business plan data.

Social bookmarks:
  Add to Delicious Add to Technorati Add to Blogmarks Add to Digg Add to Reddit Add to Furl Add to Newsvine Add to Slashdot Add to StumbleUpon Add to Blinklist

Text link code :
Hyper link code:
UBB/BLOG code:

Download Now
File Size: 376.0 KB