Calculation of Returns and differences between them

[Neeraj_Mandloi]

I have a set of transactions for Reliance stock, as shown in the table below:

I have analyzed these transactions using three different methods, and I obtained different XIRR (Internal Rate of Return) values.

In Image 1, which is a Google Sheet, I calculated the XIRR to be 12.31% when considering the remaining position and 1.55% when considering the squared-off position.

In Image 2, which is from a portfolio performance software, the XIRR is reported as 2.17%.

In Image 3, which is from a broker terminal, the XIRR is reported as -2.4%.

My main query is why the XIRR values differ across these three methods, even though they use the same set of transactions. I would like to understand how to add these transactions correctly to the portfolio performance software in order to achieve a XIRR value that matches the one from the broker terminal.

I would greatly appreciate your assistance in identifying any mistakes I may have made and guiding me through the correct process. Thank you!

[Rafa]

You are at the wrong analysis as the given trade view is restricted to the 50 pcs which you’ve sold.

[Neeraj_Mandloi]

see the table and calculate xirr … all three cases gives different xirr results…!!

[Rafa]

As I’ve said, your calculations are not synchronise with the screenshot you’re referring to.

The PP image shows the trade analysis for 50 pcs. In fact, the 2.17% based on the following values:

Date	Amount	Shares
24/11/2009	37992,42	18 pc
05/12/2009	0,00018	18 pc
08/09/2015	10063	12 pc
21/09/2017	0,00002	2 pc
21/04/2020	60278,85	-50

The others are not considered as they not relevant for this trade.

[Neeraj_Mandloi]

For your kind info 1st image is a table.

the three image I am referring to is the three images written on then (after table image in order)

I am talking about closed position. in broker terminal (image 3 last image) and PP image xirr values are different why?

you got my point.?