Search for:    
Search in:        
String match:      
Home Featured Submit Link To Us Contact Us



C: \ Business \ Investment Tools \ Portfolio Optimization 5.0
Portfolio Optimization 5.0 - Detailed Description Page
Click to view Portfolio Optimization 5.0 screenshot
Program ID: 8133
Author: Business Spreadsheets     All programs by this author
Downloads: 29
License: Shareware [?]
Cost (USD): $26.00
Operating Systems: win9xme win2000 winxp winvista winvistax64 win7x32 win7x64 win8x32
Size: 544K
Release Status: update
Last Updated: 2014-09-29
Our Rating: Not rated yet...   Not rated yet...
Users Rating: Not Rated Yet     (total votes: 0)
Feedback: Report broken download     Report spyware [?]
Download Portfolio Optimization 5.0 Buy Portfolio Optimization 5.0

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


Keywords: Excel, portfolio, optimization, management, asset, allocation, analysis, technical, indicators, signals, total, return, risk

Recent Changes: Save as XLSM feature for recent versions of Excel and enhanced exporting functions.

Install Support: Install and Uninstall

Supported Languages: English

Additional Requirements: Requires Microsoft Excel 97 or higher



Latest Releases in Business - Investment Tools
Fund Manager 2014 - Professional iconFund Manager 2014 - Professional 2014.13.5   (2014-12-03)   update
Portfolio Management for Professional Traders
TradeTrakker iconTradeTrakker 3.01   (2014-11-18)   update
Powerful investment tracking program to automatically track stocks/mutual funds
Portfolio Performance Monitoring iconPortfolio Performance Monitoring 3.0   (2014-09-29)   update
Monitoring and tracking the performance of a portfolio of financial assets.
Portfolio Optimization iconPortfolio Optimization 5.0   (2014-09-29)   update
Portfolio optimization and technical analysis for managing financial investments
TinyTrader iconTinyTrader 1.0.8   (2014-05-02)   update
TinyTrader - Tools for the small and tiny trader
Market System Analyzer iconMarket System Analyzer 3.4   (2013-12-18)   update
Advanced money management strategies for stock and futures traders.
EZQuote iconEZQuote 1.09.000   (2013-10-27)   update
EZQuote allows you to download historical end-of-day quotes
Portfolio Manager iconPortfolio Manager 1.97   (2013-05-11)   update
Personal stock portfolio management, tracking and reporting
Stock Ticker Application Bar iconStock Ticker Application Bar 2.30   (2013-01-07)   update
Stock ticker that displays scrolling stock and indices quotes on your desktop
Stock Predictor iconStock Predictor 1.1.352   (2012-11-17)   update
Stock market charting and investment strategies backtesting software




All Programs:
0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

All Authors:
0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

RSS Feeds:
(Current Category)
RSS Feed for New Releases and Updates New releases & updates
RSS Feed for New Shareware Releases New shareware releases
RSS Feed for New Freeware Releases New freeware releases
RSS Feed for Most Popular Software Most popular software
RSS Feed for Top Rated Software Top rated software
Feeds List in OPML Feeds list in OPML

Useful Resources:
iOS Data Recovery
ZIP RAR ACE Password Recovery
Asterisks Password Viewer
MD5, SHA-1 File Checksum Tool
Volume Serial Number Editor
pad-site-scripts.com
Password Recovery Software

Sudoku 9981 iconSudoku 9981 5.01: Create, print, play and solve unlimited Sudoku puzzles. File Checksum Tool iconFile Checksum Tool 1.23: File Checksum Tool generates MD5, SHA-1, HAVAL and other hashes from any file. A VIP Organizer iconA VIP Organizer 2.9.38: Personal task management software for workflow optimization by to-do list usage. EfficientPIM iconEfficientPIM 3.81.0.379: EfficientPIM is a full-featured personal information manager.

Home | Featured | Submit | Link To Us | Contact Us | FAQ | About Us | Advertise