Subscribe to RSS feed Cash Balance 2.0

By evankoh posted on 7 Feb 2020  -  20,172 views

Quick Summary
1) Activate the Cash Balance feature if you want to track your portfolio's cash portion and/or see your portfolio's detailed cash transactions.
2) Whenever you realize that your DIVIDEND transactions are out of sync, simply click "Sync Cash Balance Dividend" on this page. Or simply check "Auto Cash Balance Dividend Sync" in step 1 and the chance of DIVIDEND transactions going out of sync should very low.

The Cash Balance feature first appeared in 2016. However, less than 10% of the users in StocksCafe have activated this feature. One reason might be because it is not that clear what it is used for and can be confusing to use. Based on the feedback/questions that I have been receiving about it, I have made some tweaks to this feature and would like to use this article to explain how to use it.

What is Cash Balance for?
1) The original intent of Cash Balance is to track the amount of cash you currently have in your trading accounts. This assumes that when you create multiple portfolios in StocksCafe, each portfolio would correspond to a single trading account (per currency).

2) It is also widely used by users to keep a historical record of all cash transactions.

How does it work?
There are various transaction types, namely: DEPOSIT, WITHDRAWAL, FEES and DIVIDEND. The first three types are pretty straightforward and rarely cause any confusion. Do read the quick guide in this article to learn how to use.

DIVIDEND transaction type is the one where users regularly have questions. Let me explain how it works.

a) Everyday, at midnight Singapore time, StocksCafe (or rather a cron job) will check if you have any dividends with a Pay Date that falls on that day. If yes, the DIVIDEND transaction will be added.

b) So, it can potentially go out of sync if the cron job fails for whatever reason or if the PayDate was wrong or if dividend was duplicated or should not be there.

What is "Sync Cash Balance Dividend" on this page?
This action will essentially re-populate/sync (i.e. delete all and add again) dividend transactions in Cash Balance based on your transactions history.

What is "Auto Cash Balance Dividend Sync" on this page?
If you check the box for "Auto Cash Balance Dividend Sync", it means that whenever you add/remove/update your portfolio transaction, the "Sync Cash Balance Dividend" will automatically run in the background to ensure that the DIVIDEND transactions are still correct after the edit.

Hopefully, this feature will now be easier to use. Do continue to give me feedback on how to make it even better.

Happy investing!


anzo321 - Hi Evan, would it be possible include a only certain period (eg: Jan 2020 to May 2020) when we click on "Sync Cash Balance Dividend" and not the entire transaction history in order to better track the movement of dividend going back into the cash balance.

This will allow a better live update of the amount currently within your "Cash Balance".
9 May 2020 11:05:17

xadiq - I second the previous comment by @anzo321.

I have removed some dividend payouts from my cash transactions because they were non-cash transactions. Could the sync cash balance be used to only sync transactions which were not already manually removed?
17 May 2020 15:11:30

evankoh - @anzo321 I see. Can you create a ticket for this?

@xadiq I am more reluctant to do this because it is more complex as I would at least need to 1) Remember the deleted cash transactions 2) Create UI for users to see and manage all the deleted cash transactions in case they change their mind.
I suppose doing what @anzo321 can mitigate your issue right?
19 May 2020 04:22:53

anzo321 - Hi Evan, noted will proceed to create a ticket on this and input this page as the link.
20 May 2020 10:00:59

xadiq - @evankoh - actually yes, I think that could work too. Thank you !
29 May 2020 11:52:22

SmrtInv20 - Hi, why is it my cash balance still in red even though I have input "deposit" money into my account?
23 Dec 2020 17:07:31

Next Article > < Previous Article
New Exchange Added: Support for ... Download the improved StocksCafe ...

List All Articles Other articles by evankoh

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 ...

US Market Information Updates
I have not worked much on the US market beyond adding EOD data and other basic features, and I’m happy to announce that I finally had some time to improve as well as add a few new features to it. 1) Similar Stocks - You can now see other stocks that are similar to the one you are viewing (e.g. Google) on the right hand side (in desktop view). 2) Shared Portfolio Statistics - You are now able to see ...

StocksCafe in 2018
Happy New Year! Review of 2017 2017 has been an exciting year for StocksCafe. It started with the change of name to StocksCafe, which included the migration of domains as well as architecture change. I remember it caused many issues in the beginning and I truly appreciate your patience during those times. The main reason for all those changes was to prepare for expansion beyond Singapore. And now, ...