ESG ETF dividend is incorrect

Q&A
1

Hi Evan,

The SGX:ESG Lion-OCBC Securities Singapore Low Carbon ETF dividend in stockscafe is incorrect.

https://stockanalysis.com/quote/sgx/ESG/dividend/

2

Hi there,

I took a look. It seems fine to me based on SGX → https://www.sgx.com/securities/corporate-actions?value=LION-OCBC%20SEC%20SG%20LOW%20CARBON

Please let me know which exdate you believe is wrong.

Btw, sorry for the slow reply. I was traveling hence piled up a lot of work.

Thanks,
Evan

3

Hi Evan, Thanks. that problem has been fixed. But i spotted another one.

The dividends for starhub seems to be wrong. At least 2017 dividends seem to be doubled in stockscafe.
https://stocks.cafe/personal/portfolio/xcollected?filter=SGX:CC3&label_id=0

https://www.dividends.sg/view/cc3

4

Hi there,

I see.

  1. 2017 is doubled because you overridden it → https://stocks.cafe/portfolio/override?label_ids=0&filter=SGX%3ACC3

  2. You can either delete the overrides that you added. Or if you prefer to keep that, you would have to delete the original dividends by StocksCafe.

Thanks,
Evan

5

actually i didnt manually override any dividend transactions. im not sure how they got there.

6

I see. In that case, maybe go to this page and delete them and it should work →

7

Hi Evan,

In this page, the dividends for 2020 shows S$6,137.53. (based on ExDate)
https://stocks.cafe/portfolio/collected

However, the reports page, the dividends for 2020 shows S$7100 (based on ExDate)
https://stocks.cafe/portfolio/report?label_ids=0&use_exdate=1

Surely this is bug?

8

Hi there,

Yes, the numbers does not tally. They should at most differ very slightly due to rounding issues. Let me investigate.

Thanks,
Evan

9

Thanks Evan

1 Like
10

Hi there,

Thank you for waiting. Spent some time today working on it. It should tally now.

Cheers,
Evan

11

Seems to be working days ago. Thanks Evan.

12

Is it? Weird. The last I checked. Even though 2020 tally, the rest still had rounding issues.

Anyway, good that it is fine for you now :slight_smile:

13

Hi Evan,

https://stocks.cafe/portfolio/report?label_ids=0&portfolio_graph=0

The TWR graph here looks a weird with the straight line spikes in the last 5-6 years.

14

Hi there,

Other spikes is resolved by recomputing report.

Still got two left and they are due to this → https://stocks.cafe/portfolio/transactions?label_ids=0&filter=USX%3AGOOGL

The price is “wrong”. At that time, GOOGL price is about USD 2800+ but you listed it at USD 140.

The better way will be to list it at that actual price and shares you got at that time. Then use stock split events to adjust.

Cheers,
Evan

15

Ic. i tried accepting the stock split but got the message that says “You do not have this stock (USX:GOOGL) in your portfolio now.” What would be the best way to fix this issue? Or can i multiply the price by 20X and reducing the shares by 20X to resolve this?

16

Sorry for the late reply. Somehow this slipped my mind.

I just took a look. It seems like you have managed to do it properly now?

17

Ya. but the chart still looks wrong. You can see that after using the stock split, the stock split transactions are highlighted in red.

18

Highlighting in red is fine. It is just saying that the price is outside the high and low range of that day. Since it is a stock split handling, this is expected.