Home | Business | Spreadsheets | Portfolio Optimization 3.0
 

Portfolio Optimization 3.0

 
FREE DOWNLOAD
Download Portfolio Optimization 3.0
BUY NOW
Buy Portfolio Optimization 3.0




Portfolio Optimization template

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.

Platforms: Mac OS , Win7 x32 , Win7 x64 , WinVista x64 , Windows 2000 , Windows 95/98 , Windows Vista , Windows XP , Mac OS X , Win2000 , Win98 , WinVista , WinXP

System requirements: Requires Microsoft Excel 97 or higher

Price: $26.00

Versions History:

Date Released: Version: Change Info:
2012-05-21 00:00:00 3.0 The Omega ratio has been integrated. Technical analysis has been added with ability to optimize constant parameters to maximize back tested return on buy and sell signals. Includes detailed analysis and charting of simple moving average, rate of change, moving average convergence/divergence, relative strength and Bollinger bands. Provides the ability to apply a capital amount equally to starting portfolio weightings. Optimization can be undertaken on both long and short portfolios. Code has been designed to increase processing speed.

 
Added: 24 May, 2012 05:25 File size: 376.0 KB
Status: new Download times: 56 kb/s: 54 s
Program type: shareware   128 kb/s: 24 s
      512 kb/s: 06 s
 
del.icio.us digg submit to reddit MyWeb BlogMarks
  
URL:  HTML:  
FREE DOWNLOAD
Download Portfolio Optimization 3.0
BUY NOW
Buy Portfolio Optimization 3.0

Tags: Excel, Portfolio, Optimization, Management, Asset, Allocation, Analysis, Technical, Indicators, Signals, Total, Return, Risk

More Software from Business Spreadsheets:


 
More Similar Software
 

The Portfolio Optimization model calculates the optimal capital weightings for a basket of financial investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial...

SmartFolio is the most powerful asset allocation software aimed at all types of investors and investment professionals. It contains state-of-the-art portfolio optimization and risk management techniques, based on latest achievements in portfolio...

Business planning and portfolio optimization are made easy with PalantirPLAN. PLAN provides a graphical dynamic interface for portfolio analysis and visualization. Companies benefit from more informed, reliable, timely decision making based on...

Effective portfolio management requires quick and easy access to vital data, analytics, and quantified, current information. While there is no shortage of information on the web, the amount of time required to find the data can be considerable,...

Excel VBA Models Open Source Code Learning Tool - Excel VBA Models Combo Set (Set 1, 2, and 3) The Excel VBA Models Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code. Finance...

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? Do you want to see practical examples? The Financial and Statistics Model...

Various quantitative finance algorithms in areas related to asset allocation and portfolio simulation. Includes Black-Litterman model, State/Preferencem Interior points, and Active Set quadratic optimization.

The Portfolio Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore,...

FREE DOWNLOAD
Download Portfolio Optimization 3.0
BUY NOW
Buy Portfolio Optimization 3.0
 
Similar Scripts
 

Update and manage any online portfolio faster and easier with DMXReady Portfolio Manager. Designed for use by photographers, artists, interior designers, design companies, architects, videographers, and anyone who wants a fast and easy display...

ST Portfolio is a dynamic web portfolio program that provides all the tools you need to create a beautiful online portfolio in just minutes and then quickly maintain and expand your online portfolio on the fly. Anyone in business knows the...

A PHP and MySQL based application to help domain owners better organize their portfolio. It allows you to list your domains with their expiry, registrar, price, status (For Sale, Make Offer, Sold), and category. Also allows visitors to your...

The portfolio management website allows visitors to sign up for an account to create an online portfolio including Work Experience, Profile, News and store their digital photos online for thier portfolio catalog. The admin specifies different...

The Student Portfolio Portal is designed to help and guide students, teachers, and parents. It allows your child/student to create and maintain an online portfolio of his/her work. This online portfolio will follow your student/child through the...

FREE DOWNLOAD
Download Portfolio Optimization 3.0
BUY NOW
Buy Portfolio Optimization 3.0
Categories
Related Downloads

Portfolio Optimization 1.0
87 downloads Portfolio Optimization template

 

SmartFolio 3.0.68
116 downloads Powerful asset allocation software

 

PalantirPLAN 3.7
12 downloads Business planning and portfolio optimization

 

SmartFolio Professional Edition 1.0.2
81 downloads Portfolio analysis and optimization software

 

Excel VBA Models Combo Set XL-VBA4.0 6.3
119 downloads Excel VBA Models Open Source Code Learning Tool - Excel VBA Models Combo Set (Set 1, 2, and 3) The Excel VBA Models Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code.

 

Excel VBA Models Set 1 XL-VBA1.0 6.3
122 downloads 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?

 

Portfolio Allocation/Simulation 1.0
1 downloads Various quantitative finance algorithms in areas related to asset allocation and portfolio simulation.

 

Portfolio Monitoring 1.0
93 downloads The portfolio monitoring model for Excel.

 

Personal Portfolio Manager 7.0.2
38 downloads Portfolio management and analysis.

 

Portfolio Performance Monitoring 1.0
53 downloads Portfolio Performance Monitoring template

 
Related Searches

Binary Portfolio Optimization - Free Portfolio Optimization Excel - Portfolio Optimization 2 - Portfolio Optimization 5 - Portfolio Optimization Excel - Portfolio Optimization Problem - Portfolio Optimization Software - Portfolio Optimization Spreadsheet - Portfolio Optimization Tools

Popular Downloads
Latest Software Searches