Commentary and Tracking of a Portfolio of Stocks using approach from "The Little Book that Beats the Market" by Joel Greenblatt aka Magic Formula Investing

Monday, November 05, 2018

Top 200 List 11/3/18

Top 200 List 11/3/18

Well, I felt like running a top 200 list this weekend. I only have ten days to go until I have to pick 5 new stocks and I wanted a second list to look at as the markets have been going through a lot of turmoil lately.

This is my version of the official magic formula screener from Joel Greenblatt's book. I believe I come very close to matching the actual calculations. When I first developed this, the official screen gave more earnings yield and ROIC data - so that is a large reason for confidence.

The formula details can be found in my blog post "The Calculation" if you want to see more. I had a lot of help developing it from people on the Yahoo MFI board back in the day. Also Randy Harmelink, of SMF fame, helped me automate workbook once the formulae were all working well.

I do give more info than official site. I use Fidelity for data source and they use Compustat, so that matches what official website uses. I do provide earnings yield and ROIC. I also typically have more names as I do not throw out as many non-US firms and I keep some insurers and investment firms.

Ticker

Rank

Stock
Price

Market Cap

Earnings Yield

ROIC

Dividend Yield

FNJN

1

3.83

135

55%

20682%

0.00%

IMMR

2

10.19

314

25%

1813%

0.00%

NHTC

3

23.23

263

23%

3713%

2.34%

XOMA

4

12.79

107

22%

9469%

0.00%

NKTR

5

39.05

7,118

17%

2098%

0.00%

EVC

6

5.14

463

53%

296%

3.88%

PTN

7

0.92

194

16%

12963%

0.00%

ACOR

8

19.46

918

21%

335%

0.00%

UIS

9

18.19

935

23%

235%

0.00%

AGX

10

44.21

693

16%

331%

1.70%

BPT

11

31.41

672

13%

42889%

13.48%

QTRH

12

1.28

152

24%

173%

3.05%

CMCM

13

8.69

1,262

12%

808%

0.00%

CJREF

14

3.95

831

16%

207%

#VALUE!

MSB

15

27.26

358

12%

472%

#VALUE!

MOH

16

123.00

8,204

13%

329%

0.00%

IDCC

17

74.31

2,646

11%

2120%

1.88%

YY

18

68.61

4,380

14%

205%

0.00%

HRB

19

27.13

5,634

12%

333%

3.59%

DLX

20

49.98

2,339

12%

336%

2.41%

EGY

21

1.87

112

24%

118%

0.00%

UTHR

22

114.64

5,044

20%

123%

0.00%

QIWI

23

13.08

795

11%

432%

0.00%

BPI

24

9.51

260

13%

188%

0.00%

LEXEA

25

43.14

2,459

16%

126%

0.00%

SJT

26

5.15

240

11%

492%

10.53%

EGOV

27

14.00

932

11%

411%

2.29%

INVA

28

15.88

1,800

11%

369%

0.00%

FTSI

29

13.06

1,427

24%

97%

0.00%

SRNE

30

3.68

370

12%

219%

0.00%

SQBG

31

1.25

80

13%

154%

0.00%

KLAC

32

93.29

14,561

12%

205%

2.87%

AEIS

33

46.87

1,837

14%

124%

0.00%

ESIO

34

29.01

1,043

14%

126%

0.00%

MSGN

35

25.52

1,933

11%

278%

0.00%

AMAT

36

35.27

35,446

13%

121%

1.70%

WU

37

17.91

8,042

10%

416%

4.17%

DHX

38

1.82

92

15%

108%

0.00%

LRCX

39

151.51

25,049

13%

110%

2.13%

VIAB

40

31.67

12,773

12%

121%

2.53%

AVP

41

1.92

849

19%

80%

0.00%

ALSN

42

44.64

5,870

11%

163%

1.33%

CASA

43

14.64

1,374

10%

224%

0.00%

VEC

44

27.28

311

13%

106%

0.00%

THO

45

74.74

3,952

17%

78%

2.01%

STX

46

44.27

12,927

12%

109%

0.00%

TGS

47

15.55

2,471

13%

93%

3.32%

WDC

48

47.74

14,227

18%

76%

4.20%

VIA

49

35.86

14,462

11%

121%

2.23%

CRTO

50

22.07

1,515

14%

85%

0.00%

SP

51

31.24

707

10%

