Portfollio Builder Excel

Home » Blog » Tools » Portfollio Builder Excel

We have a new updated Excel version of our Portfolio Builder. All Strategy subscribers can download a copy from their ‘Consolidated Signals” page: https://logical-invest.com/blog/strategy-signals-consolidated/

The tool is provided ‘as-is’. Feel free to customize as you see fit. The sheet will download the latest return data of our strategies from our server and provide basic equity visualization, strategy-level statistics as well as a visual chart of the risk vs return topology of each strategy.

You can create your own portfolios by manually allocating across strategies or by running an optimization, targeting different types of portfolios like a minimum volatility portfolio or a max Sharpe with volatility constraints.

The tool needs the free Solver Add-In that is provided with most versions of Excel. You will need to load the Solver manually in order for the optimization to work correctly. 







The Logical Invest Team

2017-10-02T20:00:00+00:00By |0 Comments

About the Author:

Vangelis has been involved in quantitative research and development since 2007. He blogs under the 'Sanz Prophet' alias. He has built, run and tested literally thousands of trading systems using Matlab, Python, C#, QuantShare and Amibroker and has contributed as a researcher/programmer in academic papers. His quantitative blog has been part of the “Whole Street” quant blog aggregator since inception. He holds a B.A. in Economics & Theater Arts from Cornell University and an M.F.A. in Motion Picture Producing from the Peter Stark Program at the University of Southern California. Before entering the financial world Vangelis worked as a film and commercial director and collaborated with agencies such as Bold Oglivy, Adel Saatchi and Saatchi and clients including Pepsico, P. & G., Hyundai and others.

Leave A Comment