Reported relationships
Latest disclosed role at each company.
| Company | Last reported as | Report date | Published |
|---|---|---|---|
| SHERWIN WILLIAMS COSHW · Entity 2948 | President, The Americas Group | December 04, 2017 | December 06, 2017 |
Disclosed balances
About these balances
Latest available filing per company, not a reconstructed current portfolio. Matching sequences show the last reported balance with all source rows expandable; grouping alone does not establish account ownership. Do not add unresolved positions together. Filings may omit unchanged positions, and amendments may correct only part of an older disclosure. Jointly reported shares are not necessarily this owner's personal holdings.
SHERWIN WILLIAMS CO
Report date December 04, 2017 · Filed December 06, 2017
| Security / award | Ownership account | Disclosed shares / units | Disclosure context |
|---|---|---|---|
| Common StockSEC Table I · non-derivative | Direct | 5,012 |
Reported balance
After 2017-12-04 transaction · row 1
Account or security details depend on footnotes; rows are not merged.
1 source rowRow 1 · 2017-12-04 · Sale · Disposed 1,000 · Balance 5,012 F1: The price reported in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $407.08 to $407.13 inclusive. The reporting person undertakes to provide to The Sherwin-Williams Company, any security holder of The Sherwin-Williams Company, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote to this Form 4. F2: Of shares listed, 3,150 are restricted stock units. |
| Common StockSEC Table I · non-derivative | IndirectStock Plan | 8,566.81 |
Reported balance
Holding disclosure · report date 2017-12-04 · row 2
Holding and transaction disclosures are not merged.
1 source rowRow 2 · Balance 8,566.81 F3: Represents the number of shares of common stock attributable to the reporting person's participation in The Sherwin-Williams Company Employee Stock Purchase and Savings Plan per the trustee's 9/30/2017 statement. |
| Common StockSEC Table I · non-derivative | IndirectBy daughter | 250 |
Reported balance
Holding disclosure · report date 2017-12-04 · row 3
Holding and transaction disclosures are not merged.
1 source rowRow 3 · Balance 250 F4: The reporting person disclaims beneficial ownership of the shares held by his daughter. |
Filing footnotes · ownership attribution and instrument terms
F1: The price reported in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $407.08 to $407.13 inclusive. The reporting person undertakes to provide to The Sherwin-Williams Company, any security holder of The Sherwin-Williams Company, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote to this Form 4.
F2: Of shares listed, 3,150 are restricted stock units.
F3: Represents the number of shares of common stock attributable to the reporting person's participation in The Sherwin-Williams Company Employee Stock Purchase and Savings Plan per the trustee's 9/30/2017 statement.
F4: The reporting person disclaims beneficial ownership of the shares held by his daughter.
Transaction history
JSON APIPurchases/sales include open-market and private transactions. Plan disclosure applies to the filing; individual rows may differ. “Not disclosed” is not “unplanned.”
The cutoff filters transaction history only. Company summaries and owner relationships show the latest available disclosures. Parser corrections can improve historical records.
| Transaction date | Company | Activity / security | Shares / units | Reported price | Reported value | Details |
|---|---|---|---|---|---|---|
| December 04, 2017 Filed Dec 6, 2017 18:53 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | SaleCommon Stock | 1,000 | $407.11 | $407,110.00 |
DisclosureSEC source: 0001209191-17-064151 · doc4.xml · nonDerivative · entry 1 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 5,012 F1 · price: The price reported in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $407.08 to $407.13 inclusive. The reporting person undertakes to provide to The Sherwin-Williams Company, any security holder of The Sherwin-Williams Company, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote to this Form 4. F2 · balance_after: Of shares listed, 3,150 are restricted stock units. Read SEC document |
| November 22, 2017 Filed Nov 27, 2017 19:40 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 2,933 | $0.00 Strike: $227.73 | $0.00 |
DisclosureSEC source: 0001209191-17-062545 · doc4.xml · derivative · entry 8 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 0 Underlying: Common Stock · 2,933 shares Expires 2024-10-21 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| November 22, 2017 Filed Nov 27, 2017 19:40 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 2,933 | $0.00 Strike: $227.73 | $0.00 |
DisclosureSEC source: 0001209191-17-062545 · doc4.xml · derivative · entry 7 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 0 Underlying: Common Stock · 2,933 shares Expires 2024-10-21 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| November 22, 2017 Filed Nov 27, 2017 19:40 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 2,934 | $0.00 Strike: $227.73 | $0.00 |
DisclosureSEC source: 0001209191-17-062545 · doc4.xml · derivative · entry 6 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 0 Underlying: Common Stock · 2,934 shares Expires 2024-10-21 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| November 22, 2017 Filed Nov 27, 2017 19:40 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | SaleCommon Stock | 3,500 | $389.57 | $1,363,495.00 |
DisclosureSEC source: 0001209191-17-062545 · doc4.xml · nonDerivative · entry 3 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 6,012 F2 · price: The price reported in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $389.00 to $389.98 inclusive. The reporting person undertakes to provide to The Sherwin-Williams Company, any security holder of The Sherwin-Williams Company, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote to this Form 4. Read SEC document |
| November 22, 2017 Filed Nov 27, 2017 19:40 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | SaleCommon Stock | 5,300 | $390.40 | $2,069,120.00 |
DisclosureSEC source: 0001209191-17-062545 · doc4.xml · nonDerivative · entry 2 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 9,512 F1 · price: The price reported in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $390.00 to $390.76 inclusive. The reporting person undertakes to provide to The Sherwin-Williams Company, any security holder of The Sherwin-Williams Company, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote to this Form 4. Read SEC document |
| November 22, 2017 Filed Nov 27, 2017 19:40 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionCommon Stock | 8,800 | $227.73 | $2,004,024.00 |
DisclosureSEC source: 0001209191-17-062545 · doc4.xml · nonDerivative · entry 1 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 14,812 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| October 18, 2017 Filed Oct 19, 2017 19:13 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | GrantEmployee Stock Option (Right to Buy) · Derivative | 9,600 | $0.00 Strike: $383.92 | $0.00 |
DisclosureSEC source: 0001209191-17-057441 · doc4.xml · derivative · entry 1 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 9,600 Underlying: Common Stock · 9,600 shares Expires 2027-10-17 F1 · derivative.exercise_date: The option vests in three equal annual installments beginning on October 18, 2018. Read SEC document |
| May 04, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 2,946 | $0.00 Strike: $180.46 | $0.00 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · derivative · entry 11 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 0 Underlying: Common Stock · 2,946 shares Expires 2023-10-15 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| May 04, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 3,500 | $0.00 Strike: $180.46 | $0.00 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · derivative · entry 10 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 0 Underlying: Common Stock · 3,500 shares Expires 2023-10-15 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| May 04, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 2,900 | $0.00 Strike: $180.46 | $0.00 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · derivative · entry 9 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 0 Underlying: Common Stock · 2,900 shares Expires 2023-10-15 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| May 04, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | SaleCommon Stock | 9,346 | $335.00 | $3,130,910.00 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · nonDerivative · entry 4 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 6,012 F2 · balance_after: Of shares listed, 3,150 are restricted stock units. Read SEC document |
| May 04, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionCommon Stock | 9,346 | $180.46 | $1,686,579.16 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · nonDerivative · entry 3 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 15,358 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| May 03, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 554 | $0.00 Strike: $180.46 | $0.00 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · derivative · entry 8 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 2,946 Underlying: Common Stock · 554 shares Expires 2023-10-15 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| May 03, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 600 | $0.00 Strike: $180.46 | $0.00 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · derivative · entry 7 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 2,900 Underlying: Common Stock · 600 shares Expires 2023-10-15 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| May 03, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | SaleCommon Stock | 1,154 | $335.00 | $386,590.00 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · nonDerivative · entry 2 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 6,012 F1 · price: The price reported in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $335.00 to $335.02 inclusive. The reporting person undertakes to provide to The Sherwin-Williams Company, any security holder of The Sherwin-Williams Company, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote to this Form 4. Read SEC document |
| May 03, 2017 Filed May 5, 2017 18:55 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionCommon Stock | 1,154 | $180.46 | $208,250.84 |
DisclosureSEC source: 0001209191-17-030261 · doc4.xml · nonDerivative · entry 1 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 7,166 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| February 17, 2017 Filed Feb 22, 2017 13:10 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Tax withholdingCommon Stock | 2,638 | $311.37 | $821,394.06 |
DisclosureSEC source: 0001209191-17-013014 · doc4.xml · nonDerivative · entry 1 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 6,012 F1 · balance_after: Of shares listed, 3,150 are restricted stock units. Read SEC document |
| January 27, 2017 Filed Jan 31, 2017 13:13 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionEmployee Stock Option (Right to Buy) · Derivative | 5,000 | $0.00 Strike: $154.43 | $0.00 |
DisclosureSEC source: 0001209191-17-006270 · doc4.xml · derivative · entry 5 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 0 Underlying: Common Stock · 5,000 shares Expires 2022-10-16 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| January 27, 2017 Filed Jan 31, 2017 13:13 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | SaleCommon Stock | 5,000 | $306.69 | $1,533,450.00 |
DisclosureSEC source: 0001209191-17-006270 · doc4.xml · nonDerivative · entry 2 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 8,650 F1 · price: The price reported in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $306.26 to $306.75 inclusive. The reporting person undertakes to provide to The Sherwin-Williams Company, any security holder of The Sherwin-Williams Company, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote to this Form 4. F2 · balance_after: Of shares listed, 5,500 are restricted stock and 3,150 are restricted stock units. Read SEC document |
| January 27, 2017 Filed Jan 31, 2017 13:13 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | Exercise / conversionCommon Stock | 5,000 | $154.43 | $772,162.50 |
DisclosureSEC source: 0001209191-17-006270 · doc4.xml · nonDerivative · entry 1 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 13,650 Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event. Read SEC document |
| October 18, 2016 Filed Oct 20, 2016 14:52 UTC | SHERWIN WILLIAMS CO SHW · Entity 2948 | GrantEmployee Stock Option (Right to Buy) · Derivative | 11,200 | $0.00 Strike: $270.12 | $0.00 |
DisclosureSEC source: 0001209191-16-146438 · doc4.xml · derivative · entry 1 Davisson Robert J · CIK 0001504881 · President, The Americas Group 10b5-1 filing: Not disclosed Ownership: Direct Disclosed balance after: 11,200 Underlying: Common Stock · 11,200 shares Expires 2026-10-17 F1 · derivative.exercise_date: The option vests in three annual installments of 3,734, 3,733 and 3,733 beginning on October 18, 2017. Read SEC document |
Value uses the disclosed total when available, otherwise shares × reported transaction price. It is not an estimate of exercise cash cost or investment performance.