XIRR error

Bug Reports
1

Report → XIRR → 2025 is showing as “NA”. Thanks Evan!

2

Ha… I love how you made it so brief yet so clear what is the issue :slight_smile:

I have just update the portfolio report for you that should fix it. Please verify. Thanks!

3

Fixed, you’re the man!

4

This is an issue that sometimes happens while updating the report.

So, updating the report would fix it which you also have access to do so hence do not have to wait for me :slight_smile:

5

XIRR is showing negative which is wrong too.

6

This is similar issue. Something went wrong during the computation (likely due to some data is being updated at the same time - race condition in computing terms)

I just reran the report and it should be fine now.

7

yup. looks alright now. thanks Evan.

1 Like
8

I also have this problem for my portfolio (shows NA). Notice it only happens to my portfolio of SHE:002714 stock.

9

I see. Yours seems to be a different issue. Let me check ah. Will update again. Thanks.

10

I think I know why. There are missing dividends for the stocks. I notice it happens for the stock ticker SHE:2714, SHE:333, she:2415 etc. Mostly China stocks. Not sure if it happens for the other stocks in other stocks exchange. Please check the errors from your stocks information supplier.

11

Same problem with mine… Xirr NA. How to self fix?

12

Thanks for reporting! I found the issue. It is basically due to upstream using “002714” vs “2714”. I have fixed it and made them consistent. Can you try again? Thanks.

13

Yes, you can re-run the portfolio report.

  1. Goto https://stocks.cafe/portfolio/report
  2. Click “Update Report Now”

Cheers,
Evan

14

Thanks a lot! Worked flawlessly, learnt something today.

1 Like
15

Btw, I also fixed this. Also related to “002714” vs “2714” hence it “cannot” find which led to NA.

16

Yes, it fixed for the SHE:002714 stock.

Dividends are missing for the SHE:000333, SHE:002415, dividends show NA on my portfolio->overview page. However, I do see on portfolio->dividends page. Not sure could they be the same problem as SHE:002714 stock.

17

One thing is, I noticed these changes starting from the date about 2-3 Sep 2025.

18

Am seeing somewhat weird XIRR behavior.

Selecting any random two portfolios individually, the XIRR is normal/positive for both.
Selecting the same two at-once, shows the XIRR is negative.
Selecting “ALL” portfolios, shows the XIRR massively negative.

Have done the “Recompute portfolio”, “Clear Dividend Cache”; anything else I missed?

19

Hi there, as it is a new day. Can you try again?

Thanks!

ps: It was simply not updated. Usually it is cached for a day.

20

This is weird. I would need to investigate more then.

  1. I have done a full portfolio report update for you. Can you try again?
    (Usually, we do not do so as it is computationally intensive hence very slow so we cache many things along the way.)

  2. If still does not work, can you give me the the name of the two portfolios so that I can look into it more? Thanks!

Evan