undamentalytics Newsletter

Maclennan David: insider trades

Director at 3 companies we cover. 33 open-market purchases and no sales not made under a pre-set plan, reported from February 14, 2012 to May 14, 2026.

Would copying Maclennan David’s purchases have beaten the S&P 500?

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 February 15, 2012 into $43,166 by November 2, 2026, +10.5% a year. The copy held shares only 85% of the time, so the fair comparison is the S&P 500 on those same days with Treasury bills otherwise: $49,929, +11.6% a year (the S&P 500 held throughout made $72,541, +14.4% a year). Beta against the index was 0.61. Twelve months after each report, the average purchase was +3.0% against the S&P 500 (median −2.7%), and 46% beat it: within what luck alone would produce (p = 0.93 over 12 years). Measured from the trade date, the insider’s own timing, the average was +2.9%.

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$25.0k$50.0k$75.0k 20122014201620182020202220242026 $72.5k$49.9k$43.2k
Copying Maclennan DavidS&P 500, same days investedS&P 500, held throughout $10,000 copying Maclennan David’s open-market purchases from February 15, 2012, 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
+10.5%
S&P 500, same days invested
+11.6% (held throughout +14.4%)
Time in shares
85%
Sharpe ratio (S&P 500)
0.52 (0.79)
Biggest drop (S&P 500)
−28% (−34%)
Market sensitivity (beta)
0.61
Purchases copied
33

Trade by trade

Maclennan David: trades against the S&P 500 afterwards
MeasuredTrades countedAverage vs S&P 500MedianWent the right wayYearst-statisticp-valueEvidence
Purchases, 3 months after the report 33 +0.1% −1.8% 42% 13 0.50 0.63 No reliable evidence
Purchases, 6 months after the report 30 +2.1% +0.3% 50% 12 0.13 0.90 No reliable evidence
Purchases, 12 months after the report 28 +3.0% −2.7% 46% 12 0.09 0.93 No reliable evidence
Purchases, 12 months after the trade 28 +2.9% −1.2% 50% 12 0.05 0.96 No reliable evidence
Sales, 3 months after the report 0 — — — — — — Not enough years
Sales, 12 months after the report 0 — — — — — — Not enough years
Sales, 12 months after the trade 0 — — — — — — Not enough years

“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
Ecolab ECL —190February 28, 2017May 14, 2026
Caterpillar Inc. CAT —100May 6, 2021May 5, 2026
C.H. Robinson CHRW —40February 14, 2012May 6, 2014

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
May 14, 2026May 13, 2026 ECL Purchase $250,650 +6.9%not yetnot yet
May 5, 2026May 4, 2026 ECL Purchase $205,528 +2.9%not yetnot yet
May 5, 2026May 4, 2026 CAT Purchase $219,210 −12.4%not yetnot yet
December 8, 2025December 8, 2025 ECL Purchase $193,200 +11.4%not yetnot yet
November 6, 2025November 6, 2025 CAT Purchase $170,658 +28.7%not yetnot yet
August 15, 2025August 13, 2025 ECL Purchase $167,106 −12.2%−17.8%−22.7%
May 9, 2025May 7, 2025 ECL Purchase $125,875 −1.6%−29.7%−32.0%
May 8, 2025May 7, 2025 CAT Purchase $120,262 +12.9%+150.9%+150.3%
February 18, 2025February 13, 2025 ECL Purchase $105,804 +1.8%+1.6%+2.3%
August 6, 2024August 2, 2024 ECL Purchase $156,266 −4.7%−4.8%−5.8%
May 7, 2024May 3, 2024 ECL Purchase $147,790 −1.0%−4.0%+1.7%
May 6, 2024May 3, 2024 CAT Purchase $168,695 −5.8%−14.6%−14.5%
February 26, 2024February 23, 2024 CAT Purchase $113,180 +1.3%−12.2%−11.2%
December 4, 2023December 1, 2023 ECL Purchase $153,224 +5.3%−2.8%−3.0%
August 9, 2023August 7, 2023 ECL Purchase $119,424 −2.6%+8.4%+10.2%
June 15, 2023June 14, 2023 ECL Purchase $126,161 −4.5%+8.9%+9.1%
February 21, 2023February 17, 2023 CAT Purchase $99,716 −14.4%+9.6%+6.6%
November 10, 2022November 8, 2022 ECL Purchase $111,728 −1.9%+5.3%+10.4%
May 6, 2022May 5, 2022 ECL Purchase $102,606 −3.9%+2.8%+3.7%
May 6, 2022May 5, 2022 CAT Purchase $131,892 −12.9%+0.4%+0.4%
February 22, 2022February 18, 2022 ECL Purchase $107,454 −1.8%−2.6%−2.9%
February 9, 2022February 7, 2022 CAT Purchase $95,760 +12.9%+31.7%+34.2%
August 5, 2021August 4, 2021 CAT Purchase $103,100 −7.6%−3.5%−3.9%
May 6, 2021May 5, 2021 CAT Purchase $99,901 −18.2%−7.8%−9.1%
August 10, 2020August 6, 2020 ECL Purchase $77,620 +3.8%−21.9%−20.2%
March 8, 2019March 6, 2019 ECL Purchase $171,050 +13.4%+7.7%+6.8%
August 3, 2018August 2, 2018 ECL Purchase $73,200 +8.7%+33.4%+31.7%
November 8, 2017November 6, 2017 ECL Purchase $59,296 −3.1%+14.2%+12.1%
February 28, 2017February 24, 2017 ECL Purchase $99,952 +4.7%−10.4%−13.3%
May 6, 2014May 2, 2014 CHRW Purchase $23,536 +11.7%+1.1%+0.9%
May 15, 2013May 13, 2013 CHRW Purchase $14,098 −4.0%−11.7%−10.5%
February 13, 2013February 11, 2013 CHRW Purchase $20,780 −8.8%−26.8%−29.3%
February 14, 2012February 10, 2012 CHRW Purchase $19,029 −3.3%−22.6%−21.1%

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