Introduction

This page provides a comprehensive analysis of the known insider trading history of David MacLennan. Insiders are officers, directors, or significant investors in a company. It is illegal for insiders to make trades in their companies based on specific, non-public information. This does not mean it is illegal for them to make any trades in their own companies. However, they must report all trades to the SEC via a Form 4. Despite these restrictions, academic research suggests that insiders - in general - tend to outperform the market in their own companies.

Average Trade Profitability

The average trade profitability is the average return of all the open market purchases made by the insider in the last three years. To calculate this, we examine every open-market, unplanned purchase made by the insider, excluding all trades that were marked as part of a 10b5-1 trading plan. We then calculate the average performance of those trades over 3, 6, and 12 months, averaging each of those durations to generate a final performance metric for each trade. Finally, we average all of the performance metrics to calculate a performance metric for the insider. This list only includes insiders that have made at least three trades in the last two years.

If this insiders trade profitability is "N/A", then the insider either has not made any open-market purchases in the last three years, or the trades they’ve made are too recent to calculate a reliable performance metric.

Update Frequency: Daily

See the list of most profitable insider traders.

Companies with Reported Insider Positions

The SEC filings indicate David MacLennan has reported holdings or trades in the following companies:

Security Title Latest Reported Holdings
US:CAT / Caterpillar Inc. Director 7,641
US:ECL / Ecolab Inc. Director 20,253
US:CHRW / C.H. Robinson Worldwide, Inc. Director 7,471
How to Interpret the Charts

The following charts show the stock performance of securities subsequent to each open-market, non-planned trade made by David MacLennan. Non-planned trade are trades that were not made as part of a 10b5-1 trading plan. The stock performance is charted as cumulative percent change in share price. For example, if an insider trade was made on January 1, 2019, the chart will show the daily percent change of the security to the present day. If the share price were to go from $10 to $15 during this time, the cumulative percent change in share price would be 50%. A change in price from $10 to $20 would be 100%, and a change in price of $10 to $5 would be -50%.

Ultimately, we are trying to determine how closely the insider’s trades correlate to excess returns (positive or negative) in the share price in order to see if the insider is timing their trades to profit from insider information. Consider the situation where an insider was doing this. In this situation, we would expect either (a) positive returns after purchases, or (b) negative returns after sales. In the case of (a), the PURCHASE chart would show a series of upwardly sloping curves, indicating positive returns after each purchase transaction. In the case of (b), the SALE chart would show a series of downward sloping curves, indicating negative returns after each sale transaction.

However, this alone is not enough to draw conclusions. If, for example, the share price of the company was in a non-cyclical climb over many years, then we would expect all the post-purchase plots to be upwardly sloping. Likewise, non-cyclical declines over many years would result in downward sloping post-trade plots. Neither of these charts would suggest insider trading activity.

The strongest indicator would be a situation where the share price was extremely cyclical, and there were both positive signals in the PURCHASE chart and negative plots on the SALE chart. This situation would be highly suggestive of an insider that was timing trades to their financial advantage.

Insider Trading History

This table shows the complete list of insider trades made by David MacLennan as disclosed to the Securities Exchange Commission (SEC).

