Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Using this formula, you don't need to track your wins just the starting capital, withdrawals and final capital? Interesting formula thanks for sharing.
Yes, if you are only interested in returns. I also track percentage drawdown, which gets a little tricky when you have cash inflows and out flows. Then, % annual return divided by % max drawdown can also be calculated, which is an important metric (over a 3 year period, it is called the CALMAR ratio).
I earned ~25% in my diversified portfolio of index funds. (Boring, I know.)
I'm still back-testing and paper-trading my machine learning algorithms, but they are consistently beating the market on an unlevered basis. I'd love to tell you what the returns were, but that is highly reliant on overlying strategy and ability to execute in the face of psychological bias.
I believe Excel's XIRR function might be an even better fit as it works for irregular cash flows. You don't need an equal number of periods in a year, transactions don't need to be on the same day, and, of course, they can be + or - in any amount.
The resulting table using XIRR is condensed compared to IRR because the zero value lines for periodic payments are not necessary. Not a big deal, I know, but if you're looking at account performance over 10 years and all you ever do is make an annual IRA contribution, it's nice to have a compact table.
