Close for now Do you hold SG, US, HK or MY stocks? How are you tracking them now?
View our Demo portfolio to learn how StocksCafe will do it for you intelligently!
Sign up for free now!

Subscribe to RSS feed Frequently Asked Questions

Updated: 28 Dec 2017 By evankoh posted on 2 Jun 2016  -  27,180 views


I regularly receive questions related to StocksCafe and often the same questions are asked over and over again, hence I think it is time to consolidate them in one place. This article will serve as a placeholder for FAQ and I will update this article as I receive more questions.


While I constantly add new features to StocksCafe, they will be centered around two themes: Helping you manage your portfolio better and assisting you in making better investment decisions. Read here for more information. Here is an article that lists all the features in StocksCafe.


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 cost
2. Buy back the stock (under the new stock code) at the same total cost

Example: You previously brought 10 shares of company A at SGD 2 each, and it does a 1-to-2 stock split. You should:
1. Enter a sell transaction for 10 shares of that stock at SGD 2 each under the old stock code
2. Enter a buy transaction of 20 shares of company A at SGD 1 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.


You can simply enter a buy transaction at price SGD 0 and maybe add a note to yourself for clarity.
Although StocksCafe will give you a warning by visually highlighting the price in red, it is fine to ignore it. It is there just in case you have made a mistake in entering the price.
Also, you should remove the dividend collected from here using the remove link to prevent double counting.


Please ensure that you whitelisted stocks.cafe with your email provider (i.e. Gmail, Yahoo Mail, Hotmail, etc) so that it doesn't accidentally end up in the spam folder. Also, in your email preferences under Market Updates, check that you have selected either Daily or Weekly for Email Frequency.


This is likely because you had previously closed some positions on that stock and the dividends for closed positions are recorded in "Closed Positions" page.


The average price is simply total cost / total shares you own for that particular stock. However, it can be a little confusing if you buy then sell some then buy more. Let me give a short example to illustrate.

a) You buy 1000 share of stock A for total SGD1000 including transaction costs. Here, average price will simply be SGD1.
b) Then you sell the 900 shares of stock A for some amount. The amount is not important since we are talking about average price. Average price here will still be SGD1 and so the total cost for that 100 shares will be SGD100.
c) Finally, you buy 100 shares of stock A for SGD200 including transaction costs. Now, total cost is SGD300 for 200 shares. Hence, average price will be SGD1.5






Find it here: Definitions of metrics


Please visit this blog to search for its previous and current name.


StocksCafe was created originally as a personal project to help me manage my personal portfolio and make better investment decisions.
I decided to share it because it grew to something which I believe many others can benefit from.


It is my intention to freely share knowledge right from the start. And I will do my very best to keep it free, but we all know that nothing is truly free and someone has to bear the costs in one form or another. For now, it is dependent on advertising and donations but mostly my own savings. I am hoping that in the near future, advertising can cover 100% of the operating costs, or I might have to look for alternatives. The bulk of StocksCafe costs come from the licensing fees; please read this article if you'd like to understand more.


Feel free to send me a message. I will be happy to answer your questions.


Happy investing!


Like
10 likes
22 comments

liuktmax - hi how to delete a stock from my portfolio that i sold. thanks
22 Oct 2016 17:22:42

evankoh - Hi,

To delete a stock that you have sold. You can simply add a "Sell" transaction that stated how much and which stock you have sold.

Cheers,
Evan
22 Oct 2016 19:35:36

liuktmax - thanks
25 Oct 2016 19:11:42

hweisze74 - Hi when is the timeframe to buy the shares for entitlement of its dividend? eg 7 days before the payout of its dividend?
20 Mar 2017 14:20:55

evankoh - "when is the timeframe to buy the shares for entitlement of its dividend?" => Never really did any analysis yet on such timeframe but would be interesting to do.
20 Mar 2017 20:24:38

daphneyu83 - @hweisze74 I am not sure whether you meant the ex-dividend date for the shares. The share must be in your CPD or custodian account before ex-dividend date.
21 Apr 2017 11:53:40

evankoh - @hweisze74, opps. Apparently, I misunderstood the question. I read it as when is the optimal time to buy shares for its dividends :(

@daphneyu83, thanks :)
21 Apr 2017 13:20:51

leverage - Hi Evan, I'm having problems with my portfolio summary, website seem to only show random few days of summary instead of daily summary. On my email, some days i receive email with portfolio summary, some days i receive email with no portfolio summary inside. Can let me know if any solutions to this? Thank you!
9 Jun 2017 19:02:15

