Subscribe to RSS feed
posted on 30 Jul 2018  -  24,745 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
New Feature: Adding Miscellaneous Fees
When StocksCafe was first built, it was built with many assumptions based on my personal (albeit limited) understanding of stock trading. It included the assumption that fees are only incurred as part of a buy or sell transaction. Clearly, that is incorrect. There are many instances when non-transaction fees are incurred such as the monthly management fees incurred by robo advisors (e.g. StashAway). ...
Analyze and Compare Stocks (using SGXcafe)
Analyze Every investor has his/her favorite set of metrics that they look at when performing stock analysis and valuation. Therefore, it is difficult to decide which metric to display in SGXcafe, hence most of the time, I simply choose to display information that I am personally interested in. But I want to make SGXcafe more customizable so that it can provide better value to everyone. Incidentally, ...
Win Free Tickets to BigFatPurse Investor Conference 2016
Each year, BigFatPurse organises a gathering for investors to check on their current year's performance and to get new investing ideas for the upcoming year. It used to be opened only to their members. As more people heard about their gathering, they received more requests to open it up to the public. And this year, they have finally opened it. With a star-studded speaker line up made up of fund managers ...