VICOM Stock Split

Q&A
1

Hi all,

I was asked how to handle the VICOM stock split that happened today.

Given current StocksCafe features, I would suggest doing this which I believe is the easiest.

  1. Goto this link => https://stocks.cafe/personal/portfolio/transactions/tosplit?label_id=-1

  2. Fill in as follows:
    Symbol (Old): SGX:V01
    Symbol (New): SGX:WJP
    Stock Split Ratio (Old): 1
    Stock Split Ratio (New): 4
    Stock Split Date: Set it to split date (which is 10 June 2020)

  3. What happens is that it will automatically create two transactions for you. A sell transaction to sell SGX:V01 and a buy transaction to purchase SGX:WJP based on this tutorial => https://wiki.stocks.cafe/tutorials/basics/stock-splits/

Cheers,
Evan

6 Likes
2

Thank you. However, when I try it, the system does not pick up V01…as if the code does not exist…

3

Oh… It have to be SGX:V01 instead of V01.

4

Thanks. Had to delete my won transactions of yesterday. It worked

1 Like
5

just to check - the sell price for v01 is at $7.837 and the buy price for WJP is $1.959 ya?

6

Oh wait - the sell and buy price would have been different for each person based on their own value initially right? please ignore the earlier post

7

Yup. You are right :slight_smile:

8

Hi!
I followed your instructions and now my portfolio is showing WJP AP/L% +19,849,706,927,911,400,000,000%.

Wonder if there’s some issue with the calculation…? Perhaps the denominator?
I wished it were real… :slight_smile:

9

Hi,

Yes, there is a possibility of that because we have port over the V01 P&L over to WJP and that is too much profit in just a few days of trading. So, it should normalize in a few days.

That said. I should maybe just show >1000% or so when the % is so high. Let me get to that soon.

Cheers,
Evan

10

hi evan, tried to do this for tesla. is there a reason why the buy transaction defaults to T+1.

i had entered split date as today 31st August, and it creates a sell on 31st Aug and buy on 1st Sep

edit: nevermind, i found an old article where for non-change in ticker symbol, just add the quantity at price 0. thanks!

1 Like
11

Maybe you want to link that article here for the benefit of future readers :slight_smile:

ps: Because I also forgot which one!

12

here!

https://stocks.cafe/post/view/5055/how+should+i+handle+stock+splits

last part: For other exchanges where stock code do not change after stock split, this is what I would do:

  1. Simply buy (or sell if reverse stock split) at price 0.
13

Oh… Actually, now I recommend using this page

Screen Shot 2020-08-31 at 21.20.24
Screen Shot 2020-08-31 at 21.20.242416Ă—1218 174 KB

14

but then it goes back to my initial question:

“i had entered split date as today 31st August, and it creates a sell on 31st Aug and buy on 1st Sep” why does it to a T+1? wouldnt that cause discrepancies since the split is today

15

The reason for doing that is to ensure that the “buy” will not be considered before the “sell” in my system else it would cause some average pricing issues.

Would it cause any discrepancies with a +1 shift?

16

the only discrepancy i can think of would be the buy price may show red, if prices tomorrow are out of range. i might just stick with the additional shares at 0 price for now and see if that works.

17

Sure. Let me know if it does not work.