undamentalytics Newsletter

Crandall Theodore D: insider trades

Chief financial officer, Officer, Director at 3 companies we cover. 2 open-market purchases and 17 sales not made under a pre-set plan, reported from November 19, 2010 to November 8, 2023.

Would copying Crandall Theodore D’s purchases have beaten the S&P 500?

Too few purchases to judge. Only 2 purchases have 12 months of prices after the report; we judge insiders once they have 20. The figures below can swing a long way on a handful of trades. Buying each purchase the day after it was reported, an equal amount each, and holding it 12 months or until they reported a sale would have turned $10,000 on November 5, 2018 into $20,397 by November 2, 2026, +9.4% a year. The copy held shares only 25% of the time, so the fair comparison is the S&P 500 on those same days with Treasury bills otherwise: $18,653, +8.1% a year (the S&P 500 held throughout made $31,189, +15.3% a year). Beta against the index was 0.21. Twelve months after each report, the average purchase was +9.2% against the S&P 500 (median +9.2%), and 50% beat it. Measured from the trade date, the insider’s own timing, the average was +15.5%. After their sales, the shares moved +1.1% against the index over 12 months on average (a negative figure means selling was the right call); 53% 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.

$0$10.0k$20.0k$30.0k 201820192020202120222023202420252026 $31.2k$20.4k$18.7k
Copying Crandall Theodore DS&P 500, same days investedS&P 500, held throughout $10,000 copying Crandall Theodore D’s open-market purchases from November 5, 2018, before costs and taxes, marked weekly. Each purchase gets the same starting stake, bought at the close of the first trading day after the report and sold 12 months later or the day after a reported sale of that stock; uninvested money earns the Treasury bill rate. “Same days invested” holds the S&P 500 only on the days the copy held shares, Treasury bills otherwise.
Return a year, copying
+9.4%
S&P 500, same days invested
+8.1% (held throughout +15.3%)
Time in shares
25%
Sharpe ratio (S&P 500)
0.45 (0.69)
Biggest drop (S&P 500)
−27% (−34%)
Market sensitivity (beta)
0.21
Purchases copied
2

Trade by trade

Crandall Theodore D: trades against the S&P 500 afterwards
MeasuredTrades countedAverage vs S&P 500MedianWent the right wayYearst-statisticp-valueEvidence
Purchases, 3 months after the report 2 +10.0% +10.0% 50% 2 — — Not enough years
Purchases, 6 months after the report 2 +12.9% +12.9% 50% 2 — — Not enough years
Purchases, 12 months after the report 2 +9.2% +9.2% 50% 2 — — Not enough years
Purchases, 12 months after the trade 2 +15.5% +15.5% 50% 2 — — Not enough years
Sales, 3 months after the report 17 +0.6% +1.1% 47% 9 −0.26 0.80 No reliable evidence
Sales, 12 months after the report 17 +1.1% −2.7% 53% 9 −0.36 0.73 No reliable evidence
Sales, 12 months after the trade 17 +1.3% −3.0% 65% 9 −0.24 0.82 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 Senior Vice President017November 19, 2010August 1, 2018
Zurn Elkay Water Solutions Corp ZWS —10November 2, 2018November 2, 2018
Regal Rexnord Corp RRX —10November 8, 2023November 8, 2023

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
November 8, 2023November 7, 2023 RRX Purchase $201,540 +29.0%+26.7%+38.9%
November 2, 2018November 1, 2018 ZWS Purchase $111,360 −9.0%−8.4%−7.9%
August 1, 2018July 31, 2018 ROK Sale $1,036,552 −4.4%−17.0%−22.0%
February 2, 2018February 1, 2018 ROK Sale $4,736,808 −6.8%−10.8%−11.5%
January 30, 2018January 26, 2018 ROK Sale $2,029,400 −8.5%−10.2%−6.4%
August 3, 2017August 2, 2017 ROK Sale $3,127,194 +16.7%−6.7%−5.1%
May 8, 2017May 5, 2017 ROK Sale $556,505 +2.1%+0.2%−0.1%
May 3, 2017May 2, 2017 ROK Sale $2,973,553 +3.4%+0.5%−3.0%
February 8, 2017February 7, 2017 ROK Sale $3,670,376 +1.1%+8.5%+9.6%
November 22, 2016November 21, 2016 ROK Sale $1,488,520 +7.2%+27.6%+28.8%
November 14, 2016November 11, 2016 ROK Sale $1,472,676 +6.2%+24.2%+27.2%
August 11, 2016August 10, 2016 ROK Sale $640,320 +12.0%+27.1%+25.3%
May 5, 2015May 4, 2015 ROK Sale $2,697,691 −4.9%−5.8%−5.3%
May 28, 2014May 27, 2014 ROK Sale $2,699,456 −7.4%−7.6%−9.0%
September 3, 2013August 30, 2013 ROK Sale $2,902,614 +3.8%−2.7%−2.0%
February 6, 2013February 5, 2013 ROK Sale $3,503,424 −10.1%+5.4%+5.5%
May 25, 2012May 24, 2012 ROK Sale $1,709,464 −12.3%−8.2%−8.9%
February 10, 2011February 9, 2011 ROK Sale $1,485,438 −6.9%−10.2%−6.8%
November 19, 2010November 18, 2010 ROK Sale $1,105,000 +19.0%+3.5%+5.5%

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 Crandall Theodore D traded and do not suggest the use of non-public information. How every insider compares · the insider trading backtest.