undamentalytics Newsletter

Allanson Joe: insider trades

Officer at Salesforce. No open-market purchases and 57 sales not made under a pre-set plan, reported from May 27, 2014 to July 23, 2021.

What happened after Allanson Joe’s sales?

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

Allanson Joe: 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 57 +3.1% +5.6% 37% 8 2.44 0.045 Some evidence: seller wrong
Sales, 12 months after the report 57 +7.5% +6.9% 37% 8 1.04 0.33 No reliable evidence
Sales, 12 months after the trade 57 +7.3% +7.6% 35% 8 1.03 0.34 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
Salesforce CRM Chief Accounting Officer057May 27, 2014July 23, 2021

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
July 23, 2021July 23, 2021 CRM Sale $37,976 +15.1%−21.0%−19.8%
June 24, 2021June 23, 2021 CRM Sale $75,871 +13.7%−17.4%−19.2%
April 23, 2021April 23, 2021 CRM Sale $143,231 −0.8%−29.8%−30.2%
March 23, 2021March 23, 2021 CRM Sale $48,589 +6.0%−15.3%−15.5%
December 23, 2020December 23, 2020 CRM Sale $71,790 −14.3%−16.7%−18.4%
November 23, 2020November 23, 2020 CRM Sale $42,977 −22.2%−20.2%−19.7%
September 23, 2020September 23, 2020 CRM Sale $57,782 −18.4%−18.9%−21.6%
August 24, 2020August 24, 2020 CRM Sale $24,039 +15.0%−11.7%−8.0%
June 23, 2020June 23, 2020 CRM Sale $41,793 +20.7%−10.5%−9.5%
May 26, 2020May 26, 2020 CRM Sale $20,698 +8.5%−10.2%−13.1%
March 23, 2020March 23, 2020 CRM Sale $72,867 −5.8%−25.6%−24.5%
December 23, 2019December 23, 2019 CRM Sale $27,395 +13.0%+22.8%+24.7%
November 25, 2019November 25, 2019 CRM Sale $52,510 +10.0%+34.2%+43.2%
September 23, 2019September 23, 2019 CRM Sale $25,730 −1.4%+44.0%+47.3%
August 23, 2019August 23, 2019 CRM Sale $50,249 −3.5%+17.4%+14.7%
June 24, 2019June 24, 2019 CRM Sale $25,852 −0.4%+17.6%+15.5%
May 23, 2019May 23, 2019 CRM Sale $50,211 −3.1%+6.3%+8.9%
March 26, 2019March 25, 2019 CRM Sale $106,453 −8.3%+4.4%+6.6%
February 25, 2019February 25, 2019 CRM Sale $52,206 −5.5%−3.9%−1.6%
November 26, 2018November 23, 2018 CRM Sale $73,681 +23.9%+6.8%+11.1%
August 24, 2018August 23, 2018 CRM Sale $47,555 −9.4%−1.6%+2.2%
May 29, 2018May 29, 2018 CRM Sale $34,479 +11.5%+14.2%+16.9%
May 23, 2018May 23, 2018 CRM Sale $40,682 +9.6%+15.9%+15.2%
February 23, 2018February 23, 2018 CRM Sale $36,424 +11.4%+37.5%+38.2%
November 27, 2017November 24, 2017 CRM Sale $113,968 +9.8%+25.7%+13.4%
August 28, 2017August 28, 2017 CRM Sale $35,391 +5.6%+43.7%+42.6%
August 23, 2017August 23, 2017 CRM Sale $11,035 +6.5%+41.7%+39.8%
May 30, 2017May 30, 2017 CRM Sale $15,708 +2.8%+29.9%+27.3%
May 26, 2017May 26, 2017 CRM Sale $18,715 +1.3%+27.3%+26.3%
February 27, 2017February 27, 2017 CRM Sale $33,488 +9.1%+25.8%+24.8%
February 23, 2017February 23, 2017 CRM Sale $11,275 +9.0%+23.0%+21.6%
November 28, 2016November 28, 2016 CRM Sale $95,742 +4.9%+20.6%+24.3%
November 23, 2016November 23, 2016 CRM Sale $48,697 +3.0%+24.7%+24.5%
August 29, 2016August 26, 2016 CRM Sale $75,370 −10.5%+3.7%+2.2%
June 1, 2016May 31, 2016 CRM Sale $47,094 −8.2%−9.0%−10.4%
May 31, 2016May 27, 2016 CRM Sale $14,430 −8.6%−10.2%−8.8%
May 27, 2016May 26, 2016 CRM Sale $17,275 −9.1%−10.4%−8.9%
March 1, 2016February 29, 2016 CRM Sale $51,388 +12.3%−4.9%−4.7%
February 29, 2016February 26, 2016 CRM Sale $16,560 +13.1%−3.9%−7.2%
November 30, 2015November 30, 2015 CRM Sale $62,468 −8.0%−18.0%−16.6%
November 27, 2015November 27, 2015 CRM Sale $110,353 −7.5%−16.6%−16.3%
November 24, 2015November 23, 2015 CRM Sale $40,395 −8.8%−16.4%−14.2%
August 28, 2015August 28, 2015 CRM Sale $54,802 +8.8%+2.4%+1.8%
August 27, 2015August 27, 2015 CRM Sale $16,678 +8.1%+1.8%+3.0%
August 25, 2015August 24, 2015 CRM Sale $34,116 +9.1%+2.6%+1.7%
May 28, 2015May 28, 2015 CRM Sale $57,305 +1.3%+13.4%+14.0%
May 27, 2015May 27, 2015 CRM Sale $17,374 +2.3%+14.0%+12.5%
May 27, 2015May 26, 2015 CRM Sale $29,071 +2.3%+14.0%+11.7%
March 3, 2015March 2, 2015 CRM Sale $37,738 +12.0%+12.1%+6.9%
February 27, 2015February 27, 2015 CRM Sale $12,304 +6.5%+6.9%+3.9%
February 24, 2015February 23, 2015 CRM Sale $26,384 +16.7%+16.1%+7.6%
December 1, 2014November 28, 2014 CRM Sale $101,518 +8.5%+33.8%+30.4%
November 25, 2014November 24, 2014 CRM Sale $36,659 +12.9%+32.1%+35.3%
August 28, 2014August 28, 2014 CRM Sale $33,204 −2.4%+17.0%+19.0%
August 26, 2014August 25, 2014 CRM Sale $37,628 −4.3%+15.9%+14.7%
May 29, 2014May 28, 2014 CRM Sale $30,352 +6.4%+26.9%+23.1%
May 27, 2014May 23, 2014 CRM Sale $33,586 +6.6%+23.1%+24.9%

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