Friend   Q&A  How should I handle stock splits?

For exchanges where stock code changes after stock split (e.g. SGX), this is what I would do:

  1. Sell the stock (under the old stock code) at the latest close before split
  2. Buy back the stock (under the new stock code) at the same total cost with the latest close (i.e. make sure you do not have gain or loss from this split)

Note: The sell and buy dates must be different because if you sell and buy on same date, StocksCafe always assume buy happens first before sell to prevent short-selling.

Example: You previously brought 10 shares of company A at SGD 2 each, and it does a 1-to-2 stock split and the latest close is SGD3. You should:

  1. Enter a sell transaction for 10 shares of that stock at SGD 3 each under the old stock code
  2. Enter a buy transaction of 20 shares of company A at SGD 1.5 each under the new stock code

I understand that this can be annoying but since I do not have accurate stock split data, it is not possible to automate this.

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.

faq

Like

posted

1564 days ago

viewed

1460 times

active

495 days ago

by

evankoh

Request to Follow

2 Replies

Hi Evan, i had a US stock that underwent reverse split years ago which I didn't enter a reverse split transaction then. But now when i attempt to do so, the old stock symbol can no longer be found.

Any suggestion how i can deal with this particular stock? Old symbol : ipci New symbol : ipcif


posted 495 days ago
by
Facetious2000

Hi Evan,

Sorry need your advice. I own Breadtalk which underwent a 2-for-1 stock split recently and the ticker symbol changed. I only entered the transactions after the event, and it seems to have created an error in the portfolio cos I sold the stock under the new symbol and bought under the new symbol as well, and now "both" stocks are present in my portfolio. What should I do? Thanks for your advice!!

Best wishes,

Harry


1 Comment

Hi Harry, I would suggest to sell under the old symbol and buy under the new symbol. You can simply delete the wrongly entered transactions. Cheers, Evan - evankoh 1537 days ago
posted 1537 days ago
by
harryg

Your Reply


Please login to post


Your Holdings
Dashboard
Portfolio
Options
Other Assets

Tools
Screener
Risk Manager
Other Assets
Watchlist
Alerts
Notes
Wall
Community
Forum
Blogs
Instagram
Facebook
Shared Portfolios
Shared Screeners

Collab
Tiger Brokers x StocksCafe
Saxo Trading x StocksCafe
Kenny REIT Screener

Help
Quickstart Guides
StocksCafe Academy
StocksCafe Youtube Channel

About StocksCafe
Our Story
Send Feedback
Pricing
Market
Singapore
Hong Kong
Tokyo
Kuala Lumpur
United States
London
Shenzhen
Shanghai
Bombay
National (India)
Indexes
Singapore Savings Bonds
CoinGecko
Your Account
Settings
Subscriptions
Referrals
Messages
Profile
IG    FB    YouTube

About · FAQs · StocksCafe © 2022 · Privacy · Terms