Share Portfolio Optimiser v.1.0


Main FeaturesIf you want to see a screenshot of the model outputs then click on the image belowDemo- 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 ModelThe 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 DeviationTo run the model, choose the share names in the LInputl 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 LOutputs' sheet.

Main FeaturesIf you want to see a screenshot ...

  • Share Portfolio Optimiser
  • 1.0
  • Excel Specialists
  • Windows All
  • Shareware
  • 299
  • $39.95

Review Share Portfolio Optimiser

  • captcha

Other software of Excel Specialists
  • SnG Poker Strategy Model  v.1- Optimise you strategy for 10 player SnG tables- You can choose up to 15 buy-in levels- You can choose of up to 9 type of players ot create your own profile- Run up to 3,000 games and 1,500 simulations!- Let's you define your won payout structure to ...
    New Project Management software
    • MindView  v.8MindView is a professional mind mapping software that allows you to visually brainstorm, organize and present ideas. With powerful MS Office integration, project management features and collaboration options, MindView has become the industry leader.
    • Smart Calendar Software  v.5.3.0Smart Calendar software helps you to generate event calendar. You can type your events into calendar easily. Events can be highlighted with background or text color. The calendar can be exported into PDF, EXCEL or HTML format.
    • Aiseesoft PDF Converter Ultimate  v.3.3.30Aiseesoft PDF Converter Ultimate can help users convert PDF files to Text, Word, Excel, EPUB, PowerPoint 2007, HTML, and image (TIFF, JPEG, PNG, GIF, BMP, TGA, PPM, JPEG2000) format.
    • LeaderTask  v.14.8.21LeaderTask is a comprehensive software application that you can use to keep track of your schedule by managing tasks. It comes equipped with a calendar and address book, checklists, projects etc. You can also easily organize your teamwork there.
    • Project Manager Software  v.3.6Online Web Based Project Management Software that can also be downloaded to a PC. You can download a project management methodology complete with templates, examples and case studies. This methodology helps you manage projects faster and easier than ...
    • DocGuruZ- PDF - Word - PDF with Image Extraction  v.2.8DocGuruZ Silver Version is a software tool which converts your converts PDF to Word, Word to PDF with all kind of image extraction feature. It preservers the layout, extracts the text as per PDF specifications, extract images and supports the page ...