295%

0.00%

UEPS

52

7.00

398

20%

71%

0.00%

LEE

53

2.76

155

14%

85%

0.00%

IPG

54

22.80

8,856

10%

176%

3.56%

PBT

55

7.40

345

9%

14752%

8.90%

PETS

56

28.37

582

11%

126%

3.42%

HSII

57

34.91

677

10%

161%

1.85%

ZAGG

58

12.63

362

14%

80%

0.00%

PFMT

59

1.73

89

19%

69%

0.00%

DXC

60

70.63

20,433

12%

93%

1.05%

KLIC

61

21.77

1,530

20%

64%

1.11%

OMC

62

74.69

16,872

9%

294%

3.21%

GPP

63

14.90

474

11%

126%

12.71%

GME

64

15.61

1,594

21%

61%

9.73%

CELG

65

74.19

53,395

9%

356%

0.00%

TPR

66

42.81

143

69%

63%

0.00%

BKE

67

21.41

1,040

16%

65%

4.66%

SGH

68

31.01

722

19%

62%

0.00%

SHI

69

45.73

4,951

33%

56%

10.40%

AMCX

70

58.98

3,444

12%

84%

0.00%

MCFT

71

31.11

582

9%

262%

0.00%

CO

72

6.92

769

30%

56%

1.16%

HCC

73

27.22

1,445

24%

56%

0.73%

HPQ

74

24.63

39,851

9%

202%

2.28%

MKSI

75

78.24

4,300

13%

72%

0.98%

ESRX

76

96.74

54,939

8%

1151%

0.00%

TVTY

77

34.78

1,505

8%

1011%

0.00%

NVMI

78

24.57

707

10%

103%

0.00%

JILL

79

5.38

241

16%

59%

0.00%

CECO

80

13.42

963

9%

234%

0.00%

MTOR

81

16.89

1,517

16%

60%

0.00%

MU

82

40.32

49,029

32%

53%

0.00%

LPX

83

23.22

3,395

24%

53%

1.68%

MAN

84

79.27

5,153

15%

58%

2.45%

NANO

85

33.50

820

12%

72%

0.00%

CVS

86

73.09

74,406

11%

84%

2.75%

SNE

87

53.66

69,574

10%

113%

0.46%

ICHR

88

19.41

507

13%

62%

0.00%

LEA

89

138.87

9,147

17%

54%

1.89%

TSQ

90

7.04

194

12%

67%

3.19%

TARO

91

99.56

3,909

12%

69%

0.00%

TGNA

92

12.15

2,631

10%

98%

2.30%

MIK

93

16.47

2,935

12%

69%

0.00%

BIIB

94

312.70

63,134

9%

122%

0.00%

WGO

95

29.15

926

13%

58%

1.37%

SBR

96

36.52

532

7%

19712%

24.04%

FUJHY

97

13.32

20,425

23%

49%

4.86%

TUSK

98

26.96

1,215

30%

47%

0.45%

MD

99

39.24

3,585

8%

166%

0.00%

VGR

100

13.17

1,839

8%

254%

11.71%

DFIN

101

15.82

538

11%

68%

0.00%

AMGN

102

187.06

121,402

8%

177%

2.74%

OMAB

103

43.02

2,116

9%

136%

3.79%

BBY

104

71.89

20,395

10%

82%

2.34%

STRL

105

11.96

324

15%

52%

0.00%

OSB

106

28.29

2,467

27%

43%

17.08%

WTW

107

48.13

3,385

7%

746%

0.00%

EXEL

108

17.41

5,438

8%

309%

0.00%

AET

109

198.21

65,449

7%

900%

1.00%

SDI

110

16.98

282

10%

69%

0.00%

CBS

111

56.17

21,288

10%

83%

0.00%

PBH

112

37.73

1,968

8%

157%

0.00%

SEDG

113

37.75

1,823

10%

79%

0.00%

KRO

114

15.00

1,739

25%

41%

4.40%

MO

115

63.67

119,891

7%

509%

4.48%

MCK

116

125.41

24,957

9%

107%

1.12%

GENC

117

11.70

172

19%

43%

0.00%

HUM

118

323.00

44,760

8%

197%

0.58%

KORS

119

58.29

8,883

9%

84%

0.00%

CERC

120

4.41

142

7%

5551%

0.00%

ANTM

121

268.00

71,127

8%

219%

