Introduction

This page provides a comprehensive analysis of the known insider trading history of Frank H Brod. 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 Frank H Brod has reported holdings or trades in the following companies:

Security Title Latest Reported Holdings
US:MSFT / Microsoft Corporation Chief Accounting Officer 55,904
How to Interpret the Charts

The following charts show the stock performance of securities subsequent to each open-market, non-planned trade made by Frank H Brod. 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 Frank H Brod 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
2020-06-03 2020-06-01 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -1,232 55,904 -2.16 183.25 -225,764 10,244,408
2020-05-04 2020-05-01 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -3,000 57,136 -4.99 176.94 -530,811 10,109,472
2020-03-04 2020-03-03 4 MSFT MICROSOFT CORP
Common Stock
S - Sale X -5,000 60,136 -7.68 173.80 -869,000 10,451,637
2020-03-04 2020-03-02 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -3,553 65,136 -5.17 162.01 -575,622 10,552,683
2019-12-02 2019-12-02 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -1,591 68,689 -2.26 151.38 -240,846 10,398,141
2019-09-19 2019-09-18 4 MSFT MICROSOFT CORP
Common Stock
A - Award 6,656 70,280 10.46
2019-09-19 2019-09-18 4 MSFT MICROSOFT CORP
Common Stock
A - Award 9,318 63,624 17.16
2019-09-05 2019-09-04 4 MSFT MICROSOFT CORP
Common Stock
S - Sale X -4,000 54,306 -6.86 137.17 -548,680 7,449,154
2019-09-04 2019-09-03 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -5,357 58,306 -8.41 137.86 -738,516 8,038,065
2019-08-30 2019-08-29 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -489 63,663 -0.76 135.56 -66,289 8,630,156
2019-07-30 2019-07-29 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -4,000 64,152 -5.87 141.05 -564,216 9,048,896
2019-06-04 2019-05-31 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -873 68,152 -1.26 125.73 -109,762 8,568,751
2019-03-01 2019-02-28 4 MSFT MICROSOFT CORP
Common Stock
S - Sale X -7,220 45,849 -13.60 112.76 -814,127 5,169,933
2019-03-01 2019-02-28 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -6,174 53,069 -10.42 112.17 -692,538 5,952,750
2018-11-30 2018-11-30 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -914 59,243 -1.52 110.19 -100,714 6,527,986
2018-11-06 2018-11-05 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -2,000 64,676 -3.00 107.18 -214,363 6,932,071
2018-11-01 2018-10-31 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -20,000 66,676 -23.07 107.70 -2,153,900 7,180,672
2018-09-19 2018-09-17 4 MSFT MICROSOFT CORP
Common Stock
A - Award 8,168 86,676 10.40
2018-09-19 2018-09-17 4 MSFT MICROSOFT CORP
Common Stock
A - Award 11,436 78,508 17.05
2018-09-05 2018-08-31 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -5,433 67,072 -7.49 111.95 -608,224 7,508,710
2018-08-31 2018-08-30 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -1,291 72,505 -1.75 112.02 -144,618 8,122,010
2018-08-30 2018-08-29 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -1,982 73,796 -2.62 110.26 -218,535 8,136,747
2018-06-01 2018-05-31 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -387 75,778 -0.51 98.95 -38,294 7,498,233
2018-03-01 2018-02-28 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -6,215 76,165 -7.54 94.20 -585,453 7,174,743
2017-12-06 2017-12-04 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -18,000 82,380 -17.93 83.15 -1,496,759 6,850,169
2017-12-06 2017-08-31 4/A MSFT MICROSOFT CORP
Common Stock
F - Taxes -6,617 83,884 -7.31 74.01 -489,724 6,208,255
2017-12-06 2017-08-30 4/A MSFT MICROSOFT CORP
Common Stock
F - Taxes -2,507 102,296 -2.39 73.05 -183,136 7,472,723
2017-11-30 2017-11-30 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -412 115,793 -0.35 83.34 -34,336 9,650,189
2017-11-03 2017-11-02 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -15,000 116,205 -11.43 84.08 -1,261,200 9,770,516
2017-09-20 2017-09-18 4 MSFT MICROSOFT CORP
Common Stock
A - Award 12,271 131,205 10.32
2017-09-20 2017-09-18 4 MSFT MICROSOFT CORP
Common Stock
A - Award 19,634 118,934 19.77
2017-08-31 2017-08-31 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -2,996 99,300 -2.93 74.01 -221,734 7,349,193
2017-08-31 2017-08-30 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -2,507 102,296 -2.39 73.05 -183,136 7,472,723
2017-08-30 2017-08-29 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -2,113 104,803 -1.98 72.83 -153,890 7,632,802
2017-06-20 2017-06-19 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -975 106,916 -0.90 70.00 -68,250 7,484,120
2017-03-01 2017-02-28 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -6,117 107,891 -5.37 64.23 -392,895 6,929,839
2017-01-31 2017-01-30 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -7,500 114,008 -6.17 65.35 -490,125 7,450,423
2016-10-28 2016-10-27 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -5,000 121,508 -3.95 60.52 -302,625 7,354,272
2016-09-21 2016-09-19 4 MSFT MICROSOFT CORP
Common Stock
A - Award 23,495 126,508 22.81
2016-09-21 2016-09-19 4 MSFT MICROSOFT CORP
Common Stock
A - Award 12,661 103,013 14.01
2016-09-01 2016-08-31 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -7,724 90,352 -7.88 57.89 -447,142 5,230,477
2016-08-30 2016-08-30 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -2,507 98,076 -2.49 58.10 -145,657 5,698,216
2016-08-30 2016-08-29 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -2,114 100,583 -2.06 58.03 -122,675 5,836,831
2016-06-17 2016-06-17 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -974 102,697 -0.94 50.39 -49,080 5,174,902
2016-04-29 2016-04-26 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -7,000 103,671 -6.33 51.38 -359,686 5,327,000
2016-03-01 2016-02-29 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -3,218 110,671 -2.83 51.30 -165,083 5,677,422
2016-02-02 2016-02-01 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -4,000 113,889 -3.39 54.85 -219,416 6,247,267
2015-10-28 2015-10-27 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -20,000 117,889 -14.50 53.51 -1,070,200 6,308,240
2015-09-01 2015-08-31 4 MSFT MICROSOFT CORP
Common Stock
A - Award 31,021 137,889 29.03
2015-09-01 2015-08-31 4 MSFT MICROSOFT CORP
Common Stock
A - Award 16,717 106,868 18.54
2015-09-01 2015-08-31 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -12,674 90,151 -12.33 43.93 -556,769 3,960,333
2015-06-18 2015-06-17 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -636 102,825 -0.61 45.83 -29,148 4,712,470
2015-04-28 2015-04-27 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -4,500 103,461 -4.17 47.84 -215,294 4,949,885
2015-03-03 2015-02-28 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -1,747 107,961 -1.59 43.85 -76,606 4,734,090
2015-02-05 2015-02-04 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -6,000 109,708 -5.19 41.83 -250,980 4,589,086
2014-10-28 2014-10-27 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -22,000 115,708 -15.98 45.81 -1,007,908 5,301,046
2014-09-03 2014-09-03 4 MSFT MICROSOFT CORP
Common Stock
A - Award 29,717 137,708 27.52
2014-09-03 2014-09-03 4 MSFT MICROSOFT CORP
Common Stock
A - Award 13,208 107,991 13.93
2014-09-03 2014-09-02 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -15,803 94,783 -14.29 45.43 -717,930 4,305,992
2014-07-29 2014-07-28 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -1,500 110,586 -1.34 44.04 -66,052 4,869,655
2014-06-18 2014-06-17 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -635 112,721 -0.56 41.50 -26,352 4,677,922
2014-04-29 2014-04-28 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -6,000 112,721 -5.05 40.12 -240,720 4,522,367
2014-03-04 2014-02-28 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -664 118,721 -0.56 37.86 -25,139 4,494,777
2014-01-29 2014-01-28 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -10,000 119,385 -7.73 36.10 -361,049 4,310,383
2013-10-29 2013-10-28 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -20,000 129,385 -13.39 35.45 -709,026 4,586,866
2013-09-23 2013-09-19 4 MSFT MICROSOFT CORP
Common Stock
A - Award 21,557 149,385 16.86
2013-09-23 2013-09-19 4 MSFT MICROSOFT CORP
Common Stock
A - Award 9,286 127,828 7.83
2013-09-23 2013-09-19 4 MSFT MICROSOFT CORP
Common Stock
A - Award 16,393 118,542 16.05
2013-09-04 2013-09-03 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -15,634 102,149 -13.27 33.40 -522,176 3,411,777
2013-08-30 2013-08-29 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -903 117,783 -0.76 33.02 -29,817 3,889,195
2013-04-23 2013-04-22 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -10,000 118,686 -7.77 30.88 -308,779 3,664,774
2013-01-30 2013-01-28 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -10,000 128,686 -7.21 28.04 -280,417 3,608,574
2012-10-02 2012-10-01 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -912 138,686 -0.65 29.76 -27,141 4,127,295
2012-09-05 2012-09-04 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -15,000 139,598 -9.70 30.41 -456,128 4,244,966
2012-09-05 2012-08-31 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -13,304 154,598 -7.92 30.32 -403,377 4,687,411
2012-09-05 2012-08-31 4 MSFT MICROSOFT CORP
Common Stock
A - Award 18,657 186,559 11.11
2012-09-05 2012-08-31 4 MSFT MICROSOFT CORP
Common Stock
A - Award 15,396 167,902 10.10
2012-09-05 2012-08-31 4 MSFT MICROSOFT CORP
Common Stock
A - Award 10,000 152,506 7.02
2012-09-05 2012-08-31 4 MSFT MICROSOFT CORP
Common Stock
A - Award 22,698 142,506 18.95
2012-08-31 2012-08-29 4 MSFT MICROSOFT CORP
Common Stock
F - Taxes -873 119,808 -0.72 30.63 -26,740 3,669,719
2012-05-01 2012-04-30 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -5,000 120,681 -3.98 32.00 -160,025 3,862,395
2012-01-24 2012-01-23 4 MSFT MICROSOFT CORP
Common Stock
S - Sale -10,000 125,681 -7.37 29.75 -297,510 3,739,135
2006-05-05 3 MSFT MICROSOFT CORP
Common Stock
0
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)