Business Spreadsheets

I find Portfolio Optimization spreadsheet the best value for money tool for creating Markovitz –efficient portfolios. Everything is packed in an very easy to use spreadsheet. You can use securities prices or its returns as an input. Then you input weighting constraints and the tool calculates correlation matrix together with volatility and expected returns. Of course one can manually change these numbers before running optimisation process. After that you will receive portfolio weightings and efficient frontier chart. You can choose any portfolio weightings (custom set, min. risk, max return etc.) to be presented in a table and marked on a chart. The Spreadsheet offers tool for free data downloading. Additionally the spreadsheet calculates some technical analysis indicators.

Very simple and clear workflow to implement. Easy to track assumptions and risk different cases and scenarios.Thanks & Keep up the good work.

This is a great professional program, it's good to help optimize the portfolio!

Amazing tool

I am a M&A lawyer, and am using your valuation template in connection with a client who needs to price a securities offering for his cannabis grow facility. His CPA has prepared 5 year pro formas, and your template is the perfect utility for determining how to structure the offering. It offers the same functionality of other products at a much lower cost.

A really wonderful piece of excel. So many things have been taken care of , which you are liable to miss out if not being done thru an automated sheet like their spreadsheet. Appreciate their work.

The Portfolio Optimization software is excellent. If I had discovered it earlier, it would have saved me many hours of work!My interest with the subject began after studying finance portfolio theory, and at the time, I began creating own spreadsheet starting with 2 stocks, 3 stocks, then 20 stocks to test the computations and to put theory into practice. My spreadsheet worked, but it was a bit tedious and getting the data, always a difficult and time consuming task.After in depth testing of this software with my standard data sets, the results obtained are accurate and my work can be accomplished in minutes rather than hours!George Chow

Their portfolio optimization spreadsheet allowed me to complete an optimization project with stocks and ETFs to see what the best weighting of stocks would be and how the ETF would change the weights. The program is easy to use and designed well.

Can't Download the file