1.11%

ENTA

122

79.88

1,679

8%

177%

0.00%

EME

123

72.89

4,267

9%

76%

0.44%

UCTT

124

11.52

453

26%

39%

0.00%

FL

125

48.80

5,714

15%

44%

2.75%

ODP

126

2.68

1,514

15%

43%

3.72%

SWKS

127

85.27

15,587

9%

74%

1.58%

CKHUY

128

10.25

39,541

14%

45%

3.65%

CSVI

129

51.30

715

8%

129%

2.52%

LFVN

130

11.29

171

8%

156%

0.00%

YUM

131

86.90

28,243

7%

192%

1.58%

SBH

132

18.53

2,255

12%

52%

0.00%

TNET

133

47.32

3,435

7%

329%

0.00%

MBUU

134

42.39

878

8%

146%

0.68%

LB

135

33.85

9,444

11%

53%

7.11%

MAS

136

31.32

9,584

10%

62%

1.41%

KFY

137

47.00

2,603

9%

80%

0.87%

PBI

138

8.09

1,524

9%

68%

9.27%

NTRI

139

37.57

1,111

7%

221%

2.46%

CRT

140

14.86

89

8%

89%

9.10%

ABC

141

88.57

19,553

8%

102%

1.72%

KNMCY

142

41.14

5,650

10%

63%

1.48%

ATLKY

143

25.20

30,618

8%

120%

6.77%

SYX

144

30.91

1,171

8%

117%

1.38%

VVV

145

20.40

3,998

9%

69%

1.48%

RHI

146

62.29

7,565

8%

115%

1.76%

GHC

147

612.16

3,267

8%

90%

0.87%

CC

148

34.37

6,251

16%

38%

1.79%

NVR

149

2,258.00

9,158

11%

52%

0.00%

TEN

150

35.82

1,841

18%

37%

2.80%

ROCK

151

32.86

1,070

10%

54%

0.00%

NLS

152

12.86

391

9%

63%

0.00%

OSK

153

64.73

4,774

13%

41%

1.52%

GPS

154

27.91

10,885

13%

40%

0.00%

MGLN

155

67.32

1,710

8%

81%

0.00%

COHR

156

135.07

3,360

12%

44%

0.00%

NATH

157

72.01

304

7%

252%

0.69%

USNA

158

112.59

2,815

7%

193%

0.00%

DMLP

159

17.81

575

9%

68%

9.76%

LCI

160

4.24

158

20%

35%

0.00%

ORCL

161

48.83

195,271

7%

238%

1.53%

GIB

162

61.30

17,626

7%

256%

0.00%

TER

163

36.11

6,879

8%

96%

0.94%

BTI

164

43.51

99,681

7%

160%

6.02%

CLF

165

10.73

3,328

13%

40%

0.47%

MOMO

166

35.41

7,491

7%

942%

0.00%

IBM

167

115.67

105,861

9%

60%

5.30%

MMS

168

63.87

4,211

8%

93%

0.28%

CDK

169

57.51

7,614

7%

329%

1.03%

DLPH

170

21.91

1,951

19%

34%

0.00%

ALV

171

86.77

7,584

11%

44%

2.80%

HOLI

172

19.62

1,202

15%

36%

0.91%

JCOM

173

71.60

3,524

7%

310%

2.29%

YRD

174

17.80

1,101

25%

32%

1.57%

AYI

175

131.01

5,254

9%

68%

0.40%

JOUT

176

75.88

759

10%

49%

0.63%

RTN

177

181.55

51,923

8%

97%

0.00%

CTSH

178

69.50

40,310

8%

96%

0.00%

KBAL

179

16.55

616

9%

57%

1.75%

XRX

180

28.32

7,195

10%

48%

3.53%

FCN

181

67.30

2,608

9%

66%

0.00%

MEI

182

30.28

1,140

13%

37%

1.45%

ATEYY

183

20.94

4,155

10%

49%

3.12%

VHI

184

2.36

807

18%

33%

3.41%

EBF

185

19.93

512

10%

46%

4.26%

PPC

186

18.73

4,665

14%

35%

0.00%

RTEC

187

21.28

690

12%

40%

0.00%

SGU

188

9.63

519

10%

51%

4.79%

BLBD

189

19.03

543

7%

103%

0.00%

TLYS

190

16.68

495

10%

47%

0.00%

PM

191

88.75

138,006

7%

138%

4.98%

SNA

192

157.26

9,016

9%

53%

2.10%

CSCO

193

45.48

214,757

6%

425%

2.80%

SERV

194

42.88

5,823

7%

231%

0.00%

TXN

195

95.06

94,014

7%

115%

2.77%

ACCO

196

8.95

967

12%

39%

2.00%

REGI

197

28.69

1,207

19%

31%

0.00%

ATTO

198

6.44

480

12%

38%

#VALUE!

PNR

199

41.63

7,314

7%

112%

2.52%

CAH

200

51.44

15,946

9%

59%

3.64%

Here is my comparison against the official top 50

Ticker

Mkt Cap

Date

My Ranking

Price

EY

ROIC

ACOR

918

2-Nov

8

19.46

21%

335%

AEIS

1,827

2-Nov

33

46.87

14%

124%

ALSN

5,858

2-Nov

42

44.64

11%

163%

AMCX

3,354

2-Nov

70

58.98

12%

84%

AMAT

34,670

2-Nov

36

35.27

13%

121%

AGX

688

2-Nov

10

44.21

16%

331%

AVP

849

2-Nov

41

1.92

19%

80%

HRB

5,575

2-Nov

19

27.13

12%

333%

BPT

672

2-Nov

11

31.41

13%

42889%

CECO

936

2-Nov

80

13.42

9%

234%

CASA

1,262

2-Nov

43

14.64

10%

224%

CELG

51,851

2-Nov

65

74.19

9%

356%

CJREF

837

2-Nov

14

3.95

16%

207%

DLX

2,314

2-Nov

20

49.98

12%

336%

DXC

19,918

2-Nov

60

70.63

12%

93%

EVC

457

2-Nov

6

5.14

53%

296%

ESRX

54,523

2-Nov

76

96.74

8%

1151%

FTSI

1,427

2-Nov

29

13.06

24%

97%

GME

1,591

2-Nov

64

15.61

21%

61%

HSII

662

2-Nov

57

34.91

10%

161%

HPQ

38,975

2-Nov

74

24.63

9%

202%

IDT

172

2-Nov

#N/A

#N/A

#N/A

#N/A

IMMR

313

2-Nov

2

10.19

25%

1813%

INVA

1,801

2-Nov

28

15.88

11%

369%

IDCC

2,575

2-Nov

17

74.31

11%

2120%

IPG

8,763

2-Nov

54

22.80

10%

176%

KLAC

14,481

2-Nov

32

93.29

12%

205%

LRCX

24,309

2-Nov

39

151.51

13%

110%

LEE

158

2-Nov

53

2.76

14%

85%

MCFT

581

2-Nov

71

31.11

9%

262%

MSB

358

2-Nov

15

27.26

12%

472%

MSGN

1,910

2-Nov

35

25.52

11%

278%

NHTC

264

2-Nov

3

23.23

23%

3713%

NKTR

6,733

2-Nov

5

39.05

17%

2098%

EGOV

918

2-Nov

27

14.00

11%

411%

OMC

16,790

2-Nov

62

74.69

9%

294%

PTN

185

2-Nov

7

0.92

16%

12963%

PETS

587

2-Nov

56

28.37

11%

126%

STX

12,705

2-Nov

46

44.27

12%

109%

SRNE

428

2-Nov

30

3.68

12%

219%

SP

710

2-Nov

51

31.24

10%

295%

THO

3,938

2-Nov

45

74.74

17%

78%

TVTY

1,390

2-Nov

77

34.78

8%

1011%

TUP

1,897

2-Nov

#N/A

#N/A

#N/A

#N/A

UIS

930

2-Nov

9

18.19

23%

235%

UTHR

5,392

2-Nov

22

114.64

20%

123%

VEC

307

2-Nov

44

27.28

13%

106%

VIAB

12,766

2-Nov

40

31.67

12%

121%

WDC

13,940

2-Nov

48

47.74

18%

76%

ZAGG

356

2-Nov

58

12.63

14%

80%

So a couple snafus this run. I only had IDT at about #370. I will take a deeper dive this week and see if I see an issue (perhaps some special income defined differently).

Then TUP is clearly a stock that should be on the list. I suspect this is timing as my Fidelity data base had n/a for some balance sheet items like A/R so it was dropped from my calc. I expect Fidelity will fill those items in next week or so.