The Sherwin-Williams Company
US ˙ NYSE ˙ US8243481061

SecuritySHW / The Sherwin-Williams Company
InstitutionSimplex Trading, Llc
Latest Disclosed Ownership0 shares
Latest Disclosed Value $ 0
Simplex Trading, Llc ownership in SHW / The Sherwin-Williams Company

On July 25, 2024 - Simplex Trading, Llc filed a 13F-HR form disclosing ownership of 0 shares of The Sherwin-Williams Company (US:SHW) valued at $0 USD as of June 30, 2024. The entity filed a previous 13F-HR on April 25, 2024 disclosing 2,995 shares of The Sherwin-Williams Company. This represents a change in shares of -100.00% during the quarter. The current value of the position is $0 USD.

Simplex Trading, Llc has a history of taking positions in derivatives of the underlying security (SHW) in the form of stock options. The firm currently holds call options representing 4,700 of underlying shares valued at $1,506,585 USD and put options representing 3,000 of underlying shares valued at $961,650 USD .

Note: prior versions of this page mistakenly stated that the share values represented the number of options, not the number of underlying shares. For more information on the data backing these reports, please see the SEC document Frequently Asked Questions About Form 13F.

Institutional Ownership: 13F and NPORT Filings

The Security and Class in the table below are shown exactly as filed by the investor. We do our best to track continuity of investments through acquisitions, and this will be reflected in the table as changes in names. In addition to descriptive data, performance of the investment is shown over time. To calculate quarterly performance, we first calculate cost basis of the shares purchased during the quarter, then use that to calculate gross profit. Quarterly return is Gross Profit / Starting Portfolio value.

Note that cost basis is calculated and stored in thousands, so small quarterly changes in shares frequently result in a cost basis of zero.

Upgrade to unlock premium data and export to Excel .

Institutional Put/Call Ratios
(Premium Subscription Required)

In addition to reporting standard equity and debt issues, institutions with more than 100MM assets under management must also disclose their put and call option holdings. Since put options generally indicate negative sentiment, and call options indicate positive sentiment, we can get a sense of the overall institutional sentiment by plotting the ratio of puts to calls. The chart to the right plots the historical put/call ratio for this instrument.

Using Put/Call Ratio as an indicator of investor sentiment overcomes one of the key deficiencies of using total institutional ownership, which is that a significant amount of assets under management are invested passively to track indices. Passively-managed funds do not typically buy options, so the put/call ratio indicator more closely tracks the sentiment of actively-managed funds.

