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 | | SCTY US zranks | SolarCity Corp | Industrials | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 12.4 | 0.0 | 0.0 | 5.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 29.7 | 32.9 | 24.7 | -1.0 | -8.8 | | 3008 TT zranks | Largan Precision Co Ltd | Information Technology | 12.6 | 21.2 | 16.4 | 8.8 | 14.9 | 11.8 | 5.5 | 10.9 | 8.7 | 4.8 | 6.6 | 5.2 | 2.8 | 1.6 | 2.2 | 57.4 | 71.8 | 72.6 | 33.3 | 28.8 | | PAH3 GR zranks | Porsche Automobil Holding SE | Consumer Discretionary | 0.0 | 5.1 | 4.6 | 0.0 | 0.0 | 0.0 | 0.0 | 16,431.5 | 16,431.5 | 0.6 | 0.5 | 0.5 | 2.0 | 2.6 | 3.0 | 0.0 | 0.0 | 0.0 | -1.1 | 10.8 | | NED SJ zranks | Nedbank Group Ltd | Financials | 8.3 | 8.8 | 7.9 | 0.0 | 0.0 | 0.0 | 1.1 | 2.0 | 1.9 | 1.2 | 1.3 | 1.2 | 5.9 | 5.8 | 6.5 | 0.0 | 0.0 | 0.0 | 1.3 | 1.2 | | BEI GR zranks | Beiersdorf AG | Consumer Staples | 28.9 | 27.6 | 25.7 | 15.9 | 17.0 | 15.9 | 2.9 | 3.3 | 3.1 | 4.6 | 4.0 | 3.6 | 0.8 | 0.8 | 0.8 | 58.4 | 59.1 | 59.4 | 10.0 | 9.6 | | BLBD LI zranks | BLOM Bank SAL | Financials | 0.0 | 4.8 | 4.3 | 0.0 | 0.0 | 0.0 | 0.0 | 2.5 | 2.2 | 0.0 | 0.9 | 0.8 | 0.0 | 8.0 | 9.0 | 0.0 | 0.0 | 0.0 | 1.4 | 1.6 | | SNGR LI zranks | Societatea Nationala de Gaze Naturale ROMGAZ SA | Energy | 0.0 | 11.6 | 12.2 | 3.0 | 4.2 | 4.2 | 0.0 | 3.5 | 3.5 | 0.0 | 0.0 | 0.0 | 0.0 | 5.9 | 5.8 | 99.0 | 0.0 | 0.0 | 0.0 | 0.0 | | CBKD LI zranks | Commercial International Bank Egypt SAE | Financials | 0.0 | 13.2 | 10.9 | 0.0 | 0.0 | 0.0 | 0.0 | 5.9 | 5.0 | 0.0 | 3.6 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.9 | 2.5 | | MNST US zranks | Monster Beverage Corp | Consumer Staples | 48.9 | 30.8 | 26.9 | 29.5 | 18.9 | 16.8 | 10.3 | 7.8 | 7.0 | 6.3 | 7.1 | 6.3 | 0.0 | 0.0 | 0.0 | 60.0 | 64.5 | 64.7 | 14.6 | 20.4 | | RMH SJ zranks | RMB Holdings Ltd | Financials | 13.1 | 10.7 | 10.1 | 2,234.1 | 0.0 | 0.0 | 0.0 | 3,982.3 | 3,567.5 | 2.7 | 2.0 | 1.9 | 4.2 | 5.2 | 5.5 | 0.0 | 0.0 | 0.0 | 22.2 | 19.2 |
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 | | PRND LI zranks | ProMOS Technologies Inc | #N/A N/A | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 74,933.3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | -51.2 | 0.0 | 0.0 | -3.3 | 0.0 | | CL US zranks | Colgate-Palmolive Co | Consumer Staples | 23.7 | 24.6 | 22.7 | 20.2 | 15.3 | 14.3 | 3.8 | 4.1 | 3.9 | 0.0 | 0.0 | 7,195.0 | 2.3 | 2.3 | 2.4 | 58.6 | 61.1 | 61.7 | 10.9 | 20.7 | | 388 HK zranks | Hong Kong Exchanges & Clearing Ltd | Financials | 29.6 | 33.8 | 30.5 | 13.7 | 14.1 | 12.8 | 19.3 | 18.1 | 16.6 | 8.0 | 7.0 | 6.7 | 3.0 | 2.7 | 2.9 | 0.0 | 0.0 | 0.0 | 3.3 | 2.8 | | RAND NA zranks | Randstad Holding NV | Industrials | 20.6 | 13.2 | 12.3 | 12.2 | 10.0 | 9.3 | 0.5 | 0.4 | 0.4 | 3.0 | 2.4 | 2.2 | 2.9 | 3.7 | 4.0 | 18.7 | 20.3 | 20.1 | 7.4 | 9.0 | | CCK US zranks | Crown Holdings Inc | Materials | 13.9 | 14.4 | 12.9 | 10.5 | 9.7 | 9.3 | 0.8 | 0.9 | 0.9 | 49.1 | 11.4 | 8.2 | 0.0 | 0.0 | 0.0 | 16.1 | 20.6 | 20.6 | 4.0 | 5.4 | | GFI SJ zranks | Gold Fields Ltd | Materials | 0.0 | 20.7 | 11.7 | 3.3 | 3.5 | 3.1 | 0.8 | 0.9 | 0.9 | 0.8 | 0.8 | 0.8 | 0.6 | 1.8 | 2.5 | 0.0 | 30.0 | 33.0 | -3.8 | 1.8 | | BUMI IJ zranks | Bumi Resources Tbk PT | Energy | 0.0 | 5.9 | 7.4 | 0.0 | 5.9 | 6.9 | 3.2 | 0.4 | 0.4 | 0.0 | 3.3 | 2.3 | 0.0 | 0.0 | 0.0 | 0.0 | 37.4 | 33.1 | -48.2 | 5.8 | | BTE CN zranks | Baytex Energy Corp | Energy | 0.0 | 0.0 | 0.0 | 0.0 | 6.2 | 5.7 | 0.8 | 0.9 | 0.9 | 0.4 | 0.4 | 0.5 | 17.9 | 0.0 | 0.0 | 1.4 | 0.0 | 0.0 | -19.5 | 0.0 | | ADEN VX zranks | Adecco Group AG | Industrials | 1,275.7 | 14.0 | 13.5 | 27.4 | 9.9 | 9.4 | 0.5 | 0.5 | 0.5 | 3.3 | 2.9 | 2.6 | 3.5 | 3.5 | 3.6 | 19.0 | 18.8 | 18.8 | 0.1 | 7.9 | | LB US zranks | L Brands Inc | Consumer Discretionary | 24.1 | 15.4 | 14.4 | 11.7 | 7.7 | 7.2 | 2.3 | 1.1 | 1.1 | 0.0 | 0.0 | 0.0 | 4.2 | 5.1 | 5.4 | 42.8 | 40.0 | 40.3 | 15.7 | 11.1 |
|
|
