Subscribe to RSS feed Cash Balance 3.0 - Add Cash to Portfolio

Updated: 25 May 2021 By evankoh posted on 24 Apr 2020  -  18,222 views


Quick recap

Cash Balance allows you to easily track the amount of cash you currently have by tracking cash movements due to buy/sell transactions and dividends payments.

However, just knowing how much cash we have currently might not be enough for some, and several users have independently requested to let cash be considered as part of the current portfolio so that we can understand how our cash influences our risk, returns, and other metrics.

So last weekend, I spent time implementing it. If you enable it, you will see that a new "stock holding" named CASH in your current portfolio.

Basically, CASH will be included in your current portfolio, and will affect various computations in pages related to current portfolio (e.g. portfolio overview page, portfolio performance page, etc).

However, the portfolio report page will not take cash into account and remain unchanged. This is because for portfolio report to generate the numbers shown in the report, accurate historical information is needed. Simply having the current cash balance alone is insufficient.

To summarize

If you are already using Cash Balance feature and want to add CASH to your current portfolio:
- On this page, check the "Add Cash to Portfolio" box

If you are currently not using Cash Balance feature but want to add CASH to your current portfolio:
- Activate Cash Balance by following this tutorial
- On this page, check the "Add Cash to Portfolio" box

If you don't want to use the new feature (CASH will not be reflected in your current portfolio):
- You do not need to do anything

As always, we welcome suggestions, questions, and bug reports.

Continue to stay safe, in both investments and health!


Like
9 likes
11 comments

CommonSenseInvestor - Wonderful! Thanks!
24 Apr 2020 08:47:30

natcin - thanks evan. great addition. quick ask, considering how many of us hold liquid cash in 'high' interest saving accounts (360, multiplier, one etc), possible to allow manual adding of monthly dividends (interest) into it?

this way the yield on cash can be reflected on overall portfolio as well. as it stands now, portfolio metrics are skewed quite a bit when i enable this new feature.
24 Apr 2020 09:01:11

evankoh - Hmm.. That is an interesting idea.. My first thought is simply to make it possible to perform manual dividend override to CASH. Although CASH is not meant to have history (at least at this point in current portfolio) and having dividends attach to it might be weird.

Wonder if we should account for this on the Other Assets?
24 Apr 2020 10:49:04

natcin - if im not wrong, Other Assets doesn't reflect under main portfolio metrics?
24 Apr 2020 11:07:44

evankoh - "Other Assets doesn't reflect under main portfolio metrics?" => Yup. At least not yet.
24 Apr 2020 11:37:13

takingstock - Started enabling, I think have to do a bit of reconciliation for cash balance, but its working in the way I expect it too.

On natcin's point, so far what I have done is to click on the cash balance / cash transactions to add cash received from interest so that the cash balance in the subportfolio makes sense (only tried to reconcile for my SSB subportfolio which has the least transactions).

Also on natcin's point, I don't consider all cash, only the portion that is "allowed" for investing (versus the reserve and emergency funds), so I pretty much take out the interest from the equation.
24 Apr 2020 12:03:46

evankoh - Spent more time thinking about @natcin suggestion. I think there are a few ways to do this.

1) As @takingstock mention, only include 0% or close to 0% cash. And keep high interest cash in other assets.

2) Allow the adding of dividends to cash in portfolio, and all dividends before today would be considered as interest received for current cash. And dividends stated in future dates would be contribute to projected yields for the CASH. User would have to do regular manual up keeping as today date is constantly changing.

Personally, I think if we implement number 2, we are blurring the line too much between Stock Portfolio and Other Assets. Stock Portfolio is meant for assets where StocksCafe have information on such as end of day pricing, dividends etc and requires minimal manual intervention whereas Other Assets are for assets where StocksCafe do not know much about and therefore requires good amount of manual work from user to keep it current.

Might be better to invest more in improving Other Assets graphing and metrics computation.
24 Apr 2020 13:27:30

natcin - maybe just have some option to show all assets metrics (combining stocks + other assets)?

i guess everyone has very different portfolio allocations and instruments/holdings.

for me, it is quite simple, cash + stocks. would be great if i can see overall avg yield of my combined assets. for e.g. 30k stocks at avg 5% yield, 10k cash at avg 2% interest, my overall is 4.25%. % goes down the more cash i hold, and vice versa, and helps with overall long-term planning and balancing.

personally i am okay with manually adding monthly interest.

again, this is just a 'good to have' function, since we are on this topic. current portfolio functions as is are still good nonetheless! thanks!
24 Apr 2020 14:34:09

evankoh - "maybe just have some option to show all assets metrics (combining stocks + other assets)?" => I agree. Dashboard is meant to be a place to combine stocks and other assets. Definitely, an area of improvements.
24 Apr 2020 14:54:51

xtiant - Hi Evan,

Thanks for this feature. How do I edit the CASH component? Does it automatically calculates the CASH from dividends in different currencies and then convert back to home currency?

TIA
5 May 2020 14:11:50

evankoh - Hi TIA,

You need to first activate the feature -> "Activate Cash Balance by following this tutorial"
5 May 2020 21:09:05



Next Article > < Previous Article
Short-Selling and other changes COVID-19 and StocksCafe Improvements



List All Articles Other articles by evankoh

Open Invitation to Financial Bloggers and Quick Feature Updates
As StocksCafe is currently expanding beyond Singapore to other markets in Asia, I am now looking to feature financial bloggers from around Asia. If you are a financial blogger or if you know of any financial blogger that writes about stocks or financial related topics focusing on Asia, please let me know either via private messaging or by simply commenting on this article. In other updates, I would ...

More Updates: Dividends Override Bug and More Dividends-Related Improvements
Dividends Override was introduced to SGXcafe during the time when one account can hold only one portfolio. Soon after, I introduced the support for Multiple Portfolios in SGXcafe. However, Dividends Override was not updated to support Multiple Portfolios. This mistake potentially caused some mistakes in computing the total dividends you have collected if you happen to hold the same stock in different ...

Screener Updates
It's been more than a month since I shared updates about StocksCafe. Looking back at the tickets completed in May, many of them revolve around the improvement of Screener. 1) New simple preset screeners If you are new to using screeners in StocksCafe, we have added a few simple preset screeners for you to start with. When you are ready to dive deeper, you can also change the conditions to make it your ...