SHW / The Sherwin-Williams Company Historical Put/Call Ratio
Disclosed Equity Positions (from 13F/NPORT Filings)
File
Date
Effective
Date
Form Security Class ID Avg Price
Paid (Est)
Reported
Shares
ΔShares ΔShares
(%)
Reported
Value
(x1000)
ΔValue
(%)
Alloc
(%)
ΔAlloc ΔAlloc (%) Cost Basis
(x1000)
Unrealized
Gain/Loss
(x1000)
2024-07-25 2024-06-30 13F SHERWIN WILLIAMS COM 824348106 0 -2,995 -100.00 0 -100.00
2024-04-25 2024-03-31 13F SHERWIN WILLIAMS COM 824348106 2,995 -6,992 -70.01 1 -66.67 0.0006
2024-02-02 2023-12-31 13F SHERWIN WILLIAMS COM 824348106 9,987 9,987 3 0.0020
2022-11-04 2022-09-30 13F SHERWIN WILLIAMS COM 824348106 0 -75 -100.00 0 -100.00
2022-08-03 2022-06-30 13F SHERWIN WILLIAMS COM 824348106 75 75 16 0.0000
2022-05-02 2022-03-31 13F SHERWIN WILLIAMS COM 824348106 0 -8,419 -100.00 0 -100.00
2022-02-23 2021-12-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 8,419 -3,338 -28.39 2,964 -8.43 0.0030
2022-02-04 2021-12-31 13F SHERWIN WILLIAMS COM 824348106 11,757 0 3,237 0.0030
2021-10-28 2021-09-30 13F SHERWIN WILLIAMS COM 824348106 11,757 619 5.56 3,237 6.69 0.0030
2021-08-12 2021-06-30 13F SHERWIN WILLIAMS COM 824348106 11,138 5,024 82.17 3,034 -32.76 0.0029
2021-04-26 2021-03-31 13F SHERWIN WILLIAMS COM 824348106 6,114 4,812 369.59 4,512 371.97 0.0081
2021-02-02 2020-12-31 13F SHERWIN WILLIAMS COM 824348106 1,302 1,302 -78.70 956 -78.81 0.0012
2020-07-13 2020-06-30 13F SHERWIN WILLIAMS COM 824348106 0 -647 -100.00 0 -100.00
2020-04-29 2020-03-31 13F SHERWIN WILLIAMS COM 824348106 647 -21 -3.14 297 -23.65 0.0005
2020-02-05 2019-12-31 13F SHERWIN WILLIAMS COM 824348106 668 668 3.25 389 30.98 0.0009
2019-01-16 2018-12-31 13F SHERWIN WILLIAMS COM 824348106 0 -3,278 -100.00 0 -100.00
2018-10-23 2018-09-30 13F SHERWIN WILLIAMS COM 824348106 3,278 2,337 248.35 1,492 289.56 0.0048
2018-07-30 2018-06-30 13F SHERWIN WILLIAMS COM 824348106 941 -1,746 -64.98 383 -63.63 0.0015
2018-04-26 2018-03-31 13F SHERWIN WILLIAMS COM 824348106 2,687 2,687 185.55 1,053 174.93 0.0463
2017-10-25 2017-09-30 13F SHERWIN WILLIAMS COM 824348106 0 -2,325 -100.00 0 -100.00
2017-07-12 2017-06-30 13F SHERWIN WILLIAMS COM 824348106 2,325 148 6.80 815 20.74 0.0354
2017-04-21 2017-03-31 13F SHERWIN WILLIAMS COM 824348106 2,177 -3,326 -60.44 675 -54.33 0.0292
2017-01-11 2016-12-31 13F SHERWIN WILLIAMS COM 824348106 5,503 5,503 1,478 0.0883
2016-10-07 2016-09-30 13F SHERWIN WILLIAMS COM 824348106 0 -5 -100.00 0 -100.00
2016-07-18 2016-06-30 13F SHERWIN WILLIAMS COM 824348106 5 -3,091 -99.84 1 -99.89 0.0001
2016-04-14 2016-03-31 13F SHERWIN WILLIAMS COM 824348106 3,096 3,096 61,820.00 881 88,000.00 0.0702
2016-01-20 2015-12-31 13F SHERWIN WILLIAMS COM 824348106 0 -1,468 -100.00 0 -100.00
2015-10-08 2015-09-30 13F SHERWIN WILLIAMS COM 824348106 1,468 -139 -8.65 327 -25.85 0.0240
2015-07-08 2015-06-30 13F SHERWIN WILLIAMS COM 824348106 1,607 363 29.18 441 24.93 0.0370
2015-04-21 2015-03-31 13F SHERWIN WILLIAMS COM 824348106 1,244 1,244 353 0.0411
Disclosed Call Options
File
Date
Effective
Date
Form Security Class ID Opt Avg Share
Price
Shares ΔShares
(%)
Value
(x1000)
ΔValue
(%)
Prior Allocation
(%)
Allocation
(%)
ΔAllocation
(%)
Cost Basis
(x1000)
Profit
(x1000)
Return
(%)
2026-05-14 2026-03-31 13F SHERWIN WILLIAMS CALL Call 4,700 -64.66 1,507 -65.05 n/a n/a n/a
2026-02-11 2025-12-31 13F SHERWIN WILLIAMS CALL Call 13,300 10.83 4,310 107,625.00 n/a n/a n/a
2025-11-12 2025-09-30 13F SHERWIN WILLIAMS CALL Call 12,000 20.00 4 33.33 n/a n/a n/a
2025-08-05 2025-06-30 13F SHERWIN WILLIAMS CALL Call 10,000 -36.71 3 -40.00 n/a n/a n/a
2025-05-12 2025-03-31 13F SHERWIN WILLIAMS CALL Call 15,800 -24.04 6 -28.57 n/a n/a n/a
2025-02-11 2024-12-31 13F SHERWIN WILLIAMS CALL Call 20,800 -13.69 7 -22.22 n/a n/a n/a
2024-11-08 2024-09-30 13F SHERWIN WILLIAMS CALL Call 24,100 127.36 9 200.00 n/a n/a n/a
2024-07-25 2024-06-30 13F SHERWIN WILLIAMS CALL Call 10,600 -9.40 3 -25.00 n/a n/a n/a
2024-04-25 2024-03-31 13F SHERWIN WILLIAMS CALL Call 11,700 -80.72 4 -77.78 n/a n/a n/a
2024-02-02 2023-12-31 13F SHERWIN WILLIAMS CALL Call 60,700 -48.34 19 -37.93 n/a n/a n/a
2023-11-01 2023-09-30 13F SHERWIN WILLIAMS CALL Call 117,500 252.85 30 262.50 n/a n/a n/a
2023-08-04 2023-06-30 13F SHERWIN WILLIAMS CALL Call 33,300 -24.32 9 -11.11 n/a n/a n/a
2023-04-27 2023-03-31 13F SHERWIN WILLIAMS CALL Call 44,000 -43.15 10 -50.00 n/a n/a n/a
2023-02-02 2022-12-31 13F SHERWIN WILLIAMS CALL Call 77,400 100.00 18 -99.77 n/a n/a n/a
2022-11-04 2022-09-30 13F SHERWIN WILLIAMS CALL Call 38,700 -13.81 7,923 -21.19 n/a n/a n/a
2022-08-03 2022-06-30 13F SHERWIN WILLIAMS CALL Call 44,900 268.03 10,053 230.15 n/a n/a n/a
2022-05-02 2022-03-31 13F SHERWIN WILLIAMS CALL Call 12,200 -78.93 3,045 -85.07 n/a n/a n/a
2022-02-23 2021-12-31 13F/A SHERWIN WILLIAMS CALL Call 57,900 0.17 20,390 28.13 n/a n/a n/a
2022-02-04 2021-12-31 13F SHERWIN WILLIAMS CALL Call 57,800 15,914 n/a n/a n/a
2021-10-28 2021-09-30 13F SHERWIN WILLIAMS CALL Call 57,800 -5.25 15,914 -4.24 n/a n/a n/a
2021-08-12 2021-06-30 13F SHERWIN WILLIAMS CALL Call 61,000 132,508.70 16,619 389.66 n/a n/a n/a
2021-04-26 2021-03-31 13F SHERWIN WILLIAMS CALL Call 46 -76.04 3,394 -75.95 n/a n/a n/a
2021-02-02 2020-12-31 13F SHERWIN WILLIAMS CALL Call 192 -20.33 14,110 -15.97 n/a n/a n/a
2020-10-14 2020-09-30 13F SHERWIN WILLIAMS CALL Call 241 44.31 16,791 74.00 n/a n/a n/a
2020-07-13 2020-06-30 13F SHERWIN WILLIAMS CALL Call 167 29.46 9,650 62.81 n/a n/a n/a
2020-04-29 2020-03-31 13F SHERWIN WILLIAMS CALL Call 129 706.25 5,927 535.26 n/a n/a n/a
2020-02-05 2019-12-31 13F SHERWIN WILLIAMS CALL Call 16 -85.19 933 -84.29 n/a n/a n/a
2019-10-15 2019-09-30 13F SHERWIN WILLIAMS CALL Call 108 -22.30 5,938 -6.78 n/a n/a n/a
2019-07-26 2019-06-30 13F SHERWIN WILLIAMS CALL Call 139 27.52 6,370 35.71 n/a n/a n/a
2019-04-18 2019-03-31 13F SHERWIN WILLIAMS CALL Call 109 2,080.00 4,694 2,294.90 n/a n/a n/a
2019-01-16 2018-12-31 13F SHERWIN WILLIAMS CALL Call 5 -70.59 196 -74.64 n/a n/a n/a
2018-10-23 2018-09-30 13F SHERWIN WILLIAMS CALL Call 17 0.00 773 11.71 n/a n/a n/a
2018-07-30 2018-06-30 13F SHERWIN WILLIAMS CALL Call 17 -19.05 692 13,740.00 n/a n/a n/a
2018-04-26 2018-03-31 13F SHERWIN WILLIAMS CALL Call 21 -82.93 5 -95.65 n/a n/a n/a
2018-01-10 2017-12-31 13F SHERWIN WILLIAMS CALL Call 123 -40.00 115 -13.53 n/a n/a n/a
2017-10-25 2017-09-30 13F SHERWIN WILLIAMS CALL Call 205 230.65 133 -14.74 n/a n/a n/a
2017-07-12 2017-06-30 13F SHERWIN WILLIAMS CALL Call 62 0.00 156 25.81 n/a n/a n/a
2017-04-21 2017-03-31 13F SHERWIN WILLIAMS CALL Call 62 26.53 124 287.50 n/a n/a n/a
2017-01-11 2016-12-31 13F SHERWIN WILLIAMS CALL Call 49 -78.12 32 -63.64 n/a n/a n/a
2016-10-07 2016-09-30 13F SHERWIN WILLIAMS CALL Call 224 729.63 88 700.00 n/a n/a n/a
2016-07-18 2016-06-30 13F SHERWIN WILLIAMS CALL Call 27 -44.90 11 -21.43 n/a n/a n/a
2016-04-14 2016-03-31 13F SHERWIN WILLIAMS CALL Call 49 53.12 14 -56.25 n/a n/a n/a
2016-01-20 2015-12-31 13F SHERWIN WILLIAMS CALL Call 32 -60.49 32 220.00 n/a n/a n/a
2015-10-08 2015-09-30 13F SHERWIN WILLIAMS CALL Call 81 285.71 10 -64.29 n/a n/a n/a
2015-07-08 2015-06-30 13F SHERWIN WILLIAMS CALL Call 21 -48.78 28 -78.46 n/a n/a n/a
2015-04-21 2015-03-31 13F SHERWIN WILLIAMS CALL Call 41 -6.82 130 -9.09 n/a n/a n/a
2015-03-04 2014-12-31 13F SHERWIN WILLIAMS CALL Call 44 143 n/a n/a n/a
Disclosed Put Options
File
Date
Effective
Date
Form Security Class ID Opt Avg Share Price Shares ΔShares
(%)
Value
(x1000)
ΔValue
(%)
Prior Allocation
(%)
Allocation
(%)
ΔAllocation
(%)
Cost Basis
(x1000)
Profit
(x1000)
Return
(%)
2026-05-14 2026-03-31 13F SHERWIN WILLIAMS PUT Put 3,000 20.00 962 18.64 n/a n/a n/a
2026-02-11 2025-12-31 13F SHERWIN WILLIAMS PUT Put 2,500 -79.34 810 20,150.00 n/a n/a n/a
2025-11-12 2025-09-30 13F SHERWIN WILLIAMS PUT Put 12,100 116.07 4 300.00 n/a n/a n/a
2025-08-05 2025-06-30 13F SHERWIN WILLIAMS PUT Put 5,600 80.65 2 0.00 n/a n/a n/a
2025-05-12 2025-03-31 13F SHERWIN WILLIAMS PUT Put 3,100 -84.18 1 -83.33 n/a n/a n/a
2025-02-11 2024-12-31 13F SHERWIN WILLIAMS PUT Put 19,600 37.06 7 20.00 n/a n/a n/a
2024-11-08 2024-09-30 13F SHERWIN WILLIAMS PUT Put 14,300 -21.43 5 0.00 n/a n/a n/a
2024-07-25 2024-06-30 13F SHERWIN WILLIAMS PUT Put 18,200 -56.25 5 -64.29 n/a n/a n/a
2024-04-25 2024-03-31 13F SHERWIN WILLIAMS PUT Put 41,600 -5.24 14 7.69 n/a n/a n/a
2024-02-02 2023-12-31 13F SHERWIN WILLIAMS PUT Put 43,900 113.11 14 160.00 n/a n/a n/a
2023-11-01 2023-09-30 13F SHERWIN WILLIAMS PUT Put 20,600 -57.61 5 -58.33 n/a n/a n/a
2023-08-04 2023-06-30 13F SHERWIN WILLIAMS PUT Put 48,600 24.30 13 50.00 n/a n/a n/a
2023-04-27 2023-03-31 13F SHERWIN WILLIAMS PUT Put 39,100 31.21 9 14.29 n/a n/a n/a
2023-02-02 2022-12-31 13F SHERWIN WILLIAMS PUT Put 29,800 -10.24 7 -99.90 n/a n/a n/a
2022-11-04 2022-09-30 13F SHERWIN WILLIAMS PUT Put 33,200 256.99 6,797 226.46 n/a n/a n/a
2022-08-03 2022-06-30 13F SHERWIN WILLIAMS PUT Put 9,300 4.49 2,082 -6.26 n/a n/a n/a
2022-05-02 2022-03-31 13F SHERWIN WILLIAMS PUT Put 8,900 -79.11 2,221 -85.20 n/a n/a n/a
2022-02-23 2021-12-31 13F/A SHERWIN WILLIAMS PUT Put 42,600 -12.88 15,002 11.42 n/a n/a n/a
2022-02-04 2021-12-31 13F SHERWIN WILLIAMS PUT Put 48,900 13,464 n/a n/a n/a
2021-10-28 2021-09-30 13F SHERWIN WILLIAMS PUT Put 48,900 0.20 13,464 1.27 n/a n/a n/a
2021-08-12 2021-06-30 13F SHERWIN WILLIAMS PUT Put 48,800 26,566.67 13,295 -1.55 n/a n/a n/a
2021-04-26 2021-03-31 13F SHERWIN WILLIAMS PUT Put 183 -9.41 13,505 -9.03 n/a n/a n/a
2021-02-02 2020-12-31 13F SHERWIN WILLIAMS PUT Put 202 -7.76 14,845 -2.71 n/a n/a n/a
2020-10-14 2020-09-30 13F SHERWIN WILLIAMS PUT Put 219 253.23 15,258 325.96 n/a n/a n/a
2020-07-13 2020-06-30 13F SHERWIN WILLIAMS PUT Put 62 -51.56 3,582 -39.09 n/a n/a n/a
2020-04-29 2020-03-31 13F SHERWIN WILLIAMS PUT Put 128 -25.15 5,881 -41.06 n/a n/a n/a
2020-02-05 2019-12-31 13F SHERWIN WILLIAMS PUT Put 171 11.04 9,978 17.85 n/a n/a n/a
2019-10-15 2019-09-30 13F SHERWIN WILLIAMS PUT Put 154 63.83 8,467 96.59 n/a n/a n/a
2019-07-26 2019-06-30 13F SHERWIN WILLIAMS PUT Put 94 1,780.00 4,307 1,903.26 n/a n/a n/a
2019-04-18 2019-03-31 13F SHERWIN WILLIAMS PUT Put 5 -58.33 215 -54.45 n/a n/a n/a
2019-01-16 2018-12-31 13F SHERWIN WILLIAMS PUT Put 12 -84.42 472 -86.53 n/a n/a n/a
2018-10-23 2018-09-30 13F SHERWIN WILLIAMS PUT Put 77 -33.04 3,505 -25.22 n/a n/a n/a
2018-07-30 2018-06-30 13F SHERWIN WILLIAMS PUT Put 115 -17.27 4,687 6,320.55 n/a n/a n/a
2018-04-26 2018-03-31 13F SHERWIN WILLIAMS PUT Put 139 363.33 73 711.11 n/a n/a n/a
2018-01-10 2017-12-31 13F SHERWIN WILLIAMS PUT Put 30 -78.57 9 -68.97 n/a n/a n/a
2017-10-25 2017-09-30 13F SHERWIN WILLIAMS PUT Put 140 -44.22 29 -65.06 n/a n/a n/a
2017-07-12 2017-06-30 13F SHERWIN WILLIAMS PUT Put 251 156.12 83 107.50 n/a n/a n/a
2017-04-21 2017-03-31 13F SHERWIN WILLIAMS PUT Put 98 104.17 40 -25.93 n/a n/a n/a
2017-01-11 2016-12-31 13F SHERWIN WILLIAMS PUT Put 48 41.18 54 -16.92 n/a n/a n/a
2016-10-07 2016-09-30 13F SHERWIN WILLIAMS PUT Put 34 25.93 65 550.00 n/a n/a n/a
2016-07-18 2016-06-30 13F SHERWIN WILLIAMS PUT Put 27 -82.69 10 -47.37 n/a n/a n/a
2016-04-14 2016-03-31 13F SHERWIN WILLIAMS PUT Put 156 188.89 19 18.75 n/a n/a n/a
2016-01-20 2015-12-31 13F SHERWIN WILLIAMS PUT Put 54 -5.26 16 -84.16 n/a n/a n/a
2015-10-08 2015-09-30 13F SHERWIN WILLIAMS PUT Put 57 90.00 101 110.42 n/a n/a n/a
2015-07-08 2015-06-30 13F SHERWIN WILLIAMS PUT Put 30 -23.08 48 140.00 n/a n/a n/a
2015-04-21 2015-03-31 13F SHERWIN WILLIAMS PUT Put 39 -13.33 20 122.22 n/a n/a n/a
2015-03-04 2014-12-31 13F SHERWIN WILLIAMS PUT Put 45 9 n/a n/a n/a
Legend
Shares
The total number of shares held by the institution at the end of the reporting period (the effective date). This is provided in the filing.
Value
The total value of the shares as of the effective date. This is provided in the filing.
Avg. Share Price
The weighted average share price of the shares held by the institution. We use FIFO accounting to determine this price
Class
This is the security class as indicated by the filer. There are a variety of values for this field. Common values include "EC" = equity common, "EP" - equity preferred
Allocation (%)
The percent of the institution's portfolio that this position represents. This is provided in NPORT filings. For 13F filings, we calculate it.
Change in Allocation
The change in allocation from the prior reporting period. This is calculated as current allocation - prior allocation.
Change in Allocation (%)
The percent change in allocation from the prior reporting period. This is calculated as (current allocation - prior allocation) / prior allocation.
Cost Basis
The total cost of the shares held. This is calculated as reported shares * avg. share price
Unrealized Gain/Loss
This is the market value of the position as of the effective date minus the cost basis.