Portfolio Optimization 5.0

Portfolio Optimization 5.0
Publisher: Business Spreadsheets Date added: 12 May, 2015
License: Shareware Size: 544.0 KB
Price: $26.00
Editor rating: 5 Stars

The Portfolio Optimization template optimizes capital weightings for portfolios of financial investments that maximizes return and minimizes risk. Technical analysis constant parameters are optimized to maximize back tested returns on signal trading.

Description:

The Portfolio Optimization template identifies the optimal capital weightings for a portfolio of financial investments that gives the desired risk and return profile based on the correlation between individual investments. The design of the portfolio optimization model enables it to be applied to either financial instrument or business stream portfolios with long and short positions. 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-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform portfolio optimization solution.

Tags: Excel, Portfolio, Optimization, Management, Asset, Allocation, Analysis, Technical, Indicators, Signals, Total, Return, Risk
Platforms: Mac
Requirements: Requires Microsoft Excel 97 or higher
Latest Downloads

The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows. The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows.

The Bond Yield to Maturity calculator for Excel and OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The Bond Yield to Maturity calculator for Excel and OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.

The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations. The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations.

The Multiple Regression Analysis and Forecasting template provides a reliable identification of value drivers and forecasting business plan data. Advanced statistical tests performed include significance, autocorrelation and multicollinearity. The Multiple Regression Analysis and Forecasting template provides a reliable identification of value drivers and forecasting business plan data. Advanced statistical tests performed include significance, autocorrelation and multicollinearity.

The Real Option Valuation template provides a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing models include Black-Scholes, Binomial, and Game Theory. The Real Option Valuation template provides a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing models include Black-Scholes, Binomial, and Game Theory.

The invoice template for Excel is a simple to use and complete customer invoicing and inventory management system. The Excel invoice template stores invoices, products and customers and performs advanced invoice sales reporting and inventory monitori The invoice template for Excel is a simple to use and complete customer invoicing and inventory management system. The Excel invoice template stores invoices, products and customers and performs advanced invoice sales reporting and inventory monitori

Project Planning and Management The Project Planning and Management template is designed as a generic solution to plan and manage any project from start to finish. Automated features include Gantt scheduling, participant workbook creation and progress update from remote files.

The best tool to make Labels and Business The best tool to make Labels and Business card. huge graph and picture storehouse, strong graph and picture process ability which PhotoShop compares favourably

The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations. The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations.

Portfolio Optimization 5.0 - Post Your Review
 * 
 * 
     
 * 
Related Downloads

Business Process Manager will help you optimize your time and effort in being a Project Manager, Consultant or Supporter. Fine-tune as many cost-driving parameters as you want. See costs and net profit displayed graphically over 48 months. Business Process Manager will help you optimize your time and effort in being a Project Manager, Consultant or Supporter. Fine-tune as many cost-driving parameters as you want. See costs and net profit displayed graphically over 48 months.

If you could look 1 year ahead, would you want to see? Startup Product Manager will help you calculate your business. Fine-tune as many cost-driving parameters as you want. See revenue and net profit results graphically displayed over 48 months. If you could look 1 year ahead, would you want to see? Startup Product Manager will help you calculate your business. Fine-tune as many cost-driving parameters as you want. See revenue and net profit results graphically displayed over 48 months.

XLSTAT is a complete data analysis and statistics add-in for Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods. XLSTAT is a complete data analysis and statistics add-in for Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods.

Quicker and better presentation generation. The FastChange-Toolbar simplifies the professional creation of powerpoint presentations. It offers more than 100 functions, realizes Corporate Design prerequisites and integrates existing slide libraries and templates.

Risk Register, Risk Heat Maps and Matrix, KRIs, Treatment Register, Control Register, Automated Analysis, Custom Lists, 640 charts, 50+ video training, thousands of links to navigate. This edition: no VBA or formula. Other editions: visit our site. Risk Register, Risk Heat Maps and Matrix, KRIs, Treatment Register, Control Register, Automated Analysis, Custom Lists, 640 charts, 50+ video training, thousands of links to navigate. This edition: no VBA or formula. Other editions: visit our site.

Import/export of CSV, XLS, XML, SQL, ... Import/export of text files (CSV, XLS, XML, DBF, ASCII, SQL) from/to MS Access, MS Excel, MS SQL Server, MySQL, SQLite, PostgreSQL, Oracle, OleDB and ODBC data streams. A graphical interface to define the import/export process makes it very simple.

An affordable, lighting-fast, easy to use and the most compatible Microsoft Office alternative. Includes TextMaker, PlanMaker, and Presentations. Supports the latest Microsoft Office Open XML file(.DOCX, .XLSX, and .PPTX) formats and PDF export. An affordable, lighting-fast, easy to use and the most compatible Microsoft Office alternative. Includes TextMaker, PlanMaker, and Presentations. Supports the latest Microsoft Office Open XML file(.DOCX, .XLSX, and .PPTX) formats and PDF export.

Comprehensive PDF Viewing File manipulation, OCR, Security, Multimedia comments, Spellchecker, XFA, Import Directly from XPS and other support formats, Scan, Sharepoint, Convert to Poverpoint Comprehensive PDF Viewing File manipulation, OCR, Security, Multimedia comments, Spellchecker, XFA, Import Directly from XPS and other support formats, Scan, Sharepoint, Convert to Poverpoint

Antamedia Internet Cafe controls, secures, and enhances the running of your Internet cafe, gaming center, library, school or hotel public computers. The software restricts access to the system, desktop, drivers, folders and programs. Antamedia Internet Cafe controls, secures, and enhances the running of your Internet cafe, gaming center, library, school or hotel public computers. The software restricts access to the system, desktop, drivers, folders and programs.

Professional tool for Sales Team project, workflow management. Combines functions of CRM, TeamOrganizer, ProjectManager, DocumentManager. Allows your team to plan, track and report of your sales team's activities, share your contacts, calendar etc. Professional tool for Sales Team project, workflow management. Combines functions of CRM, TeamOrganizer, ProjectManager, DocumentManager. Allows your team to plan, track and report of your sales team's activities, share your contacts, calendar etc.

The best tool to make Labels and Business The best tool to make Labels and Business card. huge graph and picture storehouse, strong graph and picture process ability which PhotoShop compares favourably

The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations. The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations.