undamentalytics Newsletter

Mcdermott John P: insider trades

Officer at Rockwell Automation. No open-market purchases and 19 sales not made under a pre-set plan, reported from May 11, 2010 to February 28, 2018.

What happened after Mcdermott John P’s sales?

After their sales, the shares moved +0.7% against the index over 12 months on average (a negative figure means selling was the right call); 58% trailed it.

With 296 insiders tested, some will look skilled or unskilled by chance alone: when we replaced each insider’s stocks with random companies bought on the same days, about 5.7 cleared the bar ahead and 23.3 behind. One record on its own proves little.

Trade by trade

Mcdermott John P: trades against the S&P 500 afterwards
MeasuredTrades countedAverage vs S&P 500MedianWent the right wayYearst-statisticp-valueEvidence
Purchases, 3 months after the report 0 — — — — — — Not enough years
Purchases, 6 months after the report 0 — — — — — — Not enough years
Purchases, 12 months after the report 0 — — — — — — Not enough years
Purchases, 12 months after the trade 0 — — — — — — Not enough years
Sales, 3 months after the report 19 +0.5% −0.8% 53% 9 0.51 0.63 No reliable evidence
Sales, 12 months after the report 19 +0.7% −2.3% 58% 9 0.45 0.67 No reliable evidence
Sales, 12 months after the trade 19 +1.2% −2.6% 58% 9 0.59 0.57 No reliable evidence

“Average vs S&P 500” is the stock’s return including dividends minus the index’s over the same dates, from the close on the first trading day after the report, or from the close on the trade date. Only windows that have finished are counted. For sales, a negative figure means the stock lagged after it was sold, so selling was the right call (green). “Went the right way” is the share of purchases that beat the index, or of sales that trailed it. The t-statistic uses one average per year of reports, because one person’s trades bunch into the same stock and weeks, and needs trades in at least four different years; the p-value comes from the t distribution with that number of years (with four years, a t of 2 has p = 0.14). “Some evidence” means p under 5%, “strong evidence” p under 1% over at least six years.

Companies traded

CompanyTitle on the latest filingPurchasesSalesFirst reportLatest report
Rockwell Automation ROK Sr. Vice President019May 11, 2010February 28, 2018

Trades and what followed

Moves are against the S&P 500; green means the trade went the insider’s way.

ReportedTradedCompanyTradeValue3 months after report12 months after report12 months after trade
February 28, 2018February 26, 2018 ROK Sale $385,195 −1.5%−3.2%−4.5%
February 26, 2018February 22, 2018 ROK Sale $1,310,050 −2.4%−4.7%−6.0%
February 20, 2018February 16, 2018 ROK Sale $364,806 −2.4%−5.8%−5.4%
February 27, 2017February 24, 2017 ROK Sale $2,540,109 +3.4%+4.8%+7.3%
February 15, 2017February 14, 2017 ROK Sale $2,886,960 +0.7%+5.8%+7.7%
November 15, 2016November 14, 2016 ROK Sale $1,474,670 +5.9%+26.8%+26.2%
May 18, 2015May 15, 2015 ROK Sale $2,905,023 −6.0%−6.0%−4.8%
February 27, 2015February 26, 2015 ROK Sale $1,193,251 +5.5%−2.3%−2.6%
February 12, 2014February 11, 2014 ROK Sale $1,132,834 +0.5%−13.4%−12.2%
November 20, 2013November 19, 2013 ROK Sale $3,002,830 +5.7%−13.0%−15.6%
November 12, 2013November 12, 2013 ROK Sale $2,658,560 +0.2%−19.1%−15.9%
May 21, 2013May 20, 2013 ROK Sale $2,324,070 +10.6%+21.5%+18.9%
February 4, 2013February 1, 2013 ROK Sale $2,809,022 −10.7%+5.5%+8.4%
February 9, 2012February 8, 2012 ROK Sale $2,639,556 −3.7%+0.9%−1.3%
January 31, 2012January 30, 2012 ROK Sale $3,720,752 −8.0%−0.1%+0.6%
February 10, 2011February 10, 2011 ROK Sale $2,540,568 −6.9%−10.2%−9.6%
February 2, 2011February 1, 2011 ROK Sale $1,226,700 −0.8%−4.3%−4.2%
November 16, 2010November 15, 2010 ROK Sale $1,386,720 +27.2%+8.6%+9.6%
May 11, 2010May 10, 2010 ROK Sale $1,495,500 −8.9%+20.5%+26.0%

Open-market purchases and sales of at least $10,000 in companies we cover, from SEC Form 4 filings; sales made under a pre-set Rule 10b5-1 plan are not shown. “Not yet” means the window has not finished or the share price was under $5 at entry. These are the shares’ moves after each trade: they say nothing about why Mcdermott John P traded and do not suggest the use of non-public information. How every insider compares · the insider trading backtest.