Stock split for C31

[evankoh]

Hi there,

@chomp

Can I chk for this transaction, should the capitalandinvest (9CI) be “bought” at NAV value of 2.83 instd of the closing price?

The main reason I chose closing price is simply because C31 is “sold” away and we got back some cash + some 9CI and some C38U. So, I thought using the market value of when it happen is better.

But I can also see the rationale of using NAV. However, if you are going to use the NAV to “buy” 9CI, then you should also use the NAV to compute how much you “sold” C31 for.

Note: We are just transferring the P&L around from an accounting point of view since you will gain more from 9CI but gain less from C31.

Cheers,
Evan

[acidgerm]

Is the 0.951 cash taken care of in the automated script?

[evankoh]

@acidgerm

Is the 0.951 cash taken care of in the automated script?

Yes, it basically just perform the following for you automatically.

@evankoh

Hi, I recommend the following which is different from yours.

1. Create a sell transaction for C31 with date (20 Sep) @ price 0.951 + close of 9CI on 20 Sep + 0.154672686 x close of C38U on 20 Sep. [2.95 + 0.951 + 0.154672686 x 2.0 = 4.210345372]
2. Create a buy transaction for 9CI @ price at close on 20 Sep (2.95) with same number of shares as C31.
3. Create a buy transaction for C38U @ price at close (4.21034) on 20 Sep with shares = 0.154672686 x number of C31 shares.

[lollmaorofl911]

Hello Evan, one thing I appreciate a lot about StocksCafe is this kind of dedicated support. And while I understand it’s quite rare to have these kinds of privatization of companies, where there is a cash consideration, and 2 kinds of new shares, I’m just glad there is a quick work around. However can I ask is it possible to implement some kind of prompt when one views their portfolio page to enable the privatization? As currently we have to come to this forum and raise up this specific issue. Hope you are feeling fine after your vaccination as well! (Apologies for the bad paragraph spacing, enter key not working)

[evankoh]

@lollmaorofl911

However can I ask is it possible to implement some kind of prompt when one views their portfolio page to enable the privatization? As currently we have to come to this forum and raise up this specific issue. Hope you are feeling fine after your vaccination as well! (Apologies for the bad paragraph spacing, enter key not working)

Yes, that is definitely in the pipeline. Just wanted to release whatever I have for now for those who wanted to quickly fixed it for C31.

The plan is not to only do it for C31 but also any stock split going forward.

[lollmaorofl911]

Glad to hear that, eagerly awaiting the updates!

[keheriuk]

Hi @evankoh,

Sorry a bit noob here, I have an odd numbers of shares in C31.

Can you help to advise me how to update with 2,130 of C31 shares?

[evankoh]

Hi there,

Simply use this → https://stocks.cafe/events/details?suggestion_id=2

Just click accept and it should auto-populate the trades for you.

Cheers,
Evan

[keheriuk]

Great, thanks!

[financewarrior1]

Thanks, Evan, for automating it! Worked like a charm!

[viinen]

Hey Evan. Is the automation still working? I don’t see any accept button after I click on this link: StocksCafe

I haven’t looked at my portfolio for a long time. Wish to update it.

[evankoh]

Hi Viinen,

For the link to work, you need to have C31 stock before/on 2021 Sep 20. I checked and seems like you do not have any buy transactions for C31.

Cheers,
Evan

[viinen]

Oh sorry it was c61u. I was dreaming

[evankoh]

Ha… In this case, I suggest that you look at this thread → Any feature to cater for upcoming potential CCT and CMT merger? - #26 by evankoh