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 analyzes the probability of attaining a target return via Monte Carlo simulation. The portfolio optimization results are displayed with weighting charts and return distributions as well as acquisition and liquidation actions required. The optimization process saves possible portfolios along the extremities of the efficient frontier. Pivotal profiles for minimum and maximum return, risk, and ratios can be subsequently loaded for analysis. 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.
What is new in this release:
Compatible with Excel 2016.
What is new in version 5.0:
Save as XLSM feature for recent versions of Excel and enhanced exporting functions.
Microsoft Excel 97-2013
Like it? Share with your friends!
Other Windows Software of Developer «Business Spreadsheets»:
Excel Invoice Template The Excel invoice template is a complete customer invoicing system with the ability to store invoices, products and customers as well as monitor inventory levels and perform advanced invoice sales reporting. The architecture of the Excel invoice template a
Excel Business Valuation The Excel Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business plan scenarios. Business valuation is based on the traditional discounted cash flow method but also evaluates economic
Bond Yield Calculator The Bond Yield Calculator for Excel or Open Office Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The bond yield to maturity calculator is designed to handle odd first time periods and i
Project Management Template for Excel The Project Management template for Excel is designed as a generic Excel based solution to plan and manage projects. The ability to build the project budget as tasks are identified assists with the requirements for business case project proposals, valuatio
Multiple Regression Analysis and Forecasting The Multiple Regression Analysis and Forecasting template enables the confident identification of value drivers and forecasting business plan or scientific data. The multiple regression process utilizes commonly employed statistical measures to test the va
Real Options Valuation The Real Option Valuation template combines a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Traditional discounted cash flow investment analysis will only accept an investme
Portfolio Performance Monitoring The Excel Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model enables the entering of investment transactions during a reporting period to calculate performance.
DataTrakConverter DataTrakConverter is a Unit Measuring calculator supporting both U.S. and Metric systems. Show how many Fluid Ounces are in a Gallon or how many Cups are in a Liter. Stand alone version of the utility that is used in DataTrakPOS Restaurant Point of Sale So
CPU CPU is a Cost Per Unit calculator to assist in deciding what product and packet size is the best value for money. The window stays on top and there are two independent calculations shown to make comparing prices easier. It is written in Assembly Language f
Abacre Cash Register Abacre Cash Register is a new generation of cash register software for Windows. It is an affordable solution for most typical cash register operations. The user interface is carefully optimized for high speed input of a client's order and prevention of com
Choice Accounting Choice Accounting provides you with a complete Accounting, Banking and General Ledger software system to help you manage your business and accounting needs. We want you to use our program on a daily basis. If you do, as your business grows you will order o
PractiCount and Invoice PractiCount and Invoice is a powerful text counting and invoicing software for freelance translators,transcriptionists, writers. This tool can do a batch text count of multiple Word, PowerPoint, Excel, WordPerfect, HTML, XML, PDF files. Adjustable word, li
Financial Calculators Professional financial calculators by Rwent Inc mortgage calculator - find solutions for: period of mortgage, interest rate, purchase price, down payment, payment. Calculators by rwent inc. Now includes the ability to save your calculations. You can create
Timesaver 2006 Tired of filling out paper work? Can't find the time to focus on building your Avon business? Timesaver 2006 can help you organize your customers. It can track multiple addresses, phone numbers, and customer ordering statistics. You can even personalize yo
Meta Trader Account Copier The purpose of this software is to help traders, who use Meta Trader 4 trading terminal, in their routine work with trading signals. Some traders, who can not trade successfully by themselves, prefer to copy trades of professional traders. Some successful
MembershipPro Finance A complementary application to MembershipPro for complete financial management by churches, synagogues, and clubs. Integration with the MembershipPro database associates members with contributions and pledges. Full financial support including income, contr
Cashflow Plan Free For preparing detailed monthly cash flow projections for cash planning, business plans, fund raising etc. for 6 months ahead. Includes facilities for rolling forward projections and sensitivity analysis. For smaller businesses. Especially useful for busine
Supported Operating Systems:
Windows 10 |
Windows 2000 |
Windows 2003 |
Windows 7 |
Windows 8 |
Windows 98 |
Windows Me |
Windows NT |
Windows Vista |
Windows XP |
Comments on Portfolio Optimization:
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10