SCHD Stock Split (Problems with computing Dividends on StocksCafe)

Dear Evan,

Recently, there has been a stock split of 1:3 for SCHD ETF. I came across an article by Stocks Cafe (One Click To Handle Stock Splits - StocksCafe Blog).

Following the recommended steps. I proceeded to add a SELL transaction of my SCHD stocks and added a BUY transaction of my SCHD stocks again (both on the same day of 11 October 2024).

However, after that, I realised that the P&L% and P&L+Div% are the same. This means that StocksCafe did not take into account all the dividends that I have collected so far before the stock split took place.

I also understand from your article that there is this feature called EVENTS. When I went into my EVENTS tab, SCHD was not even listed even though this stock split had been widely known in the investment community months before it took place.

I would like to find out what can be done to remedy the situation.

Thank you.
Lance

Hi Lance,

I have added it. Both the stocksplit and the event to handle it.
(Upstream yet to show the data hence I added manually)

As for this, it is “by design”. Once you perform a sell transaction, the dividends collected before the sell transactions will be shifted into Closed Positions. So, the Current Positions will start afresh.

This make sense for normal sell transactions (that are not due to StockSplit) and I understand can be a little weird in stock split events.

Cheers,
Evan

Dear Evan, thank you for updating me about the rationale.
As I have already added the SELL and BUY transactions surrounding this stock split , is there anyway I can undo these transactions, so that I can go back and use your EVENTS function instead? I am more concerned that my SCHD data includes the dividend information.

Kindly advice me accordingly, please.

Thank you.

Sure. You can simply delete the transactions that you have added. Then accept the event.

Hi Evan,

Huge fan and been using Stockscafe all this time - just wanted to ask if there’s anyway to keep the “Holding Duration” of the stock to be the same as the original date I got it?

IBKR (stock) had a 4 for 1 split, and when accepting the event, it reset the day I obtained it to be the day the split happened. Any chance an update can be added where the transaction stay the day that I obtained the IBKR shares in the first place?

Hi there,

Yes, based on the current implementation, it would reset from the stock split day.

I would have to update my code to account for the stock split instead of resetting it but it can be tricky because holding duration is actually weighted by shares in the sense if you hold 1 shares for first 10 days and then 2 shares for next 10 days, we consider it as (1 x 10 + 2 x 10) / 2 = 15 => It is more like “average holding duration per current shares” instead of as simple as “holding duration since first share”.

Anyway, let me know your thoughts on this of what is “holding duration” to you.

Cheers,
Evan

Hi Evan,

Yep sure that makes sense. Thought that the average holding duration per current shares may not be very relevant in the event of a stock split.

1 Like