File Date Tran Date Form Ticker Security Code 10b5-1 Shares Remaining Shares Percent
Change
Share
Price
Tran
Value
Remaining
Value
2025-08-19 2025-08-18 4 CAT CATERPILLAR INC
Common Stock
A - Award 500 7,641 7.00 407.76 203,880 3,115,694
2025-08-15 2025-08-13 4 ECL ECOLAB INC.
Common Stock
P - Purchase 600 20,253 3.05 278.51 167,108 5,640,860
2025-07-02 2025-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 43 19,653 0.22 267.48 11,563 5,256,916
2025-07-02 2025-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 126 19,610 0.65
2025-06-13 2025-06-11 4 CAT CATERPILLAR INC
Common Stock
A - Award 482 7,141 7.24 352.53 169,919 2,517,417
2025-05-09 2025-05-07 4 ECL ECOLAB INC.
Common Stock
P - Purchase 500 19,465 2.64 251.74 125,872 4,900,337
2025-05-08 2025-05-07 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 375 6,653 5.97 320.70 120,262 2,133,617
2025-04-02 2025-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 46 18,965 0.24 251.56 11,564 4,770,994
2025-04-02 2025-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 134 18,920 0.71
2025-02-18 2025-02-13 4 ECL ECOLAB INC.
Common Stock
P - Purchase 400 18,767 2.18 264.51 105,806 4,964,182
2025-01-03 2024-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 49 18,367 0.27 234.64 11,563 4,309,749
2025-01-03 2024-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 144 18,304 0.79
2024-10-02 2024-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 45 18,160 0.25 254.34 11,562 4,618,747
2024-10-02 2024-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 133 18,100 0.74
2024-08-06 2024-08-02 4 ECL ECOLAB INC.
Common Stock
P - Purchase 650 17,967 3.75 240.41 156,265 4,319,473
2024-07-02 2024-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 49 17,317 0.29 238.84 11,782 4,136,054
2024-07-02 2024-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 141 17,252 0.83
2024-06-13 2024-06-12 4 CAT CATERPILLAR INC
Common Stock
A - Award 517 6,260 9.00 328.73 169,953 2,057,850
2024-05-07 2024-05-03 4 ECL ECOLAB INC.
Common Stock
P - Purchase 650 17,111 3.95 227.37 147,788 3,890,487
2024-05-06 2024-05-03 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 500 5,738 9.55 337.39 168,695 1,935,944
2024-04-02 2024-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 53 16,461 0.32 230.81 12,189 3,799,342
2024-04-02 2024-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 146 16,392 0.90
2024-02-26 2024-02-23 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 350 5,238 7.16 323.37 113,180 1,693,812
2024-01-03 2023-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 157 16,245 0.98
2023-12-04 2023-12-01 4 ECL ECOLAB INC.
Common Stock
P - Purchase 800 16,070 5.24 191.53 153,221 3,077,834
2023-10-03 2023-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 184 15,270 1.22
2023-08-09 2023-08-07 4 ECL ECOLAB INC.
Common Stock
P - Purchase 650 15,071 4.51 183.73 119,424 2,768,967
2023-08-08 2023-08-07 4 CAT CATERPILLAR INC
Common Stock
A - Award 450 4,868 10.19 277.21 124,744 1,349,458
2023-07-05 2023-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 168 14,421 1.18
2023-06-15 2023-06-14 4 CAT CATERPILLAR INC
Common Stock
A - Award 698 4,418 18.76 243.32 169,837 1,074,988
2023-06-15 2023-06-14 4 ECL ECOLAB INC.
Common Stock
P - Purchase 700 14,236 5.17 180.22 126,158 2,565,643
2023-04-04 2023-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 190 13,536 1.42
2023-02-21 2023-02-17 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 400 3,709 12.09 249.29 99,716 924,617
2023-02-17 2023-02-16 4 ECL ECOLAB INC.
Common Stock
A - Award 500 13,329 3.90 164.16 82,081 2,188,091
2023-01-03 2022-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 215 12,829 1.70
2022-11-10 2022-11-08 4 ECL ECOLAB INC.
Common Stock
P - Purchase 800 12,597 6.78 139.66 111,728 1,759,340
2022-10-04 2022-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 214 11,797 1.85
2022-07-05 2022-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 205 11,568 1.80
2022-06-10 2022-06-08 4 CAT CATERPILLAR INC
Common Stock
A - Award 816 3,297 32.89 229.80 187,517 757,651
2022-05-06 2022-05-05 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 1,399 1,399
2022-05-06 2022-05-05 4 ECL ECOLAB INC.
Common Stock
P - Purchase 600 11,351 5.58 171.01 102,604 1,941,092
2022-05-06 2022-05-05 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 600 2,480 31.91 219.82 131,892 545,154
2022-04-04 2022-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 175 10,751 1.66
2022-02-22 2022-02-18 4 ECL ECOLAB INC.
Common Stock
P - Purchase 600 10,565 6.02 179.09 107,452 1,892,126
2022-02-09 2022-02-07 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 480 1,877 34.36 199.50 95,760 374,462
2022-01-04 2021-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 123 9,965 1.25
2021-10-04 2021-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 136 9,834 1.40
2021-08-05 2021-08-04 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 500 1,392 56.05 206.20 103,100 287,030
2021-07-02 2021-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 140 9,689 1.46
2021-05-07 2021-05-06 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 1,158 1,158
2021-05-06 2021-05-05 4 CAT CATERPILLAR INC
Common Stock
P - Purchase 420 890 89.36 237.86 99,901 211,695
2021-05-05 2021-05-03 4 CAT CATERPILLAR INC
Common Stock
A - Award 470 470 228.17 107,240 107,240
2021-04-02 2021-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 134 9,541 1.42
2021-01-05 2020-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 133 9,399 1.44
2021-01-05 2020-11-19 4 ECL ECOLAB INC.
Common Stock
G - Gift 425 709 149.65
2021-01-05 2020-11-12 4 ECL ECOLAB INC.
Common Stock
G - Gift 175 284 160.55
2020-10-02 2020-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 144 8,550 1.71
2020-08-10 2020-08-06 4 ECL ECOLAB INC.
Common Stock
P - Purchase 400 8,398 5.00 194.05 77,621 1,629,667
2020-07-02 2020-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 133 7,998 1.69
2020-05-08 2020-05-07 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 1,417 1,417
2020-04-02 2020-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 198 7,857 2.58
2020-01-03 2019-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 150 7,651 2.00
2019-11-01 2019-10-31 4 ECL ECOLAB INC.
Common Stock
J - Other 3,790 7,495 102.29 193.06 731,678 1,446,947
2019-10-02 2019-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 145 3,705 4.07
2019-10-02 2019-07-05 4 ECL ECOLAB INC.
Common Stock
G - Gift 710 3,554 24.97
2019-07-02 2019-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 148 2,844 5.47
2019-05-03 2019-05-02 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 1,281 1,281
2019-04-02 2019-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 163 2,690 6.46
2019-03-08 2019-03-06 4 ECL ECOLAB INC.
Common Stock
P - Purchase 1,000 3,500 40.00 171.05 171,050 598,675
2019-01-03 2018-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 197 2,519 8.48
2018-10-02 2018-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 184 2,317 8.60
2018-08-03 2018-08-02 4 ECL ECOLAB INC.
Common Stock
P - Purchase 500 2,500 25.00 146.40 73,198 365,988
2018-07-03 2018-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 204 2,128 10.60
2018-05-04 2018-05-03 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 1,800 1,800
2018-04-03 2018-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 211 1,919 12.34
2018-01-03 2017-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 185 1,703 12.21
2017-11-08 2017-11-06 4 ECL ECOLAB INC.
Common Stock
P - Purchase 450 2,000 29.03 131.77 59,298 263,548
2017-10-03 2017-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 194 1,514 14.66
2017-07-05 2017-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 189 1,318 16.71
2017-07-05 2017-06-27 4 ECL ECOLAB INC.
Common Stock
G - Gift 750 1,550 93.75
2017-07-05 2017-06-27 4 ECL ECOLAB INC.
Common Stock
G - Gift -750 1,126 -39.97
2017-05-05 2017-05-04 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 2,000 2,000
2017-04-04 2017-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 199 1,126 21.53
2017-02-28 2017-02-24 4 ECL ECOLAB INC.
Common Stock
P - Purchase 800 800 124.94 99,952 99,952
2017-01-04 2016-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 213 925 29.86
2016-10-04 2016-09-30 4 ECL ECOLAB INC.
Common Stock
A - Award 206 710 40.83
2016-07-01 2016-06-30 4 ECL ECOLAB INC.
Common Stock
A - Award 212 504 72.86
2016-05-06 2016-05-05 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 1,000 1,000
2016-05-06 2016-05-05 4 ECL ECOLAB INC.
Non-Employee Director Stock Option (Right to Buy)
A - Award 2,300 2,300
2016-04-01 2016-03-31 4 ECL ECOLAB INC.
Common Stock
A - Award 223 291 325.82
2016-01-05 2015-12-31 4 ECL ECOLAB INC.
Common Stock
A - Award 68 68
2015-12-04 3 ECL ECOLAB INC.
Common Stock
10,185
2015-12-04 3 ECL ECOLAB INC.
Common Stock
6,435
2015-12-04 3 ECL ECOLAB INC.
Common Stock
6,120
2015-12-04 3 ECL ECOLAB INC.
Common Stock
10,185
2015-12-04 3 ECL ECOLAB INC.
Common Stock
6,435
2015-12-04 3 ECL ECOLAB INC.
Common Stock
6,120
2015-12-04 3/A ECL ECOLAB INC.
Common Stock
4,500
2015-12-04 3/A ECL ECOLAB INC.
Common Stock
750
2015-12-04 3/A ECL ECOLAB INC.
Common Stock
435
2015-04-02 2015-03-31 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 580 7,471 8.42
2015-01-05 2014-12-31 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 150 6,891 2.23 74.89 11,234 516,067
2014-10-02 2014-09-30 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 922 6,741 15.84
2014-07-02 2014-06-30 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 176 5,819 3.12 63.79 11,227 371,194
2014-05-06 2014-05-02 4 CHRW C H ROBINSON WORLDWIDE INC
Common Stock
P - Purchase 400 1,600 33.33 58.84 23,534 94,138
2014-04-02 2014-03-31 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 214 5,643 3.94 52.39 11,211 295,637
2014-01-03 2013-12-31 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 192 5,429 3.67 58.35 11,203 316,782
2013-10-02 2013-09-30 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 1,027 5,237 24.39
2013-07-02 2013-06-28 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 199 4,210 4.96 56.31 11,206 237,065
2013-05-15 2013-05-13 4 CHRW C H ROBINSON WORLDWIDE INC
Common Stock
P - Purchase 250 1,200 26.32 56.38 14,096 67,662
2013-04-02 2013-03-29 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 189 4,011 4.95 59.46 11,238 238,494
2013-04-02 2013-02-11 4/A CHRW C H ROBINSON WORLDWIDE INC
Common Stock
P - Purchase 350 950 58.33 59.37 20,778 56,399
2013-02-13 2013-02-11 4 CHRW C H ROBINSON WORLDWIDE INC
Common Stock
P - Purchase 350 650 116.67 59.37 20,778 38,589
2013-01-03 2012-12-31 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 177 3,822 4.86 63.22 11,190 241,627
2012-10-02 2012-09-28 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 1,045 3,645 40.19
2012-07-03 2012-06-29 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Restricted Stock Units)
A - Award 192 2,600 7.97 58.53 11,238 152,178
2012-04-03 2012-03-30 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Director Units)
A - Award 171 2,408 7.64 65.49 11,199 157,700
2012-02-14 2012-02-10 4 CHRW C H ROBINSON WORLDWIDE INC
Common Stock
P - Purchase 300 600 100.00 63.42 19,028 38,055
2012-01-03 2011-12-30 4 CHRW C H ROBINSON WORLDWIDE INC
Phantom Stock (Director Units)
A - Award 152 2,237 7.29 69.78 10,607 156,098
2010-08-10 3 CHRW C H ROBINSON WORLDWIDE INC
Common Stock
300
P
Open market or private purchase of non-derivative or derivative security
S
Open market or private sale of non-derivative or derivative security
A
Grant, award, or other acquisition of securities from the company (such as an option)
C
Conversion of derivative
D
Sale or transfer of securities back to the company
F
Payment of exercise price or tax liability using portion of securities received from the company
G
Gift of securities by or to the insider
K
Equity swaps and similar hedging transactions
M
Exercise or conversion of derivative security received from the company (such as an option)
V
A transaction voluntarily reported on Form 4
J
Other (accompanied by a footnote describing the transaction)