Products of this category
SmartCodeComponent 4.22
SmartCodeComponent allows you to easily add professional quality barcodes to Office documents like those from Word and Excel. It exposes a full range of barcode properties and allows precise control over barcode dimensions.
Visual Options Analyzer 4.5.6
Visual Stock Options Analyzer (VOptions) is a powerful analysis tool for development, testing, and application of stock and options strategies. VOptions allows you to test your strategies, and explore "what-if" scenarios with ease.
RTQuotesXL Pro 7.0.3
RTQuotesXL Pro is an add-in for MS Excel 2010 designed to help you download securities' real-time and delayed data directly into your workbook. Data is available from more than 50 worldwide markets, including the US, Canada, UK, Germany, France etc.

Portfolio Optimization 3.0

Portfolio Optimization 3.0
5 Stars

4 Stars
Select your Rating:
License: Shareware
Size: 376.0 KB
Date added: 2012-05-26
Downloads: 185
Downloads - Last week: 0
Price: $26.00
OS: Windows , WinXP , Win98 , Win7 x64 , Win7 x32 , Mac OS X
System Requirements: Requires Microsoft Excel 97 or higher



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.



Keywords of Portfolio Optimization
Downloads from Business Spreadsheets
Portfolio Performance Monitoring 2.3 -  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. ... (144/0) download
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. While it utilises a range of commonly employed statistical measures to test the validity of the ... (213/0) download
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. Traditional discounted cash flow investment analysis will only accept an ... (52/0) download
Investment and Business Valuation 2.3 -  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. ... (362/0) download
Customer Invoice Template 1.0 -  The Customer Invoicing Template is an Excel invoice template with the ability to store invoices, products and customers and perform advanced invoice sales reporting. The database structure of the invoice system allows the insertion, update and quick ... (212/0) download
Project Planning and Management 1.0 -  The Project Planning and Management template is designed as a generic and affordable Excel based solution to plan and manage any project. The ability to build the projectâ??s budget as tasks are identified facilitates the processes of business cas ... (478/0) download
Bond Yield Calculator 1.0 -  The 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. ... (61/0) download
Multiple Regression Anal 1.0 -  Multiple Regression Analysis and Forecasting The Multiple Regression Analysis and Forecasting model provides a solid basis for identifying value drivers and forecasting business plan data. ... (226/0) download
Multiple 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 While it utilises a range of commonly employed statistical measures to test the validity of the analysis, r ... (65/0) download
Optimal Hedging Strategy 2.0 -  The Optimal Hedging Strategy template is a simple tool, which automatically calculates the optimal percentage of exposure to hedge and the resulting net economic savings. ... (2/0) download
Related Press, Software News