SELECT a.Ticker, b.Long_Comp_name, GICS_Sector_Name FROM `avc_toppicks` as a, avc_companies as b, avc_mcaps as c where a.Ticker=b.ticker and a.ticker=c.ticker and c.zrank>-0.6 order by totrank desc limit 10
| Ticker | Company | Sector | PE RATIO
2015 | PE RATIO
2016 | PE RATIO
2017 | EV/EBITDA
2015 | EV/EBITDA
2016 | EV/EBITDA
2017 | P/S
2015 | P/S
2016 | P/S
2017 | P/B
2015 | P/B
2016 | P/B
2017 | DIVIDEND YIELD
2015 | DIVIDEND YIELD
2016 | DIVIDEND YIELD
2017 | GROSS MARGIN
2015 | GROSS MARGIN
2016 | GROSS MARGIN
2017 | ROA
2015 | ROA
2016 |
| CBKD LI zranks | Commercial International Bank Egypt SAE | Financials | 0.0 | 13.9 | 11.3 | 0.0 | 0.0 | 0.0 | 0.0 | 6.4 | 5.1 | 0.0 | 3.8 | 3.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.9 | 2.6 |
| 4732 JP zranks | USS Co Ltd | Consumer Discretionary | 24.8 | 21.4 | 20.8 | 13.0 | 14.2 | 14.1 | 8.0 | 8.7 | 8.6 | 3.8 | 2.9 | 2.7 | 1.8 | 2.5 | 2.5 | 61.8 | 60.9 | 60.8 | 12.8 | 11.6 |
| 036570 KS zranks | NCSoft Corp | Information Technology | 15.8 | 20.4 | 15.6 | 8.7 | 12.4 | 9.2 | 4.3 | 5.8 | 4.6 | 2.7 | 2.9 | 2.5 | 1.9 | 1.3 | 1.6 | 73.7 | 79.3 | 78.9 | 14.5 | 11.2 |
| 3008 TT zranks | Largan Precision Co Ltd | Information Technology | 16.5 | 22.2 | 16.2 | 12.9 | 15.5 | 11.6 | 7.0 | 10.5 | 8.4 | 7.0 | 6.6 | 5.1 | 2.1 | 1.7 | 2.1 | 53.5 | 66.4 | 69.4 | 39.0 | 25.4 |
| COAL IN zranks | Coal India Ltd | Energy | 16.7 | 15.4 | 13.1 | 10.4 | 8.8 | 7.7 | 3.2 | 2.4 | 2.1 | 5.7 | 5.9 | 5.9 | 5.7 | 6.2 | 6.6 | 0.0 | 62.9 | 62.3 | 12.8 | 11.3 |
| GAM MK zranks | Gamuda Bhd | Industrials | 16.7 | 17.2 | 15.2 | 22.2 | 21.1 | 18.4 | 4.7 | 3.6 | 2.8 | 1.8 | 1.6 | 1.5 | 2.5 | 2.5 | 2.6 | 0.0 | 20.0 | 18.9 | 5.8 | 5.1 |
| ATC NA zranks | Altice NV | Consumer Discretionary | 0.0 | 0.0 | 34.5 | 32.2 | 9.5 | 8.3 | 13.9 | 1.1 | 1.0 | 8.3 | 54.4 | 23.8 | 0.0 | 0.0 | 0.0 | 71.6 | 0.0 | 100.0 | -2.0 | -1.7 |
| MGTS RM zranks | Moscow City Telephone Network PJSC | Telecommunication Services | 2.8 | 0.0 | 0.0 | 1.4 | 0.0 | 0.0 | 0.8 | 0.0 | 0.0 | 0.4 | 0.0 | 0.0 | 3.5 | 0.0 | 0.0 | 68.4 | 0.0 | 0.0 | 12.6 | 0.0 |
| AON US zranks | Aon PLC | Financials | 20.3 | 17.1 | 15.6 | 12.3 | 12.9 | 12.0 | 2.3 | 2.5 | 2.4 | 4.0 | 4.9 | 4.5 | 1.0 | 1.2 | 1.3 | 0.0 | 0.0 | 0.0 | 4.7 | 0.0 |
| EXITO CB zranks | Almacenes Exito SA | Consumer Staples | 28.5 | 20.2 | 13.0 | 10.7 | 10.4 | 7.7 | 1.1 | 0.1 | 0.1 | 1.6 | 1.1 | 0.6 | 1.8 | 4.5 | 4.5 | 26.2 | 24.2 | 23.8 | 4.1 | 1.4 |
Top Global Short Picks
| Ticker | Company | Sector | PE RATIO
2015 | PE RATIO
2016 | PE RATIO
2017 | EV/EBITDA
2015 | EV/EBITDA
2016 | EV/EBITDA
2017 | P/S
2015 | P/S
2016 | P/S
2017 | P/B
2015 | P/B
2016 | P/B
2017 | DIVIDEND YIELD
2015 | DIVIDEND YIELD
2016 | DIVIDEND YIELD
2017 | GROSS MARGIN
2015 | GROSS MARGIN
2016 | GROSS MARGIN
2017 | ROA
2015 | ROA
2016 |
| 1114 HK zranks | Brilliance China Automotive Holdings Ltd | Consumer Discretionary | 9.3 | 13.5 | 11.1 | 0.0 | 0.0 | 0.0 | 9.1 | 9.4 | 9.1 | 3.0 | 2.1 | 1.8 | 0.9 | 0.9 | 1.1 | 10.2 | 4.3 | 5.4 | 25.6 | 12.3 |
| BTE CN zranks | Baytex Energy Corp | Energy | 16.7 | 0.0 | 0.0 | 10.2 | 9.8 | 7.6 | 1.9 | 2.0 | 1.6 | 1.3 | 0.7 | 0.7 | 13.7 | 0.0 | 0.0 | 33.7 | 0.0 | 0.0 | -3.0 | 0.0 |
| DISH US zranks | DISH Network Corp | Consumer Discretionary | 35.5 | 19.3 | 21.4 | 13.3 | 12.2 | 12.7 | 2.3 | 1.8 | 1.8 | 16.7 | 6.2 | 5.1 | 0.0 | 0.0 | 0.0 | 25.4 | 35.8 | 35.0 | 4.5 | 5.6 |
| LB US zranks | L Brands Inc | Consumer Discretionary | 24.2 | 17.9 | 16.9 | 11.6 | 9.4 | 9.0 | 2.2 | 1.5 | 1.4 | 1,372.9 | 0.0 | 0.0 | 2.8 | 5.8 | 4.4 | 42.0 | 41.1 | 41.4 | 14.2 | 13.1 |
| LMT US zranks | Lockheed Martin Corp | Industrials | 16.9 | 20.3 | 19.4 | 9.9 | 12.6 | 11.9 | 1.3 | 1.6 | 1.5 | 17.8 | 24.4 | 20.1 | 2.9 | 2.7 | 2.9 | 11.8 | 10.9 | 10.9 | 9.9 | 8.9 |
| CHTR US zranks | Charter Communications Inc | Consumer Discretionary | 0.0 | 82.2 | 55.3 | 12.9 | 11.4 | 10.3 | 2.0 | 2.2 | 2.1 | 127.8 | 1.7 | 1.5 | 0.0 | 0.0 | 0.0 | 34.4 | 36.3 | 36.1 | -0.9 | 1.6 |
| CL US zranks | Colgate-Palmolive Co | Consumer Staples | 23.6 | 23.2 | 21.4 | 17.0 | 14.3 | 13.4 | 3.7 | 3.8 | 3.7 | 54.8 | 0.0 | 569.0 | 2.1 | 2.4 | 2.5 | 58.5 | 60.3 | 61.2 | 16.0 | 21.3 |
| APC US zranks | Anadarko Petroleum Corp | Energy | 22.1 | 0.0 | 296.7 | 5.2 | 13.9 | 8.4 | 2.3 | 5.0 | 3.3 | 2.1 | 2.4 | 2.6 | 1.2 | 0.3 | 0.5 | 50.3 | 69.9 | 77.1 | -3.0 | -3.3 |
| RMH SJ zranks | RMB Holdings Ltd | Financials | 13.1 | 11.6 | 10.6 | 2,234.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.7 | 2.2 | 2.1 | 4.2 | 4.8 | 5.2 | 0.0 | 0.0 | 0.0 | 22.2 | 0.0 |
| JHX AU zranks | James Hardie Industries PLC | Materials | 19.6 | 26.7 | 22.9 | 13.6 | 16.0 | 13.8 | 3.1 | 3.7 | 3.3 | 0.0 | 0.0 | 0.0 | 1.9 | 2.5 | 3.0 | 34.9 | 24.8 | 26.3 | 14.0 | 14.9 |
