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»:
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
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.
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
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
Newsletter Publishing Invoice Template This is free invoice template or free invoice form is designed with the special requirements of newsletter publishing business in mind. The invoice documents includes not only the usual fields required by an invoice form, such as invoice ID, invoice date,
GeoDLL GeoDLL supports the development of geodetic software on different platforms by providing geodetic functions. GeoDLL contains precise functions of the themes 2D and 3D coordinate transformation, geodetic datum shift, reference system conversion, meridian st
Expense and Income Manager Software This software offers a solution to users who want to manage expenses. The simple-to-use interface allows entry of income and expenditure, which are displayed in the top and bottom panes. The software will automatically total each of these and the results c
Scarlit Invoicer Lite Scarlit Invoicer Lite is a business software package that allows you to create professional invoices quickly and easily. Start with a choice of templates and customize with your logo and choice of fields. You can even dream up your own fields, with data sp
Verecom FX Tradebox The Verecom FX Tradebox allows you to subscribe to data from some of the leading forex traders in the world. Our primary partner returns approximately 3%-5% per month on managed accounts unleveraged. Their trade calls and market-moving FX news events are a
Control System With Clock Control System With Clock is a gadget for windows Vista and Windows 7. With this Control System With Clock you can simple control standby, shutdown, restart, logoff or hibernate your Computer from you Windows Sidebar. It contains 16 types of skin.
BizPapers - Windows BizPapers provides a consolidated interface to business process documentation necessary for effective internal control design and audit planning. All entities, processes, risks, and controls are managed as an outline, allowing quick review of documentation
Zen Commission Calculator Easy-to-use calculator for rapidly working out single level commissions on all types of sales. Specific tabs for Real Estate and affiliate marketing sales. Includes the ability to save and recall commission rates and percentages. This version is the first
MoneyWorks Gold MoneyWorks Gold is a fully integrated multi-user accounting and business information system featuring Cashbook, General Ledger, Accounts Receivable, Accounts Payable, Inventory, Custom Reporting, Custom forms generation, Sales and Purchase analysis, Depart
Octopus Micro Finance Suite Octopus Micro Finance Suite (OMFS) is an open source (LGPL) Micro Finance IT software. This software is available to the community of micro finance institutions. OCTOPUS MFS is an integrated suite allowing full management of a Micro Finance Institution: cl
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