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 Portfolio Changes: Current Cost vs Closed Cost

By evankoh posted on 10 Jul 2017  -  14,082 views


Wrong Total Cost
Recently, a user highlighted that Total Cost in StocksCafe was computed wrongly and he (I assumed it's a he based on the username) is correct. I previously computed Total Cost as "Sum of [buy price x number of shares] for each stock currently in portfolio". However, this is inaccurate as he has pointed out, and I agree.

Therefore I have changed the definitions of Total Cost and also introduced new terms:
- Current Cost (or Current Positions Cost), and
- Closed Cost (or Closed Positions Cost).

New Definitions
Current Cost = "Sum of [buy price x number of shares] for each stock currently in portfolio"

Closed Cost = "Sum of [buy price x number of shares] for each closed positions"

Total Cost = Current Cost + Closed Cost

Why Does It Matter?
These changes mostly affect the way percentages of various values are computed. For example, previously, "P&L + Dividends + Closed" percentage was computed based on Current Cost (previously Total Cost) and this inflates the percentage. In the extreme case, if you earned one dollar on your closed positions and you have no open positions in your portfolio, your cost would be zero, and your percentage gain would be 1 / 0 = infinite percentage gain.

Therefore, I believe, the correct approach should base "P&L + Dividends" on Current Cost, "Closed" on Closed Cost and "P&L + Dividends + Closed" on Total Cost. You can already see these changes in your portfolio percentages computations.

As always, I'm thankful to all users who are constantly helping StocksCafe become better!

Happy investing!


Like
4 likes
13 comments

yeohaikal - Yes, I'm a 'he'. :p
10 Jul 2017 12:54:30

mark20108 - Hi Evan
I notice I have not been placed under Friends of Stock Cafe anymore.
In fact, I donated $50.00 direct to your POSB A/c a few months back, n had not received an acknowledgment.
TQ n have a nice day.
10 Jul 2017 13:30:45

evankoh - Hi Mark,

My apologies. I do not constantly check my bank account :(

Yes, I just checked. You did donated SGD50 on 30th April.

I have updated that.

Thanks,
Evan
10 Jul 2017 14:20:41

evankoh - @yeohaikal, glad that I got this 50-50 guess correct :)
10 Jul 2017 14:21:18

mithuprem - This is better but not correct. Look at my portfolio (mithuprem) and my wife (mithusur) portfolio. She didn't sell any stocks so her return is 24%, I usually buy and sell a lot. Eventhough I have made double her money my return is 12.5%. So the return is inflated for those who dont sell and depressed for those buy and sell often.
10 Jul 2017 20:15:56

smallfry - Hi Evan,

Your new total cost is still inaccurate as people would reinvest their realised gains into new counters.

For example:
Portfolio of only Stock A,
Total cost $100k, Current Value $500k.
Sell $400k worth of Stock A and buy $400k worth of Stock B.

The net effect of this recycling of cash would increase your new total cost to $420k, when in actual fact there is no net change in total cost from the investor's perspective, less commission and fees.
10 Jul 2017 21:48:30

evankoh - @mithuprem

"She didn't sell any stocks so her return is 24%, I usually buy and sell a lot. Eventhough I have made double her money my return is 12.5%." => What is currently being computed is returns on cost. How much returns are earned/lost based on given cost.
10 Jul 2017 22:14:27

evankoh - @smallfry

I see what you are suggesting. In the portfolio overall, what I am computing are returns on cost. What are the percentage returns obtained on give cost. To consider only the original capital, I believe time-weighted returns and XIRR currently computed in the portfolio report would be closer to what you are suggesting.
10 Jul 2017 22:22:28

mithuprem - Evan understood. But its not comparable. I want something comparable in the shared portfolios so that I can choose the best performing portfolios to view and compare it with my one.If my portfolio is under performing I want to know why is it so..Is it possible to add a column for Time-weighted Returns in the shared portfolio page. Current (P&L +DIV + Cls) % doesn't make sense to me.
10 Jul 2017 23:13:36

evankoh - Yes, I agree on the point that it is not comparable. Will add Time-weighted and/or XIRR to shared portfolio and maybe also portfolio overall.
11 Jul 2017 00:10:37

mithuprem - Evan, That will be great. Appreciate it.
11 Jul 2017 06:56:06

kpo - Hi Evan,

I agree with mithuprem that "the return is inflated for those who dont sell and depressed for those buy and sell often". The previous calculation for "P&L + Dividends + Closed" gave an indication of how much your return is based on the current cost. At one glance, one would be able to tell my total return since I started investing is X% based on my current cost which is much more intuitive.

However, looking at my current return for "P&L + Dividends + Closed", it does not make sense anymore. For the same amount of money invested and the same amount of gain. The returns are different. An example:

Portolio X
$100 on stock A:
- $1 gain on PnL
- $1 dividend

Total Cost = Current Cost ($100)
"P&L + Dividends + Closed" = 2/100 (2%)


Portolio Y
$100 on stock A:
- $1 dividend
- Sell A
- $1 closed/realized
- Buy A

Total Cost = Current Cost ($100) + Closed Cost ($100)
"P&L + Dividends + Closed" = 2/200 (1%)
28 Jul 2017 12:36:34

evankoh - @kpo, replied on the issue you created in the friends section.
28 Jul 2017 13:33:05



Next Article > < Previous Article
Close Price vs Last Traded Price MemCached For A Faster StocksCafe



List All Articles Other articles by evankoh

Introducing the New Wall
As mentioned in the first article of 2017, one of SGXcafe's focus is to improve mobile engagement. So here we are, with our first baby step. I was never a fan of how SGXcafe's home page was as it did not allow users to easily catch up on the latest happenings since their last visit, and the format was not mobile-friendly. Hence we are introducing a Wall that is inspired by Facebook's feed where all ...

Play and Become A Better Investor!
As an investor, we often want to believe that we can pick stocks that can beat the market. So I made a game that allows us to test if we could actually pick stocks that can beat the market. The idea is simple: you will be given facts of an anonymous stock on a historical date. Based on the information, you will choose whether to invest or ignore that stock. Once you have made the decision, SGXcafe ...

Close Price vs Last Traded Price
All along, I have naively displayed "Last Traded Price" and used it for all computations in StocksCafe without much consideration. That is until recently, when a user brought to my attention the difference between "Last Traded Price" and "Close Price". This led me to spend time learning about it and ultimately switch to using "Close Price" in StocksCafe instead. Close Price vs Last Traded Price Most ...