You are not taking into account entry and exit of stocks. Just start capital and end capital.
XIRR is date wise and amount wise returns ,
In market , there are some ways to calculate XIRR, but most of them are suspicious or wrong.
- Mprofit, it gives readymade XIRR , but below 50 lakhs capital , but we cant be sure, what exactly they are doing and whether its correct or wrong.
- Valueresearch, same as Mprofit.
- zerodha providing individual stocks xirr, and using that we could use weighted average of all stocks to arrive portfolio xirr, but there is a big flaw, they are providing xirr from 2017 onwards and once you sell a stock and if after some time again by that same stock, then their xirr is not as per latest entry, but from first time of purchase, so it gives distorted xirr.
- @sahil_vi had provided one method assuming a string and variable and then using xirr function of excel, but zerodha provides only 1 year trade data, so only that specific year xirr can be calculated but not for total invested period.
| Subscribe To Our Free Newsletter |
