You can use XIRR formula.of Excel.sheet. First you have to transfer all your trades datewise and buy and sell type with start and end value of portfolio for that particular period.
Its very surprising that you are not calculating your XIRR returns , even though , you are inbesting from so long time. How will you come to.know, whetehr you are better than Index returns or worse? If you are not measuring performance against these paramters like Index returns or Mutual.funds or even Bank FDs, you wont be able.to know whther you are better off invesing in direct equities or going through mutual.funds , active or passive.
Subscribe To Our Free Newsletter |