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 | | SNGR LI zranks | Societatea Nationala de Gaze Naturale ROMGAZ SA | Energy | 0.0 | 8.5 | 8.1 | 3.0 | 3.2 | 3.1 | 0.0 | 2.8 | 2.7 | 0.0 | 0.0 | 0.0 | 0.0 | 12.3 | 12.4 | 99.0 | 0.0 | 0.0 | 0.0 | 0.0 | | 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 | | MNST US zranks | Monster Beverage Corp | Consumer Staples | 48.9 | 35.3 | 30.8 | 29.5 | 21.6 | 19.3 | 10.3 | 8.9 | 8.0 | 6.3 | 8.0 | 7.2 | 0.0 | 0.0 | 0.0 | 60.0 | 64.6 | 64.8 | 14.6 | 20.3 | | SNC CN zranks | SNC-Lavalin Group Inc | Industrials | 19.1 | 26.9 | 19.2 | 8.0 | 12.8 | 9.0 | 0.7 | 1.1 | 0.9 | 1.6 | 1.6 | 1.7 | 2.5 | 2.0 | 2.0 | 15.0 | 16.3 | 18.7 | 3.9 | 4.0 | | 035250 KS zranks | Kangwon Land Inc | Consumer Discretionary | 17.6 | 17.5 | 15.7 | 8.9 | 9.6 | 8.8 | 4.8 | 4.8 | 4.4 | 2.6 | 2.3 | 2.1 | 2.6 | 2.7 | 3.0 | 53.5 | 53.5 | 54.5 | 12.5 | 11.6 | | 4519 JP zranks | Chugai Pharmaceutical Co Ltd | Health Care | 37.9 | 35.6 | 32.1 | 20.3 | 20.6 | 18.8 | 4.6 | 4.8 | 4.5 | 3.7 | 3.6 | 3.4 | 1.4 | 1.3 | 1.5 | 51.8 | 51.6 | 51.9 | 8.0 | 8.8 | | CBOE US zranks | CBOE Holdings Inc | Financials | 27.0 | 28.0 | 24.3 | 14.3 | 18.6 | 15.5 | 8.5 | 10.5 | 9.3 | 20.5 | 3.6 | 3.4 | 1.4 | 1.1 | 1.2 | 0.0 | 0.0 | 0.0 | 53.3 | 15.2 | | BJAUT IN zranks | Bajaj Auto Ltd | Consumer Discretionary | 17.1 | 19.4 | 17.4 | 14.1 | 15.7 | 13.9 | 3.1 | 3.3 | 3.0 | 5.0 | 4.4 | 3.9 | 2.3 | 2.4 | 2.6 | 0.0 | 33.6 | 32.5 | 24.5 | 0.0 | | 036570 KS zranks | NCSoft Corp | Information Technology | 27.9 | 19.5 | 14.5 | 11.8 | 11.7 | 9.0 | 5.5 | 5.1 | 4.4 | 2.6 | 3.6 | 3.0 | 1.3 | 1.2 | 1.4 | 75.8 | 81.0 | 79.7 | 8.4 | 15.9 |
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 | | GFI SJ zranks | Gold Fields Ltd | Materials | 0.0 | 25.6 | 17.7 | 3.3 | 4.1 | 3.6 | 0.8 | 1.2 | 1.1 | 0.8 | 1.0 | 1.0 | 0.6 | 1.5 | 1.8 | 0.0 | 30.0 | 33.0 | -3.8 | 2.2 | | BUMI IJ zranks | Bumi Resources Tbk PT | Energy | 0.0 | 5.1 | 12.8 | 0.0 | 11.4 | 12.1 | 3.2 | 1.0 | 0.9 | 0.0 | 2.8 | 2.0 | 0.0 | 39.2 | 66.6 | 0.0 | 37.4 | 33.1 | -48.2 | 4.8 | | INCY US zranks | Incyte Corp | Health Care | 2,735.1 | 2,221.5 | 135.7 | 211.0 | 0.0 | 169.9 | 25.8 | 19.0 | 16.7 | 118.3 | 38.3 | 24.9 | 0.0 | 0.0 | 0.0 | 96.4 | 94.0 | 93.6 | 0.7 | -10.3 | | 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 | | OTMT LI zranks | Orascom Telecom Media And Technology Holding SAE | Telecommunication Services | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 31.5 | 0.0 | 0.0 | -52.1 | 0.0 | | CHTR US zranks | Charter Communications Inc | Consumer Discretionary | 0.0 | 96.6 | 50.1 | 17.4 | 11.0 | 10.1 | 2.1 | 2.6 | 2.4 | 0.0 | 2.2 | 2.8 | 0.0 | 0.0 | 0.0 | 34.1 | 46.4 | 47.2 | -0.9 | 1.5 | | QEP US zranks | QEP Resources Inc | Energy | 1,988.7 | 0.0 | 0.0 | 4.3 | 5.0 | 3.8 | 1.0 | 1.2 | 1.1 | 0.6 | 0.6 | 0.6 | 0.6 | 0.0 | 0.0 | 12.8 | 0.0 | 0.0 | -1.7 | -0.5 | | ADEN VX zranks | Adecco Group AG | Industrials | 1,275.7 | 13.0 | 12.5 | 27.4 | 9.1 | 8.8 | 0.5 | 0.5 | 0.5 | 3.3 | 2.7 | 2.5 | 3.5 | 3.7 | 3.9 | 19.0 | 18.8 | 18.8 | 0.1 | 8.3 | | 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 | | WYNN US zranks | Wynn Resorts Ltd | Consumer Discretionary | 17.9 | 26.7 | 21.4 | 14.6 | 13.1 | 12.3 | 1.7 | 2.2 | 2.1 | 0.0 | 28.0 | 15.1 | 4.3 | 1.6 | 1.8 | 37.9 | 0.0 | 0.0 | 2.0 | 3.9 |
|
|