undamentalytics Newsletter

Capossela Christopher C: insider trades

Officer at Microsoft Corporation. No open-market purchases and 46 sales not made under a pre-set plan, reported from December 5, 2014 to May 19, 2023.

What happened after Capossela Christopher C’s sales?

After their sales, the shares moved +22.6% against the index over 12 months on average (a negative figure means selling was the right call); 2% 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

Capossela Christopher C: 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 46 +4.1% +4.6% 33% 10 0.97 0.36 No reliable evidence
Sales, 12 months after the report 46 +22.6% +21.4% 2% 10 6.42 <0.001 Strong evidence: seller wrong
Sales, 12 months after the trade 46 +22.1% +21.4% 2% 10 5.63 <0.001 Strong evidence: seller wrong

“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
Microsoft Corporation MSFT EVP, Chief Marketing Officer046December 5, 2014May 19, 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
May 19, 2023May 18, 2023 MSFT Sale $1,584,350 −4.4%+6.7%+6.3%
May 17, 2023May 16, 2023 MSFT Sale $1,588,016 −4.9%+6.3%+5.7%
May 10, 2023May 9, 2023 MSFT Sale $2,850,575 −4.8%+6.3%+7.0%
May 8, 2023May 5, 2023 MSFT Sale $1,550,250 −3.7%+7.0%+5.7%
February 15, 2023February 13, 2023 MSFT Sale $272,320 +18.7%+31.4%+29.9%
February 13, 2023February 9, 2023 MSFT Sale $269,380 +15.0%+27.5%+34.0%
September 13, 2022September 12, 2022 MSFT Sale $1,331,250 −0.1%+17.6%+16.8%
September 13, 2021September 10, 2021 MSFT Sale $2,988,200 +8.0%−5.3%−2.6%
May 14, 2021May 12, 2021 MSFT Sale $951,140 +12.5%+10.0%+11.8%
May 10, 2021May 7, 2021 MSFT Sale $1,537,689 +9.4%+12.7%+11.0%
September 11, 2020September 9, 2020 MSFT Sale $6,294,060 −4.6%+14.1%+7.9%
November 7, 2019November 6, 2019 MSFT Sale $1,445,800 +17.7%+34.3%+40.5%
November 5, 2019November 4, 2019 MSFT Sale $722,925 +19.4%+40.5%+33.0%
October 30, 2019October 29, 2019 MSFT Sale $1,437,325 +14.7%+33.1%+33.7%
September 11, 2019September 10, 2019 MSFT Sale $1,220,220 +5.8%+37.0%+40.8%
September 6, 2019September 5, 2019 MSFT Sale $2,588,600 +4.6%+35.1%+38.6%
September 5, 2019September 5, 2019 MSFT Sale $1,742,000 +3.0%+38.5%+38.6%
August 14, 2019August 13, 2019 MSFT Sale $967,050 +1.1%+37.0%+35.1%
August 12, 2019August 8, 2019 MSFT Sale $483,000 −0.1%+35.1%+38.6%
August 5, 2019August 1, 2019 MSFT Sale $465,538 +0.4%+42.3%+37.4%
May 15, 2019May 14, 2019 MSFT Sale $630,100 +4.6%+41.9%+44.6%
May 7, 2019May 3, 2019 MSFT Sale $386,610 +7.5%+46.1%+42.2%
March 11, 2019March 8, 2019 MSFT Sale $1,170,555 +12.9%+37.0%+36.3%
December 11, 2018December 10, 2018 MSFT Sale $422,000 −0.3%+20.7%+21.5%
December 7, 2018December 6, 2018 MSFT Sale $432,000 −0.3%+21.5%+22.0%
December 4, 2018December 3, 2018 MSFT Sale $1,117,700 0.0%+22.0%+21.9%
September 10, 2018September 7, 2018 MSFT Sale $6,431,581 +6.2%+19.3%+22.0%
June 8, 2018June 7, 2018 MSFT Sale $1,009,900 +4.8%+26.7%+27.4%
February 26, 2018February 23, 2018 MSFT Sale $325,500 +6.1%+17.5%+17.9%
February 21, 2018February 20, 2018 MSFT Sale $325,500 +6.5%+18.4%+15.8%
February 20, 2018February 16, 2018 MSFT Sale $279,900 +5.7%+18.0%+14.6%
November 21, 2017November 20, 2017 MSFT Sale $333,770 +7.8%+23.0%+21.3%
November 15, 2017November 14, 2017 MSFT Sale $333,920 +6.5%+24.6%+20.9%
November 13, 2017November 10, 2017 MSFT Sale $333,840 +4.8%+20.9%+22.2%
May 25, 2017May 24, 2017 MSFT Sale $338,701 +3.0%+29.4%+30.2%
May 17, 2017May 16, 2017 MSFT Sale $207,330 +4.3%+28.3%+27.1%
November 14, 2016November 11, 2016 MSFT Sale $1,088,561 +2.1%+24.2%+23.9%
November 9, 2016November 8, 2016 MSFT Sale $726,120 +3.1%+24.9%+19.7%
November 3, 2016November 2, 2016 MSFT Sale $714,840 −1.7%+20.7%+19.5%
May 20, 2016May 20, 2016 MSFT Sale $271,600 +8.9%+21.3%+19.6%
May 19, 2016May 18, 2016 MSFT Sale $301,830 +7.6%+19.6%+18.7%
February 12, 2016February 11, 2016 MSFT Sale $502,350 −8.1%+3.9%+3.0%
February 10, 2016February 9, 2016 MSFT Sale $250,000 −9.1%+3.0%+5.8%
October 29, 2015October 28, 2015 MSFT Sale $1,554,110 +9.4%+12.5%+10.2%
May 4, 2015May 1, 2015 MSFT Sale $218,464 −0.2%+7.4%+6.0%
December 5, 2014December 4, 2014 MSFT Sale $979,600 −10.9%+18.0%+14.6%

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