Portfolio Optimization
Your rating: Now say why...

0

Excel template calculates optimal capital weightings.   Shareware ($26.00)
Add to my Watch List
Email me when discounted
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
What's New
Version 4.2:
  • Interface design enhancements
  • Compatibility enhancements with versions of Excel for Mac
Requirements
  • Intel/PPC
  • OS X 10.5 or later
  • Excel 2004 or Excel 2011



MacUpdate - Portfolio Optimization



    Be the first to recommend a similar software title.
Portfolio Optimiza... User Discussion (Write a Review)
ver. 4.x:
Your rating: Now say why...
Overall:
(1)

sort: smiles | time
burypromote

FinanceMac reviewed on 09 Jan 2012
Works on Windows version of Excel as well which makes it a nice cross platform solution. A bit slow on the Mac though.
[Version 2.1]


There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.

There are currently no ratings. Write a comment or review now.

Downloads:2,620
Version Downloads:156
Type:Business : Spreadsheets
License:Shareware
Date:21 Oct 2013
Platform:PPC 64 / PPC 32 / Intel 64 / Intel 32 / OS X
Price: $26.00
Overall (Version 4.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-1 of 1
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
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-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform portfolio optimization solution.


- -