Subscribe to RSS feed Errors in Portfolio Report

By evankoh posted on 1 Jun 2017  -  40,719 views


If you looked at your portfolio report these past few days, you might have noticed an unreasonable increase (typically well beyond 1000%) in your portfolio time-weighted returns, as well as a sharp increase in ES3's monthly volatility (>20%).

Firstly, I am very thankful to users who took the time and effort to report this issue. Some users even went a step further to take screenshots to ensure that I can easily understand the problem. In fact, several users did so independently. It is very important for users to report irregularities because many a time, I do not even see these errors as everyone uses StocksCafe differently.

Next, I would like to explain why it happened and why it is unlikely that it will be error-free going forward.

For this particular issue, there are actually two reasons:
1) Generating portfolio report is a computationally-expensive task. As the number of users for StocksCafe continue to increase rapidly, I have been tuning it to run as fast as possible, and in the process introduced the bug of wrongly computing portfolio time-weighted returns.
2) With the expansion to Hong Kong and Malaysia markets, there are days when ES3 did not trade, but I still computed the daily return of it, which lead to the sharp jump in volatility (this likely happen to users with stocks outside SGX).

These issues affected about 1% of the users.

In general, the reason why it is unlikely to be error-free going forward is simply because StocksCafe is continuously expanding to new markets and having new features added to it. With limited time resources, it is a tradeoff between the speed of releasing new features vs probability of errors with the new release. Of course, I will perform checks before releasing new updates, but there is still a chance of errors slipping through the cracks.

What I would typically do after discovering an issue (and fixing it) is to write a checking script to at least quickly realize it if the same issue were to happen again in future.

Therefore, please continue to report to me whenever you see irregularities, and let's improve StocksCafe together! Thank you!

Happy investing!


Like
10 likes
0 comments



Next Article > < Previous Article
Open Invitation to Financial Bloggers ... Malaysia Bursa Stocks Now Available!



List All Articles Other articles by evankoh

Renewed Tool: Risk Manager
In this article, I would like to share a renewed tool, Risk Manager. As an investor, understanding your portfolio risks is of paramount importance. Using this tool, you can see the changes to various portfolio risk metrics (i.e. Beta, Value At Risk and Expected Shortfall) after you buy (or sell) a specific amount (defaulted to SGD 5,000 but you can change it here) of selected stocks. Why focus on Risk? ...

My BeatTheMarket Strategy
BeatTheMarket is a mini-game that I built in SGXcafe. 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've decided, SGXcafe will immediately tell you on the next screen if that stock beat the index one year later. If you have not tried it, I encourage you to try it now :) ...

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