I created this excel sheet to evaluate my performance, can somebody guide me how to find the real annual growth rate (CAGR) of the portfolio. It would have been easier if I invest an amount of X at a period and after 12 months if my investment is Y I could calculate the growth using the formula (Y-X)/X * 100, but I add to my investments every month and the amounts are not equal.
Another unrelated question what is the minimum profit I should expect from each trade to cover my expences and make a decent gain.
Thanks,
Sridhar
