Subscribe to RSS feed
posted on 7 Sep 2016  -  3,136 views
Many Stock Screeners (including the one on SGXcafe previously) only allows you to screen for stocks based on the current value of metrics. However, we are sometimes more interested in the trend of the metric than its current value. Hence, I have recently added more than 50 metrics trends to SGXcafe. At the moment, you are able to use them in two main places.
1) In Screener
You can now use
SGXcafe screener to easily scan for stocks that are trending in the desired direction for your favorite metrics.
One question that you might have is how the "trends" are computed. It is essentially fitting a straight line to the data and the trend is the slope, or m, of y = mx + c. I hope you still remember the equation for a straight line from secondary school ;)
For the more mathematically inclined: Data points (i.e. y = metric value and x = number of days since first data point) are first transformed via standardization (i.e. mean 0 and standard deviation 1). Linear regression is then run on those data points (using least-squared estimate), and finally the trend score is simply equal to the slope of the best fitted line.
2) In Stock Profile
Also, for each stock, you can now go to the profile page and see its short and long term trends for various metrics (e.g.
You can will see Up, Down, Flat, and -.
Up would mean that there is an uptrend for that metric in that period.
Down would mean that there is a downtrend for that metric in that period.
Flat would mean that there is no significant trend.
-, it means that there is insufficient data (i.e. min three data points required).
Up would be when the slope is greater than or equal to 0.5, and
Down would be when the slope is lesser than or equal to -0.5.
You might also have observed that the
Down are colored in
red and noticed that
Up is sometimes green, and red at other times. The coloring is based on my personal understanding of what constitutes a good sign. If I think that it is a good sign for that metric to be trending up then it will be colored
Up. Likewise, if I think that it is a bad sign for that metric to be trending up then it will be colored
Of course, you might not agree with me on my definition of good/bad signs for some of the metrics, and I would be happy to hear your feedback.
- thanks! will try it out :)
7 Sep 2016 14:30:25
- Please do!
7 Sep 2016 15:21:52
- thanks for sharing!
8 Sep 2016 18:17:09
11 Sep 2016 23:32:11
Next Article >
< Previous Article
Share Your Portfolio Selectively
Play and Become A Better Investor!
List All Articles
Other articles by evankoh
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 ...
What Can StocksCafe Do For You?
StocksCafe is constantly evolving, and as I continue to add features to StocksCafe, even I am starting to lose count of them. Therefore, I believe that many users - especially new users - might miss out on many features that StocksCafe offers. This article aims to record all the features available in StocksCafe, and this article will be updated as new features are added. I highly recommend for you ...
More Updates: Dividends Override Bug and More Dividends-Related Improvements
Dividends Override was introduced to SGXcafe during the time when one account can hold only one portfolio. Soon after, I introduced the support for Multiple Portfolios in SGXcafe. However, Dividends Override was not updated to support Multiple Portfolios. This mistake potentially caused some mistakes in computing the total dividends you have collected if you happen to hold the same stock in different ...