Is this right method to calculate XIRR?
Just example
1.3.18…-5000
5.9.18…-6000
21.6.19…-11500
31.12.19…-25000
4.8.20…-34000
6.12.20…-3000
10.5.21…-5600
11.11.23…-4500
17.11.23…200000
(Here 2 lakh is today’ s value of above all investment)
Is this ok??
A…In first 9 rows, i wrote investments with dates.Investments were mentioned as negative
B…I had hardly sell my stocks, so not mentioned
C…In last row, i wrote my total investment value (as of today )as positive.
And then calculate XIRR return
Kindly guide
Thanks
