Home > By category > Business & Productivity Tools >Spreadsheets > Portfolio Optimization



Portfolio Optimization

  • Downloads: 
  • Views: 
  • Rating:

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.

Free download from Shareware Connection - 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.

Publisher: Business Spreadsheets | License: Shareware | Price: 26.00
Version: 5.0 | Size: 544 KB | Platform: Win98,WinOther,Win2000,WinXP,Win7 x32,Win7 x64,Windows 8,WinVista,WinVista x64,Mac Other,Mac OS X
Released Date: 10-04-2015 | Rating: 0 | Title: Portfolio Optimization

Author Url: http://www.business-spreadsheets.com/
Program Info Url: http://www.business-spreadsheets.com/portopt.htm
Download Url: http://www.business-spreadsheets.com/download/excel_portopt.zip
Screenshot Url: http://regnow.img.digitalriver.com/vendor/8612/portopt.jpg

More downloads from Portfolio Optimization publisher Business Spreadsheets:

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.

Portfolio Performance Monitoring - 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.

Customer Invoice Template - The customer invoicing system is an Excel invoice template with ability to store created invoices, products and customer details and perform advanced order sales reporting.

Bond Yield Calculator - 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.

Regression Analysis and Forecasting - 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.

Portfolio Optimization keywords:
Portfolio Optimization related downloads:

SmartFolio - SmartFolio is a state-of-the-art asset allocation software aimed at all types of investors and investment professionals. It contains advanced portfolio optimization and risk management algorithms, based on latest achievements in portfolio theory.

MProfit - Portfolio Management Software - An easy-to-use and powerful portfolio management application

Macroaxis - Asset Allocation, Performance Evaluation, Correlation Analysis

Master Investor - Portfolio management and technical analysis for individual investors.

Risk and Asset Allocation - These routines support the book "Risk and Asset Allocation" Springer Finance, by A. Meucci, see

Shareware Connection periodically updates pricing and software information of 'Portfolio Optimization' from company source 'Business Spreadsheets' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft,  Using 'Portfolio Optimization' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of Portfolio Optimization.

New Reviews

SnapCrab - Nearly every PC users need to take screenshots from time to time, whether it is for personal or professional needs. While using the basic Windows screenshot capture method is available, it is not adequate for everyone. When you want to capture ...

TuckAway Intelligent Email Organizer Pro - Using an email software allow you to do a number of things including managing your address lists, emails and even ending memos, documents and even virtual letters. You can also use it to manage your tasks easily. The email software comes in ...

WebAcappella - Web design sector has witnessed several trends and technological innovations affect website development in big ways. With time, designing websites has become easier. Nowadays, you can find web design software that nearly eliminates the need to ...

Zoolz - No serious PC user needs introduction about the need to backup data, both at home and workplace. There was a time when majority of people used external HDD or storage media to backup important data. However, local data backup has its limitations ...

WWPass BlackBook and Personal Secure Storage - With time, PC security is turning out to be more complex and tedious matter. You can no longer rely on security apps but ensuring privacy of data is also important. While many password manager apps offer secure data encryption options, losing the ...

Avast Endpoint Protection Suite Plus - PC security has become a vital aspect of computing nowadays and business users face the heat more than home users. While installing and handling a standalone antivirus suite is neither tedious nor time consuming, the scenario is different in ...

CCleaner Network Edition - Keeping computers clean of redundant and junk data is a prerequisite and these are various methods to do that. Apart from integrated utilities that come with Windows, you can also use third party utilities to keep PC clean of junk files and ...

WebSite X5 Evolution 10 - Web designing has evolved lot compared to the early days of the internet. You can pick from a number of web design apps and frameworks that take away the pain of manual coding and debugging to a large extent. Even then, it may be necessary to ...

Autodesk MotionBuilder 2015 - 3D animators and post production setups need to use Motion capturing technology extensively for making stunning films, ads and tutorials etc. Over the years, both software and hardware technology used in this segment have evolved by leaps and ...

ProAnimator - In Post production setups and 3D animation studios, using specialized CG and special effects app becomes a necessity. ProAnimator is a feature rich 3D design application targeted at motion graphics sector. It is ideal when you want to add some ...




New Downloads

Modbus OPC server

OPC server allow data exchange
between Modbus devices and
SCADA systems or other OPC
clients. Supported Modbus RTU,
TCP, ...

dbForge Unit Test for SQL
Server

GUI for implementing automated
unit testing based on the
open-source tSQLt framework in
SQL Server Management Studio

Cinema Booking System

Cinema Booking System
(developed by PHPJabbers)
enables you to sell tickets
for countless movies and
performances online, ...

AttendHRM - Payroll

AttendHRM is a complete
payroll software for small to
large organizations that
automates all your payroll
processes. ...

Flashnote

Flashnote is a quick notes
manager for your quick work
with any text information. You
can always have it at hand and
you ...

Project Planning Pro

Project Management App on Mac.
Create a project plan in no
time by entering tasks,
duration and start dates. Use
the ...

Lodgit Desk Hotel Software
for Mac

Booking software for all kinds
of lodging establishments
incl. reservation schedule,
booking and guest list,
cleaning ...

Small Library Organizer Pro

Library Software for Windows.
Library database maintenance
system for small private,
public, or corporate
libraries. Our ...

Image Watermarker

Image Watermarker watermarks
image files with pictures and
text with variable opacity
levels. The program comes with
an ...

Manage Your Contacts

Manage Your Contacts is a
tried and true program that
will help you easily store and
manage contact information
(names, ...

Face Crop Jet

Fully Automated,Zero
Configuration Face Detection
and Cropping for ID Cards

Express Accounts Accounting
Free

Express Accounts Accounting
Software Free is professional
business accounting software.
This product is perfect small
...