- Recommend:
Portfolio Optimization
- Version: 3.0
- Downloads Count: 244
- License Type: Trial
- Price: $26
- Date Added: May 24, 2012
- Operating Systems: Microsoft Windows 9x, Microsoft Windows 98 SE, Microsoft Windows 98, Microsoft Windows ME, Microsoft Windows ME, Microsoft Windows NT 4.0, Microsoft Windows 2000 Professional, Microsoft Windows 2000Macintosh OS X, Macintosh OS X 10.4 (Tiger), Macintosh OS X 10.3 (Panther), Microsoft Windows XP Professional, Microsoft Windows XP, Microsoft Windows XP HomeMacintosh OS X, Macintosh OS X 10.4 (Tiger), Macintosh OS X 10.3 (Panther), Microsoft Windows NT 4.0, Microsoft Windows 2000 Professional, Microsoft Windows 2000, Microsoft Windows Server 2003, Microsoft Windows Vista Home Basic, Microsoft Windows Vista Home Premium (32 bit), Microsoft Windows Vista Home Basic (32 bit), Microsoft Windows Vista Business (64 bit), Microsoft Windows 7 Starter, Microsoft Windows 7 Home Basic, Microsoft Windows 7 Professional, Microsoft Windows 7 Enterprise, Microsoft Windows 7 Ultimate
- Requirements: Excel 97 or higher for Windows. Excel 2004 or 2011 for Mac OS X.
- Author: Business Spreadsheets
Description of Portfolio Optimization
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.
Sponsored
-
Remove duplicate entries from Outlook.
-
This is the single most important tool you will ever use in your real estate investing! A professional pre-built Excel spreadsheet that calculates and details the profitability of any residential real estate investment. Input the detailed property...
-
Fast PRN to Excel Converter can convert .PRN (Space Delimited Formatted Text) files to MS Excel XLS files or .CSV (Comma Delimited) files or .TXT (Tab Delimited Text) Files, it can process thousands of files within several minutes, saving your time...
-
Print out nicely formatted calendars using Excel.
-
An Excel competitor that won't put a dent in your wallet.
-
Save time and money by analyzing spreadsheet models with this Excel add-in.
-
This tool allow to read/open the Paradox tables on any computer. An application don't use any external libraries (no BDE, no ODBC, no ADO etc) You may see the full Paradox system information, table structure and data in grid.
-
ASAP Utilities puts all sorts of tools you've wanted or never imagined onto one Excel ribbon.
-
The Time-Weighted Return calculator will produce your own "personalized" rate of return, that takes into account the timing of when you invest money into or take money out of a mutual fund throughout the year.
-
Double-check your spreadsheet's formulas with this Excel add-in.
-
IdeaPad U300s If there's a laptop that deserves the moniker "Ultrabook" it's the Lenovo IdeaPad U300s.
Buy now direct from Lenovo -
ThinkPad X220 Fast and light, with great input ergonomics and battery life, this powerhouse ultraportable is best-of-breed.
Buy now direct from Lenovo -
ThinkPad T420 Just about every IT person we know swears by the T series--for their clients and themselves.
Buy now direct from Lenovo
Most Recent Threads
Ad Choices