Portfolio Optimization 5.0 Details

Download

Shareware 544 KB


The Portfolio Optimization template calculates the optimal capital weightings for a portfolio of investments that produces the highest return for the lowest risk. Additional technical analysis provides the ability to optimize trading strategies based on technical indicator parameters that produce the highest total return on back tested Buy and Sell signal trading.

Publisher Description

Window 10 CompatibleThe Portfolio Optimization template identifies the optimal capital weightings for a portfolio of financial investments that gives the desired risk and return profile based on the correlation between individual investments. The design of the portfolio optimization model enables it to be applied to either financial instrument or business stream portfolios with long and short positions. 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-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform portfolio optimization solution.

Download and use it now: Portfolio Optimization

Related Programs

Tuning Portfolio

The program has been created to support the decision processes in investment management. It will be useful not only for an investor, investment advisor or an asset manager, but also for anyone who intends to enter the world of investments...

  • Demo
  • 20 Jul 2015
  • 471 KB

Portfolio Manager

Portfolio Manager is a personal stock portfolio management system with the aim of being a complete stock trading diary. With minimal effort and time you can keep track of which stocks you have bought and sold, along with any associated...


Portfolio Performance Monitoring

The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model enables the entering of investment transactions during a reporting period to calculate performance. Incremental investment transactions including withdraw, reinvestment and...


TickInvest - Stock Charting and Technical Analysis

TickInvest is a stock charting and technical analysis software with realtime and eod charts. Features: Trade Simulator, Backtester, Backtest Optimizer, Stock Screener, Alerts, Custom Drawing Tools, Stock Quotes, Extensible Formula Language. Analyze your favorite stocks with ready to use Indicators...


Software Asset Management

Software Asset Management 3 provides powerful tools for software inventory and license management. All software from your Windows and Mac OS devices is gathered in a single place with comprehensive search and filtering capabilities. Browse, organize, and discover your software...


Screenshot


Details

Keywords