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



C: \ Business \ Investment Tools \ Portfolio Optimization 5.2
Portfolio Optimization 5.2 - Detailed Description Page
Click to view Portfolio Optimization 5.2 screenshot
Program ID: 499
Author: Business Spreadsheets     All programs by this author
Downloads: 14014
License: Shareware [?]
Cost (USD): $26.00
Operating Systems: win2000 winxp winvista winvistax64 win7x32 win7x64 win8x32 winserver
Size: 622K
Release Status: update
Last Updated: 2016-09-05
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.2 Buy Portfolio Optimization 5.2

Portfolio Optimization icon100% clean!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.


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

Recent Changes: Compatible with Microsoft Excel 2016 for Windows and Mac

Install Support: Install and Uninstall

Supported Languages: English

Additional Requirements: Requires Microsoft Excel 97 or higher



Latest Releases in Business - Investment Tools
Portfolio Optimization iconPortfolio Optimization 5.2   (2016-09-05)   update
Portfolio optimization and technical analysis for managing financial investments
Portfolio Performance Monitoring iconPortfolio Performance Monitoring 3.2   (2016-09-05)   update
Monitoring and tracking the performance of a portfolio of financial assets.
NewsAutoTrader iconNewsAutoTrader 2.0   (2013-11-05)   update
Forex news spike trading autoclick software. Includes autoclick feature.
StockMarketEye iconStockMarketEye 3.1.5   (2013-11-02)   update
Easy to use Portfolio Tracker and Stock Watcher with integrated Stock Charts
EZQuote iconEZQuote 1.09.000   (2013-10-27)   update
EZQuote allows you to download historical end-of-day quotes
BulkQuotesXL Pro iconBulkQuotesXL Pro 7.0.4   (2013-09-20)   update
Download free quotes and apply technical analysis functions in Excel worksheets.
AnalyzerXL Pro iconAnalyzerXL Pro 7.0.3   (2013-09-20)   update
Comprehensive technical analysis library for Microsoft Excel
RTQuotesXL Pro iconRTQuotesXL Pro 7.0.4   (2013-09-20)   update
Download securities' real-time and delayed data directly into your workbook
DownloaderXL Free iconDownloaderXL Free 7.0.4   (2013-09-20)   update
Free quotes for stocks, indices, mutual funds, futures, options, and dividends.
BacktestingXL Pro iconBacktestingXL Pro 7.0.3   (2013-09-20)   update
Test and evaluate your trading strategies in Excel. Simple strategy creation.




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:
Launch your own PAD site

PAD Site Scripts - Launch your own download site!
Ultra DVD Creator iconUltra DVD Creator 2.9.0412: Create DVD VCD SVCD Video Disc from almost all formats of video files ImTOO Video Converter Ultimate iconImTOO Video Converter Ultimate 7.7.2.20130701: Best video converter to convert video/audio files to various multimedia devices. Edraw Organizational Chart iconEdraw Organizational Chart 7.2: Create Organizational charts and business charts with minimum time loss! CDRipper iconCDRipper 2.86: CDRipper copies tracks from audio CDs and saves them in WAV format.

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