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 Errors in Portfolio Report

By evankoh posted on 1 Jun 2017  -  18,442 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

StocksCafe Now Supports Any Asset!
Regularly, I would receive requests asking, "When will StocksCafe include XXX?". They are typically other exchanges like London Stock Exchange or Australia Stock Exchange. Occasionally, it would be about commodities or other assets such as insurance, mutual funds, etc. Ideally, StocksCafe would be able to include at least all major exchanges, commodities, and funds in the future. However, I am not ...

Downtime Notice - Migrating Away from DigitalOcean This Weekend!
This is to inform you that it is likely that there will be a period of downtime for StocksCafe this weekend. It might become inaccessible as I proceed to migrate away from my current hosting provider, DigitalOcean. Thank you for your understanding. Note: You can stop reading here if you have no intention of using hosting services. The following is written because DigitalOcean has pissed me off yet ...

Quick Updates: Improved Screener
Over the last few days, I spent time making several improvements and bug fixes to StocksCafe Screener. Two improvements to bring to attention: 1) Display Metrics: You can now display any metric you want in the results without having to use them in your screener. This can be useful for exploration when you do not yet know the correct value to set for that particular metric in your screener. 2) Customizable ...