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 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
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.
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
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
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
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
Business Accounts Business Accounts has all the standard bookkeeping functions that you would expect to see in an accounting software package, such as full sales, purchase and nominal ledgers. Business Accounts gives you a comprehensive accounting package written by a UK co
Lading Manager Lite With Lading Manager Lite you can enter, print, and track your bills of lading. It will produce a straight bill of lading on blank paper rather than preprinted forms. Store all of your customers, carriers, and products for fast retrieval on your bills. Bill
Job Service Invoice Template Like a regular invoice form, this job service invoice template details your company information, invoice #, invoice date, customer information; besides that, it also has space for you to enter essential information like job date (start date and end date),
EconExact (Swedish) EconExact is a Swedish, free software for billing. The software has all functions needed for small and middle size businesses including credit notes, reminders, export and mass update of data etc. There are no limits to the numbers of customers, orders, in
Thesaurus Payroll Manager Thesaurus Payroll Manager is designed to automate many of the processes involved in the financial administration of your company's employees. Like all Thesaurus products it is very simple to use and produces powerful, effective results. In time you'll wond
Forex Trader Sidekick Forex Trader Sidekick is a windows software program made for all of you who trading Forex and want a quick-reference to real-time market hours of Tokyo, Sydney, London, and New York Forex markets. In addition to Forex market hours this program also offers:
Invoice Template with Two VAT Tax Rates This free VAT invoice template has two VAT rates that can be set on the bottom of the invoice form. When creating an invoice, you choose the tax category from a dropdown list for each invoicing item; the invoice template calculates tax using the tax rate d
Express Accounts Plus Edition Express Accounts Plus easily tracks payments and deposit transactions. View balances and reports to see how your business is doing. You can also e-mail or fax reports directly to your accountant. Express Accounts is designed to be intuitive and very easy t
Multi-SWAC Basic Multi-SWAC Basic is a user friendly program for the creation of cashflow forecasts that does away with the need to understand spreadsheets. Multi-SWAC is designed to easily produce cashflows over multiple years, all with a simple user interface. Multi-SWAC
TMS IDE Rich Clip for (C++Builder 2011/C++Builder XE) TMS IDE Rich Clip for (C++Builder 2011/C++Builder XE) allow you to copy selected source code in IDE editor as rich text and HTML formatted text. It automatically retrieves IDE syntax highlighting color settings.
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