Introduction

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

Security Title Latest Reported Holdings
US:HAS / Hasbro, Inc. EVP, Chief Strategy Officer 47,722
How to Interpret the Charts

The following charts show the stock performance of securities subsequent to each open-market, non-planned trade made by Duncan Billing. 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 Duncan Billing 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
2018-10-31 2017-02-21 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 2,418 47,722 5.34
2018-02-28 2018-02-27 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -5,212 5,212 -50.00
2018-02-28 2018-02-27 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -6,442 0 -100.00
2018-02-28 2018-02-27 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -2,968 45,304 -6.15 99.00 -293,832 4,485,080
2018-02-28 2018-02-27 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -11,654 48,272 -19.45 99.25 -1,156,660 4,790,980
2018-02-28 2018-02-27 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 5,212 59,926 9.53 74.42 387,877 4,459,681
2018-02-28 2018-02-27 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 6,442 54,714 13.35 61.77 397,922 3,379,674
2018-02-28 2018-02-26 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -7,356 48,272 -13.22 98.13 -721,844 4,736,916
2018-02-28 2018-02-26 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 17,542 55,628 46.06
2018-02-28 2018-02-20 4 HAS HASBRO INC
Option (Right to Buy)
A - Award 14,144 14,144
2018-02-28 2018-02-20 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 8,487 38,086 28.67
2018-02-27 2018-02-23 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -322 29,599 -1.08 96.85 -31,186 2,866,648
2018-02-23 2018-02-21 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -246 25,851 -0.94 98.92 -24,334 2,557,133
2018-02-13 2018-02-09 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -1,327 26,097 -4.84 97.01 -128,732 2,531,623
2017-08-02 2017-08-01 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -5,371 10,424 -34.00
2017-08-02 2017-08-01 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -4,495 6,442 -41.10
2017-08-02 2017-08-01 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -21,174 27,424 -43.57 106.47 -2,254,474 2,919,883
2017-08-02 2017-08-01 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -9,866 48,598 -16.88 106.08 -1,046,585 5,155,224
2017-08-02 2017-08-01 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 5,371 58,464 10.12 74.42 399,710 4,350,854
2017-08-02 2017-08-01 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 4,495 53,093 9.25 61.77 277,656 3,279,524
2017-08-02 2017-07-31 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -1,947 8,389 -18.84
2017-08-02 2017-07-31 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -6,833 0 -100.00
2017-08-02 2017-07-31 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -8,780 48,598 -15.30 106.00 -930,680 5,151,336
2017-08-02 2017-07-31 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 1,947 57,378 3.51 61.77 120,266 3,544,209
2017-08-02 2017-07-31 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 6,833 55,431 14.06 52.11 356,068 2,888,484
2017-02-27 2017-02-23 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -568 48,598 -1.16 97.96 -55,641 4,760,612
2017-02-23 2017-02-21 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -7,706 49,166 -13.55 98.80 -761,353 4,857,552
2017-02-23 2017-02-21 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 17,760 56,872 45.41
2017-02-15 2017-02-13 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -1,562 39,112 -3.84 98.38 -153,670 3,847,790
2017-02-07 2016-07-29 5 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -3,236 40,674 -7.37 87.21 -282,212 3,547,137
2017-02-07 2015-07-29 5 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -3,596 43,915 -7.57 80.11 -288,076 3,518,017
2016-11-16 2016-11-14 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -6,442 12,884 -33.33
2016-11-16 2016-11-14 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -10,227 0 -100.00
2016-11-16 2016-11-14 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -2,082 51,603 -3.88 85.00 -176,970 4,386,245
2016-11-16 2016-11-14 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -16,669 53,685 -23.69 87.00 -1,450,203 4,670,585
2016-11-16 2016-11-14 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 6,442 70,354 10.08 61.77 397,922 4,345,759
2016-11-16 2016-11-14 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 10,227 63,912 19.05 47.21 482,817 3,017,280
2016-08-01 2016-07-28 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -1,918 53,685 -3.45 80.65 -154,687 4,329,686
2016-05-31 2016-05-27 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -2,814 55,603 -4.82 87.28 -245,613 4,853,159
2016-05-31 2016-05-26 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -700 58,417 -1.18 87.25 -61,075 5,096,879
2016-04-25 2016-04-22 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -13,667 6,833 -66.67
2016-04-25 2016-04-22 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -20,455 10,227 -66.67
2016-04-25 2016-04-22 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -13,667 59,117 -18.78 87.50 -1,195,862 5,172,727
2016-04-25 2016-04-22 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale 20,455 72,784 39.09 87.25 1,784,699 6,350,394
2016-04-25 2016-04-22 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 13,667 93,229 17.18 52.11 712,187 4,858,157
2016-04-25 2016-04-22 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 20,455 79,562 34.61 47.21 965,681 3,756,117
2016-03-02 2016-02-29 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -5,700 59,117 -8.79 76.31 -434,956 4,511,097
2016-03-02 2016-02-29 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -5,172 64,817 -7.39 75.87 -392,393 4,917,579
2016-02-25 2016-02-23 4 HAS HASBRO INC
Option (Right to Buy)
A - Award 15,795 15,795
2016-02-25 2016-02-23 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -6,273 69,989 -8.23 74.42 -466,805 5,208,223
2016-02-25 2016-02-23 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 17,145 76,262 29.00
2016-02-25 2016-02-23 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 3,210 59,117 5.74
2015-10-02 2015-04-22 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
P - Purchase 152 51,828 0.29 77.19 11,733 4,000,586
2015-08-17 2015-08-13 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -3,904 51,676 -7.02 80.43 -313,997 4,156,257
2015-05-19 2015-05-15 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -21,667 0 -100.00
2015-05-19 2015-05-15 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -21,667 55,580 -28.05 72.25 -1,565,441 4,015,639
2015-05-19 2015-05-15 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 21,667 77,247 38.98 36.14 782,937 2,791,312
2015-02-13 2015-02-13 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -36,170 0 -100.00
2015-02-13 2015-02-13 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -36,170 55,580 -39.42 62.50 -2,260,625 3,473,736
2015-02-13 2015-02-13 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 36,170 91,750 65.08 45.66 1,651,522 4,189,295
2015-02-13 2015-02-11 4 HAS HASBRO INC
Option (Right to Buy)
A - Award 9,089 9,089
2015-02-13 2015-02-11 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 4,295 55,580 8.37
2014-03-04 2014-02-28 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -21,666 21,667 -50.00
2014-03-04 2014-02-28 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -21,666 51,285 -29.70 55.10 -1,193,797 2,825,791
2014-03-04 2014-02-28 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 21,666 72,951 42.25 36.14 783,009 2,636,441
2014-02-26 2014-02-24 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -3,245 51,285 -5.95 55.00 -178,475 2,820,662
2014-02-14 2014-02-12 4 HAS HASBRO INC
Option (Right to Buy)
A - Award 20,500 20,500
2014-02-14 2014-02-12 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 4,600 54,530 9.21
2013-11-14 2013-11-13 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise 21,667 43,333 100.00
2013-11-14 2013-11-13 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -21,667 49,934 -30.26 52.50 -1,137,518 2,621,555
2013-11-14 2013-11-13 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 21,667 71,601 43.39 36.14 782,937 2,587,316
2013-04-26 2013-04-24 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -47,302 0 -100.00
2013-04-26 2013-04-24 4 HAS HASBRO INC
Option (Right to Buy)
A - Award 30,682 30,682
2013-04-26 2013-04-24 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -47,302 49,934 -48.65 47.43 -2,243,435 2,368,283
2013-04-26 2013-04-24 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 47,302 97,241 94.72 31.62 1,495,926 3,075,239
2013-04-26 2013-04-24 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 6,750 49,939 15.63
2012-08-09 2012-08-08 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -20,502 0 -100.00
2012-08-09 2012-08-08 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -20,502 43,189 -32.19 37.00 -758,599 1,598,036
2012-08-09 2012-08-08 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 20,502 63,695 47.47 22.73 466,010 1,447,794
2012-05-07 2012-05-03 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -6,000 43,193 -12.20 37.00 -222,000 1,598,151
2012-04-30 2012-04-26 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -20,502 20,502 -50.00
2012-04-30 2012-04-26 4 HAS HASBRO INC
Option (Right to Buy)
M - Exercise -21,219 0 -100.00
2012-04-30 2012-04-26 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
S - Sale -41,721 49,193 -45.89 36.50 -1,522,816 1,795,555
2012-04-30 2012-04-26 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 20,502 90,914 29.12 22.73 466,010 2,066,481
2012-04-30 2012-04-26 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
M - Exercise 21,219 70,412 43.13 27.10 574,929 1,907,821
2012-02-23 2012-02-21 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
F - Taxes -3,672 49,193 -6.95 35.98 -132,100 1,769,728
2012-02-23 2012-02-21 4 HAS HASBRO INC
Common Stock (Par Value $.50 per share)
A - Award 11,186 52,865 26.84
2012-02-10 2012-02-08 4 HAS HASBRO INC
Option (Right to Buy)
A - Award 65,000 65,000
2008-02-13 3 HAS HASBRO INC
Common Stock (Par Value $.50)
8,116
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)