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
2016 | PE RATIO
2017 | PE RATIO
2018 | EV/EBITDA
2016 | EV/EBITDA
2017 | EV/EBITDA
2018 | P/S
2016 | P/S
2017 | P/S
2018 | P/B
2016 | P/B
2017 | P/B
2018 | DIVIDEND YIELD
2016 | DIVIDEND YIELD
2017 | DIVIDEND YIELD
2018 | GROSS MARGIN
2016 | GROSS MARGIN
2017 | GROSS MARGIN
2018 | ROA
2016 | ROA
2017 | | 3008 TT zranks | Largan Precision Co Ltd | Information Technology | 12.6 | 25.0 | 18.1 | 8.8 | 17.5 | 13.1 | 5.5 | 12.6 | 9.6 | 4.8 | 7.7 | 5.9 | 2.8 | 1.4 | 1.9 | 57.4 | 70.2 | 71.8 | 33.3 | 27.7 | | PAH3 GR zranks | Porsche Automobil Holding SE | Consumer Discretionary | 0.0 | 4.4 | 3.9 | 0.0 | 0.0 | 0.0 | 0.0 | 15,059.8 | 15,059.8 | 0.6 | 0.4 | 0.4 | 2.0 | 2.7 | 3.5 | 0.0 | 0.0 | 0.0 | -1.1 | 12.5 | | CCK US zranks | Crown Holdings Inc | Materials | 13.9 | 14.8 | 13.3 | 10.5 | 9.9 | 9.5 | 0.8 | 1.0 | 0.9 | 49.1 | 11.2 | 7.7 | 0.0 | 0.0 | 0.0 | 16.1 | 20.5 | 20.6 | 4.0 | 5.4 | | LB US zranks | L Brands Inc | Consumer Discretionary | 24.1 | 14.3 | 13.7 | 11.7 | 7.5 | 7.2 | 2.3 | 1.1 | 1.0 | 0.0 | 0.0 | 0.0 | 4.2 | 5.2 | 5.4 | 42.8 | 39.8 | 40.0 | 15.7 | 11.2 | | ABX CN zranks | Barrick Gold Corp | Materials | 252.6 | 23.5 | 21.3 | 0.0 | 6.3 | 7.0 | 1.0 | 2.4 | 2.6 | 1.2 | 2.1 | 1.9 | 1.5 | 0.7 | 0.7 | 23.5 | 54.8 | 52.5 | -9.4 | 3.8 | | RMH SJ zranks | RMB Holdings Ltd | Financials | 13.1 | 11.1 | 10.5 | 2,234.1 | 0.0 | 0.0 | 0.0 | 4,942.5 | 4,448.3 | 2.7 | 2.1 | 2.0 | 4.2 | 3.7 | 3.9 | 0.0 | 0.0 | 0.0 | 22.2 | 19.2 | | AIR FP zranks | Airbus SE | Industrials | 18.1 | 21.4 | 16.2 | 7.0 | 7.1 | 6.1 | 0.8 | 0.8 | 0.8 | 8.2 | 9.9 | 7.2 | 2.1 | 2.1 | 2.5 | 13.7 | 11.3 | 12.2 | 2.7 | 2.5 | | SWMA SS zranks | Swedish Match AB | Consumer Staples | 20.7 | 17.5 | 16.4 | 15.6 | 13.0 | 12.8 | 4.0 | 3.2 | 3.1 | 226.0 | 0.0 | 0.0 | 2.7 | 4.8 | 3.3 | 46.9 | 46.4 | 46.6 | 17.9 | 21.2 | | 388 HK zranks | Hong Kong Exchanges & Clearing Ltd | Financials | 29.6 | 40.3 | 36.4 | 13.7 | 7.8 | 7.0 | 19.3 | 22.3 | 20.2 | 8.0 | 8.3 | 8.0 | 3.0 | 2.2 | 2.5 | 0.0 | 0.0 | 0.0 | 3.3 | 2.8 | | DIGI MK zranks | DiGi.Com Bhd | Telecommunication Services | 24.3 | 24.1 | 24.1 | 0.0 | 13.6 | 13.5 | 6.1 | 5.8 | 5.7 | 80.8 | 65.0 | 61.7 | 4.1 | 4.1 | 4.1 | 70.6 | 58.3 | 58.6 | 38.4 | 29.4 |
Top Global Short Picks| Ticker | Company | Sector | PE RATIO
2016 | PE RATIO
2017 | PE RATIO
2018 | EV/EBITDA
2016 | EV/EBITDA
2017 | EV/EBITDA
2018 | P/S
2016 | P/S
2017 | P/S
2018 | P/B
2016 | P/B
2017 | P/B
2018 | DIVIDEND YIELD
2016 | DIVIDEND YIELD
2017 | DIVIDEND YIELD
2018 | GROSS MARGIN
2016 | GROSS MARGIN
2017 | GROSS MARGIN
2018 | ROA
2016 | ROA
2017 | | GCHE RM zranks | Cherkizovo Group PJSC | Consumer Staples | 7.6 | 9.8 | 6.5 | 7.2 | 6.6 | 5.3 | 0.6 | 0.6 | 0.5 | 0.9 | 0.9 | 0.8 | 0.0 | 1.1 | 3.8 | 24.9 | 26.7 | 27.4 | 6.3 | 5.1 | | MRK US zranks | Merck & Co Inc | Health Care | 17.6 | 16.6 | 15.2 | 12.0 | 12.3 | 11.5 | 3.8 | 4.4 | 4.2 | 3.3 | 4.7 | 4.7 | 3.4 | 2.9 | 3.0 | 62.2 | 76.4 | 76.7 | 4.5 | 7.9 | | MRK US zranks | Merck & Co Inc | Health Care | 17.6 | 16.6 | 15.2 | 12.0 | 12.3 | 11.5 | 3.8 | 4.4 | 4.2 | 3.3 | 4.7 | 4.7 | 3.4 | 2.9 | 3.0 | 62.2 | 76.4 | 76.7 | 4.5 | 7.9 | | TDC US zranks | Teradata Corp | Information Technology | 16.2 | 25.3 | 24.8 | 0.0 | 10.0 | 9.9 | 1.5 | 2.0 | 2.0 | 4.1 | 5.1 | 5.2 | 0.0 | 0.0 | 0.0 | 50.4 | 51.4 | 51.9 | -7.6 | 1.4 | | TDC US zranks | Teradata Corp | Information Technology | 16.2 | 25.3 | 24.8 | 0.0 | 10.0 | 9.9 | 1.5 | 2.0 | 2.0 | 4.1 | 5.1 | 5.2 | 0.0 | 0.0 | 0.0 | 50.4 | 51.4 | 51.9 | -7.6 | 1.4 | | OML LN zranks | Old Mutual PLC | Financials | 15.3 | 9.4 | 8.8 | 0.0 | 0.0 | 0.0 | 0.7 | 1.9 | 1.8 | 1.2 | 1.2 | 1.2 | 5.0 | 3.9 | 4.0 | 0.0 | 0.0 | 0.0 | 0.4 | 0.5 | | OML LN zranks | Old Mutual PLC | Financials | 15.3 | 9.4 | 8.8 | 0.0 | 0.0 | 0.0 | 0.7 | 1.9 | 1.8 | 1.2 | 1.2 | 1.2 | 5.0 | 3.9 | 4.0 | 0.0 | 0.0 | 0.0 | 0.4 | 0.5 | | 494 HK zranks | Li & Fung Ltd | Consumer Discretionary | 13.5 | 13.0 | 11.7 | 10.3 | 9.5 | 9.0 | 0.3 | 0.2 | 0.2 | 2.3 | 1.0 | 0.9 | 5.3 | 7.2 | 7.4 | 11.5 | 11.7 | 11.9 | 5.5 | 3.9 | | OKEY LI zranks | O'Key Group SA | Consumer Staples | 20.5 | 22.9 | 13.9 | 6.6 | 5.6 | 4.9 | 0.2 | 0.2 | 0.2 | 1.6 | 1.4 | 1.3 | 4.2 | 2.9 | 2.5 | 23.6 | 23.0 | 23.2 | 2.2 | 1.6 | | SPLS US zranks | Staples Inc | Consumer Discretionary | 8.9 | 11.5 | 11.8 | 5.1 | 5.1 | 5.3 | 0.3 | 0.4 | 0.4 | 1.1 | 1.8 | 1.7 | 5.4 | 4.8 | 4.7 | 26.2 | 26.9 | 26.9 | 3.7 | 7.3 |
|
|
