HOME BusinessSpreadsheets Portfolio Optimization

Portfolio Optimization 5.0

Description of Portfolio Optimization 5.0:
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.

Supported OS: WinVista x64, WinVista, WinOther, Windows XP, Windows Vista Ultimate x64, Windows Vista Ultimate, Windows Vista Starter, Windows Vista Home Premium x64, Windows Vista Home Premium, Windows Vista Home Basic x64, Windows Vista Home Basic, Windows Vista Enterprise x64, Windows Vista Enterprise, Windows Vista Business x64, Windows Vista Business, Windows 98, Windows 8, Windows 2000, Win7 x64, Win7 x32, Win2000, Mac OS X 10.8, Mac OS X 10.7, Mac OS X 10.6, Mac OS X 10.5, Mac OS X 10.4, Mac OS X 10.3, Mac OS X 10.2, Mac OS X 10.1, Mac OS X

System Req: Requires Microsoft Excel 97 or higher

User reviews: Portfolio Optimization Download

Name: *
Email:
Review: *

 

Popular terms of download Portfolio Optimization:

Software downloads related to Portfolio Optimization

SmartFolio
SmartFolio is a state-of-the-art asset allocation software aimed at all types of investors and investment professionals. It contains advanced portfolio optimization and risk management algorithms, based on latest achievements in portfolio theory. more info download

Excel VBA Models Set 1 XL-VBA
Excel VBA Models Open Source Code Learning Tool - Finance and Statistics Models Set Are you having difficulty understanding how to do finance and statistics within Excel? more info download

Excel VBA Models Set 1
Excel VBA Models with Open Source Code:1. Standard Deviation and Mean2. Lotto Number Generator3. Playing Card Probability4. Normal Random Number 5. Monte Carlo Integration6. Black-Scholes Option Pricing Model7. Binomial Option Pricing Model 8.... more info download

Excel VBA Models Combo Set XL-VBA4
The Excel VBA Models Open Source Code Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code. Programs include Distribution 12 Random Number Generator, 6 Option Pricing Models, 3... more info download

1st Position - Search engine optimization software
Search engine optimization software with Keyword Analyzer & HTML Doorway page generator for top search engine positioning. more info download

FXWitz Flash Photo Portfolio
Makes, Publish online, Update Your Multimedia Portfolio with the images of new works every time you desire at zero cost independently all in Flash with a few click. From today You can: Have yours work on-line, Take advantage from the new... more info download

Web Optimization Angel Pro
Web Optimization Angel Pro: New generation website seo optimisation tool, search engine ranking web site optimization software that helps you to easy to get better position more info download

Web Optimization Angel Pro 2005.6.2
Web Optimization Angel: Top 10 website search engine optimization toolEasy to improve your site's rank by optimizing the most important ranking factors. Generate 45 search engine ranking factors for every keyword. Provide top 10 search engine... more info download

Investment Portfolio Management
OTrader 4.1 is a streamlined, easy-to-use portfolio management tool for stock, option, warrant, future and CFD traders. more info download

Infima Jpeg Optimization SDK
Recompress and Optimize JPEG files by an average of 30% without causing any addition loss in image quality. Infima Jpeg Optimization SDK introduces a new method for preprocessing and optimizing JPEG images before they are compressed. more info download

Cozy Restaurant Reservation for Workgroup
This is a more powerful version of Cozy Restaurant Reservation, with all of the features of the standard version, but with the additional capability to share data in real time over the network. more info download

LANoi Pro
LANoi pro helps simplify networking in an otherwise complex world of IP addresses, ports and dialog boxes, all of which confuse and sometimes even prevent the user from properly enjoying the features of remotely accessing the PC. more info download

News related to Portfolio Optimization

5 best optimization software for Windows 7 PCs - Windows Report
Windows Report
best Windows 7 optimization software More than two billion downloads, CCleaner is an award winning optimization software ideal for Windows 7 users. As its name suggests, CCleaner cleans the PC thoroughly. You may have to...
SAP Updates the Enterprise Information Management Portfolio to Deliver Information Excellence - insideBIGDATA
insideBIGDATA
SAP SE (NYSE: SAP) announced innovations in the enterprise information management (EIM) portfolio to help customers better manage and use their data for digital transformation, cloud, Big Data, the Internet of Things (IoT),...
CCleaner Hacked With Data-Stealing Malware: What to Do Now - Tom's Guide
Tom's Guide
CCleaner, a system-optimization tool with more than 2 billion downloads worldwide, is used by many Windows, Mac and Android users who want looking to keep their devices running as fast as possible. Unfortunately for them, it...
Itron Buys IoT Firm Silver Spring Networks to Boost "Smart Cities" Portfolio - Nasdaq
Nasdaq
On Monday, Itron ITRI and Silver Spring Networks SSNI announced that Itron is set to acquire the Internet of Things company for a 25% premium. The news sent shares of both companies to new 52-week highs. Itron agreed to pay $16.25...
AgileCraft Named Top Strategic Platform in Portfolio Management by Independent Research Firm - Business Wire (press release)
Business Wire (press release)
AUSTIN, Texas--(BUSINESS WIRE)--AgileCraft, the leading provider of software to enable agility in the enterprise, has been named as a Strong Performer in the Forrester Research, Inc. September 2017 report,...
Huge Security Alert: Malware Slipped into CCleaner Could Steal PC User Data - Top Tech News
Top Tech News
Anyone who's recently downloaded CCleaner, a PC optimization tool developed by London-based Piriform, should update the software immediately to avoid malware that was inserted into one version of the program. It's...
Huge Security Alert: Malware Slipped into CCleaner Could Steal PC User Data - CIO Today
CIO Today
Anyone who's recently downloaded CCleaner, a PC optimization tool developed by London-based Piriform, should update the software immediately to avoid malware that was inserted into one version of the program. It's...
Researchers Link CCleaner Hack to Cyberespionage Group - Motherboard en_us
Motherboard en_us
The recent attack that resulted in 2.2 million users installing infected versions of a popular Windows system optimization tool might have been the work of a sophisticated cyberespionage group with a history of software...
Huge Security Alert: Malware Slipped into CCleaner Could Steal PC User Data - NewsFactor Network
NewsFactor Network
Anyone who's recently downloaded CCleaner, a PC optimization tool developed by London-based Piriform, should update the software immediately to avoid malware that was inserted into one version of the program....
Huge Security Alert: Malware Slipped into CCleaner Could Steal PC User Data - NewsFactor Network
NewsFactor Network
Anyone who's recently downloaded CCleaner, a PC optimization tool developed by London-based Piriform, should update the software immediately to avoid malware that was inserted into one version of the program....