Share Portfolio Optimiser 1.0
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
Share Portfolio Optimiser 1.0 Related Software
- P2P Share Spy
Scan the internet for computers with shared files! - Memeo Share
Memeo Share is a FREE application allowing you to easily share digital photos. - Swift Share
Manage Share Points for AFS and Samba on Mac OS X - Personal Portfolio Manager
Top rated portfolio management and analysis software for individual investors. - Share Portfolio Optimiser
Maximise your portoflio profits and minimise your risks!
Share Portfolio Optimiser 1.0 Publisher's Software
Popular Searches
Hot Downloads Software
New Release Software