How to Calculate the Growth Optimal Portfolio Weights in Excel?

This is probably the most important post you will read about investing

I previously wrote about Kelly Criterion and how it can help you to decide how much of your bankroll to bet on a single bet to maximize your winnings over a period of time. This works very well for situations where you are making one bet at a time.

But what do you do if you have a portfolio of bets?