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.
Advanced Find Replace for Excel The Ablebits.com Advanced Find Replace enhances Excel's built-in Find with simultaneous search in values, formulas and comments in all opened or selected worksheets and workbooks. The add-in works in Excel 2003 - 2010.
Ablebits.com Ultimate Suite for Excel 40+ professional tools for Excel 2016-2007 to automate frequently performed tasks such as matching and merging worksheets, removing duplicates in one sheet or between two lists, consolidating multiple files into one, cleaning data and more.
Ablebits.com Trim Spaces for Excel The Trim Spaces for Excel add-in helps you remove leading and trailing spaces in selected cells. Just select a cells, click the "Run" button of the add-in and no excess spaces are left in your worksheet. Works with Excel 2010, 2007, 2003, XP, 2000.
Investment and Business Valuation The 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.
Real Options Valuation The Real Option Valuation template provides a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing models include Black-Scholes, Binomial, and Game Theory.
Portfolio Performance Monitoring The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations.
Version: 5.1 Released: Sep, 30 2015 License: Shareware, $26.00 Expires: Expires after 30 Days
File size: 592 K Platforms: Windows 8/7/Vista/XP/2000; Other OS Downloads: 180
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.