Introduction

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

Security Title Latest Reported Holdings
US:NI / NiSource Inc. Director, and President & CEO, Director 556,988
How to Interpret the Charts

The following charts show the stock performance of securities subsequent to each open-market, non-planned trade made by Joseph Hamrock. 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 Joseph Hamrock 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
2021-09-08 2021-09-03 4 NI NISOURCE INC.
Common Stock
G - Gift -40,000 556,988 -6.70
2021-03-01 2021-02-26 4 NI NISOURCE INC.
Common Stock
F - Taxes -16,077 596,988 -2.62 21.60 -347,263 12,894,941
2021-03-01 2021-02-26 4 NI NISOURCE INC.
Common Stock
F - Taxes -31,778 613,065 -4.93 21.60 -686,405 13,242,204
2021-03-01 2021-02-26 4 NI NISOURCE INC.
Common Stock
A - Award 77,268 644,843 13.61 21.60 1,668,989 13,928,609
2021-02-01 2021-01-29 4 NI NISOURCE INC.
Common Stock
A - Award 43,342 567,575 8.27 22.15 960,025 12,571,786
2020-11-25 2020-11-24 4 NI NISOURCE INC.
Common Stock
G - Gift -22,000 524,233 -4.03
2020-03-03 2020-02-28 4 NI NISOURCE INC.
Common Stock
F - Taxes -60,819 546,233 -10.02 27.02 -1,643,329 14,759,216
2020-03-03 2020-02-28 4 NI NISOURCE INC.
Common Stock
A - Award 136,178 607,052 28.92 27.02 3,679,530 16,402,545
2020-02-03 2020-01-31 4 NI NISOURCE INC.
Common Stock
A - Award 30,024 470,874 6.81 29.31 880,003 13,801,317
2019-09-03 2019-08-30 4 NI NISOURCE INC.
Common Stock
G - Gift -17,100 440,850 -3.73
2019-03-01 2019-02-28 4 NI NISOURCE INC/DE
Common Stock
F - Taxes -59,196 457,950 -11.45 26.98 -1,597,108 12,355,491
2019-03-01 2019-02-28 4 NI NISOURCE INC/DE
Common Stock
A - Award 142,790 517,146 38.14 26.98 3,852,474 13,952,599
2019-02-04 2019-02-01 4 NI NISOURCE INC/DE
Common Stock
A - Award 32,102 374,356 9.38 26.79 860,013 10,028,997
2018-08-10 2018-08-08 4 NI NISOURCE INC/DE
Common Stock
G - Gift -16,663 342,254 -4.64
2018-01-29 2018-01-26 4 NI NISOURCE INC/DE
Common Stock
A - Award 35,102 358,649 10.85 24.50 859,999 8,786,900
2017-05-25 2017-05-24 4 NI NISOURCE INC/DE
Common Stock
G - Gift -19,825 578,504 -3.31
2017-01-30 2017-01-27 4 NI NISOURCE INC/DE
Common Stock
A - Award 136,178 598,074 29.48 22.03 3,000,001 13,175,570
2016-09-09 2016-09-08 4 NI NISOURCE INC/DE
Common Stock
G - Gift -8,375 461,896 -1.78
2016-03-02 2016-02-29 4 NI NISOURCE INC/DE
Common Stock
F - Taxes -5,422 470,271 -1.14 21.48 -116,465 10,101,421
2016-02-02 2016-01-29 4 NI NISOURCE INC/DE
Common Stock
A - Award 118,991 475,693 33.36 21.01 2,500,001 9,994,310
2015-07-15 2015-07-13 4 NI NISOURCE INC/DE
Common Stock
A - Award 58,858 356,702 19.76 16.99 999,997 6,060,367
2015-02-20 2015-02-18 4 NI NISOURCE INC/DE
Common Stock
F - Taxes -17,711 107,885 -14.10 43.91 -777,690 4,737,230
2015-02-20 2015-02-18 4 NI NISOURCE INC/DE
Common Stock
A - Award 19,825 125,596 18.74 43.91 870,516 5,514,920
2015-02-02 2015-01-29 4 NI NISOURCE INC/DE
Common Stock
A - Award 22,894 105,771 27.62 43.68 1,000,010 4,620,077
2014-05-05 2014-05-02 4 NI NISOURCE INC/DE
Common Stock
F - Taxes -2,656 82,877 -3.11 36.24 -96,253 3,003,462
2014-02-03 2014-01-30 4 NI NISOURCE INC/DE
Common Stock
A - Award 20,432 85,533 31.39 34.26 700,000 2,930,361
2013-05-06 2013-05-02 4 NI NISOURCE INC/DE
Common Stock
F - Taxes -5,311 65,101 -7.54 30.57 -162,357 1,990,138
2013-01-28 2013-01-24 4 NI NISOURCE INC/DE
Common Stock
A - Award 22,642 70,412 47.40 26.50 600,013 1,865,918
2012-05-16 2012-05-14 4 NI NISOURCE INC/DE
Common Stock
A - Award 47,770 47,770 25.12 1,199,982 1,199,982
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)