Subscribe to RSS feed Screener Updates

By evankoh posted on 7 Jun 2021  -  1,632 views


It's been more than a month since I shared updates about StocksCafe. Looking back at the tickets completed in May, many of them revolve around the improvement of Screener.

1) New simple preset screeners

If you are new to using screeners in StocksCafe, we have added a few simple preset screeners for you to start with. When you are ready to dive deeper, you can also change the conditions to make it your own!

2) Screener is now fully using Morningstar data

The previous data provider, Xignite, only provided 5 years of fundamental data history, whereas Morningstar provides the complete history that they have. As such, we now can have conditions in screeners that look back more than 5 years.

3) Redesign Screener's backend architecture

If you used Screener in the last few days, you would have realized that it does not run immediately, but is instead submitted to a queue. Although this means that you might need to wait a bit longer before you can get the results, it also means that Screener is now more flexible and results are being stored (so that you can easily view it later).

Let me explain a bit more on why Screener now takes longer to run. Previously, Screener runs faster because StocksCafe precomputes and stores all the data points daily, which in itself takes many hours of processing power. With the increasing number of exchanges and metrics, this is becoming unmanageable and often wasteful since most data points are not used.

Now, Screener is computed on demand, which is slower but more flexible. This architecture is more flexible because we can now run the Screener with any date in the past (in the pipeline to implement) and view the results. This means that StocksCafe could potentially support backtesting of screeners in the future.

This new approach also means that we can support more exchanges and/or metrics in Screener without adding more CPU and memory cost. So if there is a metric that you have been hoping for Screener to have, now is the time to voice it :)

Although this new approach is implicitly slower, I am working on various optimizations to speed it up as much as possible.

As always, feel free to make feature requests or bug reports if you find any.

Happy investing!


Like
11 likes
5 comments

MickeyJ - May I know how do I get past the first page of screening results?
8 Jun 2021 11:14:19

evankoh - There is no second page. All top 300 results are displayed. (All you need is just scroll down)
10 Jun 2021 07:36:40

MickeyJ - Thank you.
11 Jun 2021 09:55:49

davionwong - Screener seems to be down. I am unable to create new Screeners.
15 Jun 2021 10:40:43

alfredtn99 - the preset screeners seem to be down
22 Jun 2021 17:14:55



< Previous Article
Conclusion of StocksCafe's First ...



List All Articles Other articles by evankoh

Hong Kong Stock Exchange Information Now Available!
After many hours of coding, I am happy to share that Phase 1 (of 3) of the expansion to Hong Kong is now complete! Information about Hong Kong stocks is now available in SGXcafe (e.g. CK Hutchison). At the moment, it hasn't been incorporated into the search yet, but you can find the full list of active stocks in Hong Kong Stock Exchange here. In Phase 2, I will focus on features revolving around adding ...

Better handling of FX in StocksCafe - FX 2.0
Note: If you are investing only in stocks that are denominated in your base currency (e.g. SGD), you can skip this article. The old way of handling FX Previously, StocksCafe handled portfolio with multiple currencies very simplistically. It would directly convert any non-base currency using the latest FX rate when needed (except for dividends where the FX rate used is the one on ex-date). While this ...

Referral Program for StocksCafe
Update: Please check this article! In short, referral program is now extended to lifetime (instead of just one year) Although StocksCafe basically takes up most of my weekday nights and weekends, it is becoming more enjoyable to work on mainly because there is a growing number of users who love StocksCafe. Beyond raising feature requests and bug reports, many users even share the worry of how to make ...