Portfolio optimization
Download URL | Author URL | Software URL | Buy Now ($26)
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
Related software (5)
DownloaderXL
Trading and stock quotes downloading software for Microsoft Excel. You can download historical end-of-day and real time quotes into spreadsheets. Portfolio, stock options, stock ch ...
Time Watcher
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, par ...
Invoice Template for Excel
The invoice template for Excel is a complete customer invoicing system with ability to store created invoices, products and customer details, manage inventory and perform advanced ...
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 div ...