Free Share Portfolio Optimiser 1.0 Download
Current Page: Home > Business > Business Finance >

Share Portfolio Optimiser 1.0 Download

Share Portfolio Optimiser 1.0

License: Shareware $199.00
Downloads:
Publisher: Excel Specialists
File size: 203KB
OS: Windows XP, 2000, 98, Me, NT, CE
Date added: 2009-10-27
Homepage: http://www.excelspecialists.com/
Category: Business

Share Portfolio Optimiser 1.0 Description

"Maximise your portoflio profits and minimise your risks!"


Edit by : If you want to see a screenshot of the model outputs then click on the image below
- Maximise your portoflio profits and minimise your risks!

- Optimises an existing or a potential new portoflio of shares

- You can choose up to 30 shares from UK or US markets

- Includes most of traded shares in these markets

- Downloads historic data from internet automatically

- Analysis of data over time horizons of up to 2 years

- Performs Monte Carlo simulations to get optimal portofolio.

About the Model

The optimal portfolio theory was developed in the 1950s by Harry Markowitz who won a Nobel Prize for his work. The theory is based on the efficient market hypothesis where the optimal portfolio can be found graphically as a tangent to the risk-free interest rate.

Initially the variances and covariances of all products in the portfolio are calculated. Random weighting scenarios of these products are then generated to find the combination with the highest return for the lowest risk. Risk is a function of the product's Historical Volatility.

To find this optimum point, the maximum SharpE Ratio is calculated, where:

Sharpe Ratio = (Portfolio Return - Risk Free Rate) / Portfolio Standard Deviation

To run the model, choose the share names in the â??Inputâ?? sheet. Up to 30 shares can be chosen from different markets. However, the program will take longer to run is you choose more shares. You also need to choose a time horizon that historic data will based on. The model will then download the necessary data from the internet.

At completion, the optimal portfolio with the weightings of each share are displayed in the â??Outputs' sheet. you can free download Share Portfolio Optimiser 1.0 now.

Share Portfolio Optimiser 1.0 Keywords

optimise, e portfolio

Share Portfolio Optimiser 1.0 Related Software

Share Portfolio Optimiser 1.0 Publisher's Software

    Popular Searches

    Software by Letter

    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Others

    New Release Software