Portfolio Optimization v.5.0

Advertisement
Advertisement

The 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.

Portfolio Optimization template. 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.

excel, portfolio, optimization, management, asset, allocation, analysis, technical, indicators, signals, total, return, risk

 
  • Portfolio Optimization
  • 5.0
  • 10 Apr 15
  • Business Spreadsheets
  • Win98, WinOther, Win2000, WinXP, Win7 x32, Win7 x64, Windows 8, WinVista, WinVista x64, Mac Other, Mac OS X
  •  
  • Shareware
  • 544 Kb
  • 1328
  • $26.00
 
 
Latest Versions History
Version Date Released Release Notes
5.0 10.04.2015 Save as XLSM feature for recent versions of Excel and enhanced exporting functions.
 
 

Review Portfolio Optimization

  • captcha
 

Other software of Business Spreadsheets
  • Bond Yield Calculator  v.3.0The Bond Yield to Maturity calculator for Excel and OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.
  • Customer Invoice Template  v.1.0The customer invoicing system is an Excel invoice template with ability to store created invoices, products and customer details and perform advanced order sales reporting.
  • Investment and Business Valuation  v.3.0The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows.

New Finance software
  • A VIP Purchase Management Solution  v.4.13Professional tool for Purchasing Team project, workflow management. Manage your orders, deliveries, invoices, suppliers, employees, projects and tasks. Plan, track and report your purchasing team's activities, share your contacts, calendar, docs etc ...
  • Horizon ERP  v.1.1Billing Software , With complete inventory and accounts modules Ideal for small businesses into retailing , distribution and manufacturing .complete tutorial are available on our website ...
  • ChequeSystem Cheque Printing Software  v.4.3.0ChequeSystem provides a complete cheque printing and management solution. You are no need to write any, just print and sign it. All issued cheques are kept in records. Account report and payee report provides details cheques issued history ...