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»:
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
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
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
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
Excel Bookkeeping Set 2x1 This system covers all needs in handling your bookkeeping records and is good for your family and your small business purposes too. Give reports and balances for all your expenses and income. It is a universal system to be to be fully customized by you. Yo
Personal Accounts Personal Accounts is the ultimate in home and small business accounting software. Ideal if you want a simple, straight forward, and fast solution to your finances. Great for use in the home to manage your everyday spending and monthly outgoings. Brilliant
InstantInvoice 3 Invoicing and billing software for the small business. Track customer payments and outstanding invoices. Very fast setup and easy to use. Preview and print powerful reports and charts instantly like invoice listings, sales by customer, outstanding invoice
Real Estate and Property Investing Sales Software This software will allow you to enter information to compare real estate sales in your area. This means you can compare sale prices and details about each property. Every investor needs this piece of software. Version 1 includes unspecified updates.What is
QuotesTK Basic Investors who want quick access to free historical stock quotes, look no further. QuotesTK quickly downloads securities grouped by their designated index. It keeps your indices up-to-date by automatically downloading the most recent securities lists to ref
Free Invoice Template-Excel Invoice Form Excel Invoice Template-Free invoice Template and invoice software based on Excel. It is a great, all-purpose Excel invoice form for creating any type of business invoices. This invoice template comes with a sample that is ready for you to add your company
BillPower BillPower is a fully integrated timekeeping, billing, and bookkeeping system that will produce a wide variety of reports, including income-expense statements, balance sheets and aged receivables reports. The user has wide latitude in designing billing form
Hodoman Timer Hodoman Timer is a complete and fully customizable Internet Cafe Software, Cyber Cafe Software, based on a client-server architecture. The client application resides on each computer station in your network. It provides your customers access to the groups
Portfolio Analysis Review Stock investment clubs need the ability to review their stock portfolio, particularly as the value of their holdings grow. Portfolio Analysis Review opens multiple .ssg stock data files and presents a spreadsheet analysis of each holding in the portfolio.
Icverify Icverify turns any computer into a credit card processing machine. Works on any computer for all major credit cards. ICverify will require a "merchant services credit card accounts" provided by Advanced Merchant Services in order to accept credit cards. IC
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