Main Menu
Home
Top Downloads
New Programs
Awards
Link To Us
Submit Programs
Bookmark
Contact Us

Programs Categories
    Accounting
    Applications
    Business Finance
    CAD
    Document Tools
    E-commerce
    Office Suites
    Others
    Personal Finance
    Personal Info Managers
    Project Management
    Spreadsheets
    Word Processing
 

See Antivirus Report

Portfolio Optimization 5.0

   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.




Download link:
Size: 544KB
License: Shareware
Price: 26.00
Category: Business & Finance / Spreadsheets
Operating System: Win98, WinOther, Win2000, WinXP, Win7 x32, Win7 x64, Windows 8, WinVista, WinVista x64, Mac Other, Mac OS X
Developer: Excel Business Tools
  • Buy Now
Buy this soft

  
Top Spreadsheets / Business & Finance programs
  • Excel Unique & Duplicate Data Remover  1)   Excel Unique & Duplicate Data Remover 1.1
    Search and delete duplicate and unique entries, values, cells, records, rows, numbers in any list or selection with this Excel Addin. Finding and removing duplicates and uniques will save you hours of tedious work.

  • Excel VBA Models Combo Set  2)   Excel VBA Models Combo Set XL-VBA4 1.0
    The Excel VBA Models Open Source Code Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code. Programs include Distribution 12 Random Number Generator, 6 Option Pricing Models & more..

  • Merge Workbooks  3)   Merge Workbooks 2.0
    Merge Workbooks is an Excel macro that will combine several Excel workbooks into one workbook. The user selects the workbooks to merge and the macro copies all the worksheets in those workbooks into a new workbook.

  • Excel VBA Models Set 3  4)   Excel VBA Models Set 3 XL-VBA3.0
    Excel VBA Models Open Source Code Learning Tool - Numerical Methods and Option Pricing Set Contains topics in applying different numerical searching methods to solve mathematical equations and implied volatility from option pricing models.

  • Excel VBA Models Set 1  5)   Excel VBA Models Set 1 XL-VBA1.0
    Excel VBA Models with Open Source Code - Option Greeks, Lotto Number, Probability, Normal Distribution, Monte Carlo simulation, Black-Scholes, Binomial Option Pricing, Portfolio Optimization, Multiple Regression, Bootstrap, Multivariate distribution

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

  • DoneEx XCell Compiler  8)   DoneEx XCell Compiler 1.9.11
    Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Main features:copy protection with regkey; create trial/demo of workbook; and much more...

  • Hide Worksheets  9)   Hide Worksheets 2.0
    Hide Worksheets is a must have excel add-on tool to quickly and easily hide or unhide worksheets. With Hide Worksheets it takes a matter of seconds to hide or unhide several or even all the worksheets in a workbook.

  • Excel to MySQL Import, Export & Convert  10)   Excel to MySQL Import, Export & Convert 1.2
    Connect Excel to your MySQL database. This Excel Add-in allows you to import and export tables to (and from) MySQL while you work in Excel. No SQL query knowledge needed.


New Spreadsheets / Business & Finance programs
  • Excel to MySQL Converter Software  1)   Excel to MySQL Converter Software 4.0.1.6
    MS Excel to MySQL database conversion tool is complete solution for DBA, programmers or beginners to quickly migrate MS Excel worksheet to My SQL database records accurately in a few mouse clicks without wasting time in lengthy scripting or coding.

  • DoneEx XCell Compiler  4)   DoneEx XCell Compiler 1.9.11
    Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Main features:copy protection with regkey; create trial/demo of workbook; and much more...

  • Envelope Printer  5)   Envelope Printer 1.13.49
    Envelope Printer is the quick and easy way to print addresses on envelopes. Type in the address, then press the print button. It's that easy and that fast! You can also save addresses for easy loading for future use.

  • MITCalc - Tolerances  6)   MITCalc - Tolerances 1.16
    Calculation includes tables and calculations for easy option of fits of machine parts and determination of their dimensional tolerances and deviations. Application is developed in MS Excel, is multi-language and supports Imperial and Metric units.

  • Bluetooth Advertising software  7)   Bluetooth Advertising software 2.1.2.4
    Bluetooth Advertising Software is a bluetooth advertising marketing software application that allows businesses to deliver advertising files direct to consumers' cell phones and mobile devices via bluetooth.

  • MITCalc - Welded connections  8)   MITCalc - Welded connections 1.11
    The calculation is intended for the geometrical design and strength control of statically loaded welded connections. Application supports Imperial and Metric units, is based on ANSI, ISO, DIN standards and support many 2D and 3D CAD systems

  • Excel Worksheet Separator  9)   Excel Worksheet Separator 1.5.0.1
    A professional tool can help you to separate multiple excel workbook files in the easiest and fastest way.You can use the check box to mark the workbookand worksheet which you need.then separate what you selected.

  • Rapid PDF Count  10)   Rapid PDF Count 2.05
    Rapid PDF Count will show you how many pages are in many PDF's and generate reports for you with a few mouse clicks.


 


 


2006 - 2013 ProgramsBase.com - Privacy Policy