Subscribe to RSS feed
posted on 30 Jul 2018  -  4,154 views
I am very happy to share that the integration of US fundamental data is complete and StocksCafe now fully supports US stocks.
You should now be able to see profile pages (e.g.
Facebook) for US stocks, be able to screen for US stocks in
screener and see related fundamentals in your
portfolio profile or
This brings the number of supported exchanges to four; namely SG, KL, HK, and US!
Apologies for taking quite a while (US EOD was added last December) to finish the integration of US fundamental data. It is mostly because US data is taken from a different provider than SG, KL and HK, and the way they store data and even what was stored is completely different, which means I had to essentially implement everything from scratch.
Furthermore, the number of active stocks in US is 10x that of SG. This means that tasks that took just three hours to run for SG now takes 30 hours for US. I actually spent the last week optimizing my code so that tasks will not take forever to complete. Now, all tasks take less than a couple of hours to finish! Yay!
With US exchange completed, one of my next two big goals is to integrate Tokyo exchange simply because I am staying in Tokyo, and also because that data is bundled in the package I bought from my data provider. The other goal would be to enable users to include any assets (including bonds, properties, stocks from not yet supported exchanges etc) into StocksCafe as this is one of the top requested features.
Please try out the US fundamental data and let me know if I am missing anything!
- This is awesome! Thank you for all the hard work Evan!
30 Jul 2018 13:43:09
- Nice! Thanks Evan!
30 Jul 2018 13:43:53
- THANKS MAN
30 Jul 2018 13:56:40
- Thanks Evan! Any potential for UK stocks in the future?
30 Jul 2018 13:56:43
- @hozy91, UK stocks would have to wait a bit but will certainly be done sometime and hopefully by end of this year :)
One issue is I am not exactly sure where to get (cheap) fundamental data.
30 Jul 2018 14:19:07
- awesome! thanks!
30 Jul 2018 14:32:52
30 Jul 2018 14:38:01
- I feel that at some point, this is worth raising funds for... Thanks for this! It has really helped my investment journey so far.
30 Jul 2018 16:05:41
- "this is worth raising funds for" => I am already raising funds from Friends of StocksCafe :)
30 Jul 2018 16:18:22
- This is great. Thanks.
31 Jul 2018 01:16:29
- Awesome Evan, very well done !!!!
2 Aug 2018 20:59:57
- nice, waiting for JAPAN market!
2 Aug 2018 21:30:13
Next Article >
< Previous Article
Shares Quantity Now Supports Decimal ...
List All Articles
Other articles by Evankoh
I realized that I did not post any article for the whole of June. It is due to a combination of various reasons but the main reason was that I tried switching to a new caching system (i.e. Redis) for StocksCafe thinking that it is better. However, due to my lack of experience with it, it instead made StocksCafe unstable. Causing out of memory issues, displaying stale data, etc. These resulted in StocksCafe ...
Introducing StocksCafe Forum
I am happy to share that I have created a forum for StocksCafe. This forum will replace the Cafe feature in StocksCafe where users would post questions and start discussions. Why replace the Cafe feature? As the number of features in StocksCafe continue to grow, I am having a hard time maintaining all of them. Therefore, I have decided to "slim down" StocksCafe and maintain as little features myself ...
Growing Dividends - Does Debt-to-equity Ratio and Operating Cashflow Matter? (Part 2)
In the previous article, I looked at how Debt-to-equity and Operating Cashflow (referred to as DER and OC from hereon) would influence Dividend Per Share (DPS). In particular, I looked at see how change of DER and change of OC in year X influences the DPS in year X+1. In this article, I would like to focus on the how absolute DER and absolute OC in year X could be a predictor of DPS in year X+1. Methodology ...