Subscribe to RSS feed
posted on 10 Jul 2017  -  22,247 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).
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!
- Yes, I'm a 'he'. :p
10 Jul 2017 12:54:30
- 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
- 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.
10 Jul 2017 14:20:41
- @yeohaikal, glad that I got this 50-50 guess correct :)
10 Jul 2017 14:21:18
- 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
- Hi Evan,
Your new total cost is still inaccurate as people would reinvest their realised gains into new counters.
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
"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
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
- 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
- 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
- Evan, That will be great. Appreciate it.
11 Jul 2017 06:56:06
- 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:
$100 on stock A:
- $1 gain on PnL
- $1 dividend
Total Cost = Current Cost ($100)
"P&L + Dividends + Closed" = 2/100 (2%)
$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
- @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
Dividends Collected is Back, and Better Than Before
These days, I have been preoccupied with making the switch to using properly licensed data from data I used to crawl from all over the internet. There are still some issues to iron out, but otherwise it is progressing quite well. Due to the switch, I had to take down several features temporarily, and one of the features that went offline was "Dividends Collected". "Dividends Collected" essentially ...
How to use SGXcafe?
When I started investing in Singapore stocks, I could not find any website that allows me to freely and easily access simple information regarding Singapore stocks or maintain my portfolio of Singapore stocks. Therefore, I decided to create SGXcafe to help myself and anyone else who faces the same predicament as me. There are currently two main ways you can use SGXcafe: 1) To gather information I organize ...
Refer & Get Limited Edition StocksCafe T-shirts!
Happy Lunar New Year! As you might know, one of the main objectives of StocksCafe this year is to grow. So as you are sharing/talking about your financial freedom journey with your friends and family during this festive season, it would be great if you could also take this opportunity to share the tool/website that hopefully helped a little in your journey :) Token of Appreciation For every person ...