Discrepant issue creeps in when a stock is transferred in from another broker. Unless the right trades for it are entered, everything else will break. But if the issue is something else, can you create a support ticket and message @TheGouda and me?
For equity/Debt tags, we rely on a data vendor for it. Historically their data hasn’t been consistent, but we have manually fixed it. Can you give some examples where it is not correct? We will check on this.
How will the NAV curve work?
- A starting day NAV of, say, 100 and AUM = account value of that day (sum of free cash, holdings value, margins ).
- End of the day, % AUM change will cause the NAV to go up or down by the same %. Similar to how it happens in a mutual fund.
- Any Payin, new money gets in on the last day’s NAV. Any payout money goes out at the end of the day’s NAV. Similar to MF.
If you plot this NAV curve, it will be the equity curve of the account. So you can easily calculate CAGR, XIRR, or % return between any two points.
As you can imagine, this is quite a complex project; it is almost like running fund accounting for every customer account. AMCs pay money to RTAs to do this daily NAV calculation & fund accounting for every MF scheme.