A few years ago I learned a great and simple trick for calculating real ROI across multiple investments from an different investment forum, and I thought I'd return the favor by sharing it here. All you have to keep track of is your deposit amounts/dates and withdrawals amounts/dates. You can trade inside your accounts all you want, and you don't have to track individual investment, buys/sells, etc. It's basically tracking cash in/cash out from the account, not trades made inside the account.
The first image is how you set it up in excel (it also works in open office). Each row represents a deposit/withdrawal and the date it was made. The last row is today's date, and the current balance of your account, entered as a negative.
This shows the formula.
This is what it looks like calculated.
If you have withdrawals along the way, enter those as a negative, like this.
Again, this is annualized, so if you've been investing a few months, it will extrapolate your returns out for a full year. If you've been investing for a few years, you get an average yearly ROI. It's kind of a "big picture" of how well you are doing overall. I've made all my deposits through coinbase (and not withdrawals yet), so I easily got this info from my account history.
