Share Portfolio OptimiserMain Features If you want to see a screenshot of the model outputs then click on the image below Demo - Maximise your portoflio profits and minimise your risks! - Optimises an existing or a potential | |
Download |
Share Portfolio Optimiser Ranking & Summary
Advertisement
- License:
- Free
- Publisher Name:
- Excel Specialists
- Publisher web site:
- http://www.excelspecialists.com
- Operating Systems:
- Windows All
- File Size:
- 174.33K
Share Portfolio Optimiser Tags
- portfolio optimization Portfolio Management portfolio portfolio fundamentals Office Portfolio Manage Portfolio portfolio storer portfolio manager Electronic Portfolio portfolio maker portfolio trading investment portfolio portfolio analyzer monitor portfolio View Portfolio display portfolio portfolio watcher Interactive Portfolio Portfolio Designer Deign Portfolio precious metal portfolio large credit portfolio Rational Portfolio Manager portfolio tool kit portfolio toolkit portfolio optimisation portfolio theory Market Portfolio excel portfolio flash photo portfolio font portfolio free flash player free cell phone data entry practice free google talk flash portfolio portfolio watchlist portfolio analysis www.optimiser.com ashampoo photo optimiser ram optimiser optimal portfolio
Share Portfolio Optimiser Description
Share Portfolio Optimiser - portoflio manager Main Features If you want to see a screenshot of the model outputs then click on the image below Demo - 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 A free demo is also available to download for this product. 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.
Share Portfolio Optimiser Related Software