Sunday 29 November 2015

The median PE Ratio by Market Capitalization for 4888 US-listed stocks.


As many of you know here at Quantr.co we provide daily stock market data directly to your speadsheet for thousands of stocks listed in the United States, and every now and then we like to use this data to give our readers a little snapshot of the market.

Today we're looking at price to earning ratios and how they vary throughout the market as a whole depending on the size of the company. For this study we analyzed 4888 stocks and found the median value for each specific market capitalisation range.

The result for median PE ratios by Market Capitalisation as of market close on Friday November 27 2015 is as follows:


Median PE Ratio (ttm) courtesy of Quantr.co
























Next the result for median Forward PE ratios by Market Capitalisation in the US is below:

Median Forward PE Ratios courtesy of Quantr.co











As for the market as a whole. After analyzing all 4888 stocks we came up with a:


Median US market price to earnings ratio of 19.78 
and a 
Median US market forward PE of 16.08

Wednesday 25 November 2015

Results - Investment strategies investigated - Part i - Relative Strength Index

As many of you will know we started an experiment last month on the use of the Relative Strength Index to buy undervalued stocks.

The theory goes that an RSI approaching 30 (or below) is oversold, and the stock may now start an uptrend, and an RSI approaching 70 (or above) is overbought, potentially causing the asset to start a downtrend.

As of October 25 2014 there were 703 stocks that are approaching an RSI of 30. For the purpose of this experiment we are going to class 'approaching an RSI of 30' as any stock below an RSI of 40 on 14 day basis.

For this investigation we looked at the what if scenario for portfolio performance if buying all stocks approaching an RSI of 30, all stocks below an RSI of 30, as well as a specially selected group of stocks approaching an RSI of 30 that satisfy a few fundamental factors. We also sneaked in a fourth group of 20 stocks that were selected at complete random to test the validity of the results more so.

The special group of stocks, shown in the image below, were picked as they satisfied certain criterion necessary to be included in this particular portfolio.

  • Return on Equity > 20% 
  • Debt to Equity < 80% 
  • PEGY Ratio < 2 
  • Relative Strength Index < 40














Well, the results are in and they are somewhat interesting. For the record, we plan to repeat this experiment a few times to account for different market conditions and to test reliability, as we all know by now that past results do not guarantee future results.

The results:















So, as you can see disappointingly the random selection ended up the victor, outperforming all selections and the market during these 20 trading days. But that's not the whole story. There seems be a case here for a reduction in the holding period for each of the groups of stocks. 9 days turned out to be the optimal holding period during this experiment.


RSI Special RSI < 30 RSI < 40 Random Market
Day 9 6.07% 1.95% 3.86% 3.22% 1.19%

As you can see above, as of Day 9 every single group of stocks outperformed the market, and by a reasonable margin. The decline that follows shortly after could show that potential RSI gains are ephemeral in nature and do not necessarily end up in overbought territory (RSI >70) before they decline once again. We should note that we were especially pleased with performance of the specially selected group of stocks at Day 9. Picking a group of downbeat, but reasonably sound, stocks rather than a blanket selection of all stocks approaching an RSI of 30 seems logical and appears valid.

We'll let you know how things go the next time we test this strategy. Feel free to try the strategy yourself and let us know how you get on.

- J


Saturday 21 November 2015

Central Bank Interest Rates as of Nov 21 2015


Central Bank Rate Country Rate Previous Change Date
 Australian RBA Australia 2.000 % 2.250 % 5/05/2015
 Banco Central Chile 3.000 % 3.250 % 10-16-2014
 Bank of Korea South Korea 1.500 % 1.750 % 6/11/2015
 Brazilian BACEN Brazil 14.250 % 13.750 % 07-30-2015
 British BoE Great Britain 0.500 % 1.000 % 3/05/2009
 Canadian BOC Canada 0.500 % 0.750 % 07-15-2015
 Chinese PBC China 4.350 % 4.600 % 10-23-2015
 Czech CNB Czech Republic 0.050 % 0.250 % 11/01/2012
 Danish Nationalbanken Denmark 0.050 % 0.200 % 01-19-2015
 European ECB Europe 0.050 % 0.150 % 9/04/2014
 Hungarian National Bank Hungary 1.350 % 1.500 % 07-21-2015
 Indian RBI India 6.750 % 7.250 % 09-29-2015
 Indonesian BI Indonesia 7.500 % 7.750 % 02-17-2015
 Israeli BOI Israel 0.100 % 0.250 % 02-23-2015
 Japanese BoJ Japan 0.100 % 0.100 % 10/05/2010
 Mexican Banxico Mexico 3.000 % 3.500 % 6/06/2014
 New Zealand Reserve Bank New Zealand 2.750 % 3.000 % 9/10/2015
 Norwegian Sentralbanken Norway 0.750 % 1.000 % 09-24-2015
 Polish Narodowy Poland 1.500 % 2.000 % 3/04/2015
 Russian CBR Russia 11.000 % 11.500 % 07-31-2015
 Saudi Arabian SAMA Saudi Arabia 2.000 % 2.500 % 01-19-2009
 South African SARB South Africa 6.250 % 6.000 % 11-19-2015
 Swedish Riksbank Sweden -0.350 % -0.250 % 7/02/2015
 Swiss SNB Switzerland -0.750 % -0.500 % 01-15-2015
 Turkish CBRT Turkey 7.500 % 7.750 % 02-24-2015
United States FED United States 0.250 % 1.000 % 12-16-2008