Subscribe to RSS feed
posted on 10 Jul 2017  -  18,095 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
StocksCafe API and Customizable Tax Rates
StocksCafe API As StocksCafe continues to grow in term of the number of features and complexity, it is time to shift from Monolithic Architecture to Microservices Architecture in order to maintain flexibility and scalability among other advantages. In laymen terms, this simply means that instead of StocksCafe being one giant chunk of software, it is now broken down into many smaller manageable pieces. ...
StocksCafe Mobile App
Short Story Mobile app for StocksCafe is now available again! Here is the Android link and this is the iOS link. This is an early version and hence lacking many features. Of course, I will continue to add more features to it over time and the final goal is to make it as comprehensive as the desktop web version where possible. If you prefer to install the pseudo mobile app which has more features supported ...
Becoming an Angel Investor
Last week, when I shared my portfolio in another article. I received comments privately from several people such as "50 stocks in your portfolio?!?! I think 30 should provide more than enough diversification", "Have you heard of Warren Buffet's 20 slot rules?", "Why are you holding so many different stocks?" etc. Well, there are a few reasons to this. 1) I have yet to devise or find a sound approach ...