evankoh - @leverage, will pm you
9 Jun 2017 21:31:17

magicianred - Hi Evan, I love what you do with stocks.cafe. Any chance to include London LSE data? IWDA/VWRD are pretty popular in the hardwarezone forum :)

- Sam
3 Jul 2017 22:43:46

evankoh - Hi Sam,

Yes, in the long run, I would love to include all major exchanges if not all exchanges. However, I expect London to be perhaps another 1 year or so at least.

Cheers,
Evan
3 Jul 2017 23:35:44

alexk60 - Hi Evan,
Many thanks for a very useful product. It really makes it easy for us to monitor our portfolios across multiple brokerages, CDP and SRS from one place.

I have a request for a feature - whether there can be a export function for the transactions that we had entered into the Stocks.Cafe. I want to be able to export these into a spreadsheet for my own records and analysis. Currently, I copy and paste (but this is tiresome as each screen is only 10 transactions).

Another suggestion is that the "remove" function for transactions should have a confirmation button so that we don't accidentally delete the transaction (happened to me using the mobile version). This should be made for all those functions that affect the underlying data.

Once again, let me extend my appreciation for a very useful product.

Alex
25 Jul 2017 19:57:40

sinvestg01 - Hi Evan,

Thanks for providing this foc.. it is an excellent system (i feel it is better than the Google and Yahoo ones).

For the app version, wld it be better if the portfolio detail info is presented in row format, so that less scrolling required if there are many stocks in the portfolio? Just a suggestion.

Really appreciate your effort and sharing.

Cheers! :)
5 Aug 2017 12:11:30

evankoh - Hi,

Thanks! I see.

I will consider and try if it is possible to squeeze several columns of info in one row. Else, multiple rows might make it even more confusing.
5 Aug 2017 18:28:53

8022773 - Hi, may I check how can I add delisted stocks to my portfolio?
Particularly Croesus Retail trust it was delisted and unable to be added.
21 Dec 2017 14:29:50

evankoh - @8022773, you can still add delisted stocks. Just that they are not suggested as you type. Try "SGX:S6NU", it should work.
21 Dec 2017 14:41:16

8022773 - @evankoh I've tried. It seems that it S6NU is no longer on the list as well. Any suggestion?
21 Dec 2017 17:28:05

evankoh - You need to type "SGX:S6NU"
21 Dec 2017 17:34:48

mslee888 - hi, I am interested in the Thai market. Does stockscafe portfolio and watchlist also support this market? I have jus started to explore StocksCafe. Its a great tool. Well done.
28 Dec 2017 11:42:26

ofmistymorning - Hi, when i click the "Report" subtab, it shows that the daily update report of my portfolio performance against STI and other statistics such as time weighted returns have not been updated for year 2018. The last update was 26 Dec 2017.

Is there any way to check the latest statistics?

Thanks
6 Jan 2018 00:11:45

illuma - Hi, will London stock exchange be added soon this year? Looking forward to it.
9 Mar 2018 20:27:08

evankoh - @mslee888, not likely will Thai market be added in the near future.

@ofmistymorning, you still have issue with report?

@illuma, there have been discussions of adding LSE. Within this year would be a possibility.
9 Mar 2018 21:47:30



Next Article > < Previous Article
How My Wife Uses SGXcafe - Dividend ... Portfolio Sharing 2.0



List All Articles Other articles by evankoh

Displaying & Collecting Dividends in Exchange's Default Currency
Many stocks give out dividends and it is what many investors like about investing. Often, dividends are listed in the currency that the stock is traded in. However, there are many exceptions to that, especially for foreign-listed companies. For example, United Overseas Australia Limited is traded in SGD but states its dividends in AUD. In StocksCafe, I wrongly assumed that you would receive the dividends ...

Help Shape SGXcafe's Future
Note: There is a one-question survey at the end of the post, and your input is appreciated. Today, I am writing because SGXcafe has reached a crossroad. You might know that SGXcafe started out as a personal project, but I made it available for public use when I thought it might help other small retail investors like myself invest better. However, SGX recently contacted me and said that SGXcafe needs ...

Introducing The New Stock Screener
Previously, I mostly viewed "What stocks to buy" as a ranking problem. What this means is that I would rank all the stocks available based on some criteria and pick the top few to purchase. Hence, tools that I built tend to generate a score and ranked accordingly. Examples are iAssist, Dividend Strength and Scorer (Scorer was previously known as Screener). However, after taking the eVIMC course and ...