Subscribe to RSS feed
posted on 30 Jul 2018  -  7,843 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
Regularly Export Your StocksCafe Data
Users input various information into StocksCafe such as what stocks they bought and when, and many would also record notes either about the transactions or stocks itself. All these are very precious data to users and often, users would like to keep a backup copy. Up until now, they can only be manually exported. I am happy to share that I have now set it up such that you can get a copy automatically ...
Improved Screener and Other Updates
Screener has always been one tool in SGXcafe that I enjoy using. With it, I can easily rank the hundreds of stocks listed in SGX based on whatever metrics I want. Which is also the reason why I decided to spend some time this weekend enhancing it. Firstly, I added a few more metrics to it. Namely: - Dividend Strength - NAV / Price - Cash / Price - Cashflow / Price There have been requests to rank only ...
A Simple Trend Analysis of Dividends
One factor that affects whether I purchase a stock or not is how much dividends it gave out last year, and for how many years it has been doing so. This is because when I purchase stocks, I am hoping mainly to benefit from dividend gains rather than capital gains. One obvious question would be: how much can we rely on the dividends that was paid out in the past to predict future dividends? One might ...