- Audio & Multimedia
- Business
- Communications
- Desktop
- Development
- Education
- Games
- Graphics
- Home & Hobby
- Network & Internet
- Screen Savers
- Security & Privacy
- Servers
- System Utilities
- Web Development
- PickMeApp Pro
- imyPass iPassGo
- RPM Remote Print Manager...
- GHC Timetables generator EN
- ExtraDisks Home
- FTP Client Engine for...
- Professional File Recovery...
- 7Caps
- BriskBard
- DocPad
- VidMasta
- Aml Pages
- BW Meter
- PDFMarkz
- ToolsBaer MSG to HTML...
- ADRC Data Recovery Tools
- avast! Antivirus
- Revo Uninstaller
- Java Runtime Environment
- AVG Anti-Virus Free Edition
- GOM Media Player
- RegSeeker
- IrfanView
- CPU-Z
- Malwarebytes Anti-Malware
- Spybot Search & Destroy
- Skype
- µTorrent
-
2Printer 5.5
Enables you to print any type documents or files in bath mode one after another specifying the paper size and without any...
-
Vivaldi for MacOS 6.6
No ad browser and uses minimum memory, takes very less time to load, some unique features added like notes containing...
-
Win PDF Editor 3.6.3
Editing PDF documents was like nightmare for me but when I am suggested by one of colleagues I tried this and found that...
-
Serial to Ethernet Connector 9.0
It can successfully turn your computer to a terminal server so that any device connected to the com port will be...
-
ShutUp10 1.4.1388
This software will let you take the full control over your windows 10 and decide which program to start automatically or...
-
TeraCopy 3.26
Copies files seamlessly from source to target location, also detects errors while transferring and rectifies it.
-
Ulysses for Windows 2.7.11
Writing application with most of useful features that a standard word processor may offer like markdown, emerging to...
-
InjuredPixels 4.0
It will repair the damaged pixels of the display unit so that it can still be usable for some more days instead of buying...
-
DrvInfo 1.2.0.2016.0
The software will show you the details of a drive as soon as it is inserted into the port whether it is a floppy, flash...
-
Unreal Commander 3.57
Can see the files in windows. You may copy, cut and paste right from there or upload to server directly.
Business / Investment Tools / Portfolio Optimization 5.0
Portfolio Optimization 5.0
Advertisement
Advertisement
Portfolio Optimization 5.0 Description
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.
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.
OS: Mac, Windows, Windows 7, Mac OS X 10.1, Mac OS X 10.2, Mac OS X 10.3, Mac OS X 10.4, Mac OS X 10.5, Mac OS X 10.6, Mac OS X 10.7, Mac OS X 10.8, Mac Os, Mac Os X, Win7 x32, Win7 x64, Windows 2000, Windows 8, Windows 98, Windows Vista, Windows Vista Business, Windows Vista Business x64, Windows Vista Enterprise, Windows Vista Enterprise x64, Windows Vista Home Basic, Windows Vista Home Basic x64, Windows Vista Home Premium, Windows Vista Home Premium x64, Windows Vista Starter, Windows Vista Ultimate, Windows Vista Ultimate x64, Windows XP
System Requirements: Requires Microsoft Excel 97 or higher
Versions History:
Date Released: | Version: | Change Info: |
2015-04-10 | 5.0 | Save as XLSM feature for recent versions of Excel and enhanced exporting functions. |
Tags: Excel - Portfolio - Optimization - Management - Asset - Allocation - Analysis - Technical - Indicators - Signals - Total - Return - Risk
User Reviews of Portfolio Optimization
-
Portfolio Performance Monitoring The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. Amount and timing of investment and divestment transactions are taken into account in performance calculations... Download
-
Real Option Valuation 2.0 The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing tools include Black-Scholes, Binomial, and Game Theory... Download
-
Investment and Business Valuation 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... Download
-
Bond Yield Calculator 3.0 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... Download
-
Customer Invoice Template 1.0 The Customer Invoicing Template is an Excel invoice template with the ability to store invoices, products and customers and perform advanced invoice sales reporting... Download
-
Project Planning and Management 3.0 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... Download