셔윈-윌리엄스 컴퍼니
US ˙ NYSE ˙ US8243481061

SecuritySHW / The Sherwin-Williams Company
InstitutionJefferies Group LLC
Latest Disclosed Ownership48,036 shares
Latest Disclosed Value $ 9,835,372
Jefferies Group LLC ownership in SHW / The Sherwin-Williams Company

On September 21, 2023 - Jefferies Group LLC filed a 13F-HR/A form disclosing ownership of 48,036 shares of The Sherwin-Williams Company (US:SHW) valued at $9,835,371 USD as of September 30, 2022. The entity filed a previous 13F-HR on August 15, 2022 disclosing 5,004 shares of The Sherwin-Williams Company. This represents a change in shares of 859.95% during the quarter. The current value of the position is $14,665,391 USD.

Jefferies Group 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 23,700 of underlying shares valued at $4,852,575 USD and put options representing 0 of underlying shares valued at $0 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)
2023-09-21 2022-09-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 48,036 43,032 859.95 9,835 54,538.89 0.0823
2022-11-14 2022-09-30 13F SHERWIN WILLIAMS COM 824348106 51,024 46,020 9,808 0.0781
2022-08-15 2022-06-30 13F SHERWIN WILLIAMS COM 824348106 5,004 -18,496 -78.71 18 -99.69 0.0001
2023-09-21 2022-03-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 23,500 23,245 9,115.69 5,866 13,231.82 0.0369
2022-05-16 2022-03-31 13F SHERWIN WILLIAMS COM 824348106 23,500 23,245 5,866 0.0342
2022-02-14 2021-12-31 13F SHERWIN WILLIAMS COM 824348106 255 -19,245 -98.69 44 -99.19 0.0002
2023-09-21 2021-09-30 13F/A-2 SHERWIN WILLIAMS COM 824348106 19,500 -2,588 -11.72 5,455 -9.36 0.0398
2021-12-17 2021-09-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 19,500 -2,588 5,455 0.0375
2021-11-15 2021-09-30 13F SHERWIN WILLIAMS COM 824348106 19,500 -2,588 5,455 0.0352
2023-09-21 2021-06-30 13F/A-2 SHERWIN WILLIAMS COM 824348106 22,088 13,341 152.52 6,018 -6.79 0.0379
2021-08-20 2021-06-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 22,088 13,341 6,018 0.0356
2021-08-16 2021-06-30 13F SHERWIN WILLIAMS COM 824348106 22,088 13,341 6,018 0.0356
2023-09-21 2021-03-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 8,747 4,247 94.38 6,455 95.19 0.0566
2021-05-14 2021-03-31 13F SHERWIN WILLIAMS COM 824348106 8,747 4,247 6,455 0.0566
2023-09-21 2020-12-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 4,500 -8,216 -64.61 3,307 -62.67 0.0260
2021-02-16 2020-12-31 13F SHERWIN WILLIAMS COM 824348106 4,500 -8,216 3,307 0.0298
2020-11-13 2020-09-30 13F SHERWIN WILLIAMS COM 824348106 12,716 8,733 219.26 8,860 284.88 0.0981
2020-11-02 2020-06-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 3,983 3,392 573.94 2,302 746.32 0.0271
2020-08-14 2020-06-30 13F SHERWIN WILLIAMS COM 824348106 3,983 3,392 2,302 30,933.9417
2020-05-15 2020-03-31 13F SHERWIN WILLIAMS COM 824348106 591 -623 -51.32 272 -61.58 0.0034
2020-02-13 2019-12-31 13F SHERWIN WILLIAMS COM 824348106 1,214 14 1.17 708 7.27 0.0055
2019-11-13 2019-09-30 13F SHERWIN WILLIAMS COM 824348106 1,200 -23,882 -95.22 660 -94.26 0.0051
2019-08-14 2019-06-30 13F SHERWIN WILLIAMS COM 824348106 25,082 24,382 3,483.14 11,495 3,718.94 0.0838
2019-05-15 2019-03-31 13F SHERWIN WILLIAMS COM 824348106 700 700 301 0.0025
2019-02-14 2018-12-31 13F SHERWIN WILLIAMS COM 824348106 0 -22,494 -100.00 0 -100.00
2018-11-14 2018-09-30 13F SHERWIN WILLIAMS COM 824348106 22,494 22,494 10,239 0.0670
2018-08-14 2018-06-30 13F SHERWIN WILLIAMS COM 824348106 0 -13,132 -100.00 0 -100.00
2018-05-15 2018-03-31 13F SHERWIN WILLIAMS COM 824348106 13,132 2,868 27.94 5,149 22.33 0.0277
2018-02-14 2017-12-31 13F SHERWIN WILLIAMS COM 824348106 10,264 6,590 179.37 4,209 220.08 0.0197
2017-11-14 2017-09-30 13F SHERWIN WILLIAMS COM 824348106 3,674 3,674 1,315 0.0087
2017-08-14 2017-06-30 13F SHERWIN WILLIAMS COM 824348106 0 -3,772 -100.00 0 -100.00
2017-05-15 2017-03-31 13F SHERWIN WILLIAMS COM 824348106 3,772 3,772 1,170 0.0087
2017-02-14 2016-12-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 0 -22,068 -100.00 0 -100.00
2016-11-14 2016-09-30 13F SHERWIN WILLIAMS COM 824348106 22,068 6,876 45.26 6,105 36.85 0.0315
2016-08-12 2016-06-30 13F SHERWIN WILLIAMS COM 824348106 15,192 11,828 351.61 4,461 365.66 0.0203
2016-05-11 2016-03-31 13F SHERWIN WILLIAMS COM 824348106 3,364 -9,796 -74.44 958 -71.96 0.0055
2016-02-12 2015-12-31 13F SHERWIN WILLIAMS COM 824348106 13,160 -1,230 -8.55 3,416 6.55 0.0194
2015-11-13 2015-09-30 13F SHERWIN WILLIAMS COM 824348106 14,390 7,696 114.97 3,206 74.14 0.0184
2015-08-18 2015-06-30 13F SHERWIN WILLIAMS COM 824348106 6,694 -1,418 -17.48 1,841 -20.23 0.0095
2015-05-18 2015-03-31 13F SHERWIN WILLIAMS COM 824348106 8,112 8,112 0.00 2,308 0.0129
2014-08-14 2014-06-30 13F SHERWIN WILLIAMS COM 824348106 0 -5,002 -100.00 0 -100.00
2014-05-16 2014-03-31 13F SHERWIN WILLIAMS COM 824348106 5,002 3,443 220.85 986 244.76 0.0096
2014-02-18 2013-12-31 13F SHERWIN WILLIAMS COM 824348106 1,559 -5,411 -77.63 286 -77.48 0.0018
2013-11-18 2013-09-30 13F SHERWIN WILLIAMS COM 824348106 6,970 -443 -5.98 1,270 -2.98 0.0124
2013-08-15 2013-06-30 13F SHERWIN WILLIAMS COM 824348106 7,413 7,413 1,309 0.0141
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
(%)
2023-09-21 2022-09-30 13F/A SHERWIN WILLIAMS COM Call 23,700 -90.94 4,853 -91.72 n/a n/a n/a
2022-11-14 2022-09-30 13F SHERWIN WILLIAMS COM Call 23,700 4,853 n/a n/a n/a
2023-09-21 2022-06-30 13F/A SHERWIN WILLIAMS COM Call 261,600 1,208.00 58,575 1,073.36 n/a n/a n/a
2022-08-15 2022-06-30 13F SHERWIN WILLIAMS COM Call 261,600 58,575 n/a n/a n/a
2023-09-21 2022-03-31 13F/A SHERWIN WILLIAMS COM Call 20,000 4,992 n/a n/a n/a
2022-05-16 2022-03-31 13F SHERWIN WILLIAMS COM Call 20,000 4,992 n/a n/a n/a
2020-11-02 2020-06-30 13F/A SHERWIN WILLIAMS COM Call 0 -100.00 0 -100.00 n/a n/a n/a
2020-05-15 2020-03-31 13F SHERWIN WILLIAMS COM Call 1,600 735 n/a n/a n/a
2020-02-13 2019-12-31 13F SHERWIN WILLIAMS COM Call 0 -100.00 0 -100.00 n/a n/a n/a
2019-11-13 2019-09-30 13F SHERWIN WILLIAMS COM Call 8,700 4,784 n/a n/a n/a
2018-05-15 2018-03-31 13F SHERWIN WILLIAMS COM Call 0 -100.00 0 -100.00 n/a n/a n/a
2018-02-14 2017-12-31 13F SHERWIN WILLIAMS COM Call 600 246 n/a n/a n/a
2017-02-14 2016-12-31 13F/A SHERWIN WILLIAMS COM Call 0 -100.00 0 -100.00 n/a n/a n/a
2016-11-14 2016-09-30 13F SHERWIN WILLIAMS COM Call 12,000 3,320 n/a n/a n/a
2016-05-11 2016-03-31 13F SHERWIN WILLIAMS COM Call 0 -100.00 0 -100.00 n/a n/a n/a
2016-02-12 2015-12-31 13F SHERWIN WILLIAMS COM Call 2,700 0.00 701 16.45 n/a n/a n/a
2015-11-13 2015-09-30 13F SHERWIN WILLIAMS COM Call 2,700 -87.95 602 -90.23 n/a n/a n/a
2015-08-18 2015-06-30 13F SHERWIN WILLIAMS COM Call 22,400 0.00 6,160 -3.34 n/a n/a n/a
2015-05-18 2015-03-31 13F SHERWIN WILLIAMS COM Call 22,400 0.00 6,373 8.16 n/a n/a n/a
2015-02-17 2014-12-31 13F SHERWIN WILLIAMS COM Call 22,400 5,892 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
(%)
2023-09-21 2022-03-31 13F/A SHERWIN WILLIAMS COM Put 0 -100.00 0 -100.00 n/a n/a n/a
2022-05-16 2022-03-31 13F SHERWIN WILLIAMS COM Put 0 0 n/a n/a n/a
2023-09-21 2021-12-31 13F/A SHERWIN WILLIAMS COM Put 10,000 3,522 n/a n/a n/a
2022-02-14 2021-12-31 13F SHERWIN WILLIAMS COM Put 10,000 3,522 n/a n/a n/a
2020-11-02 2020-06-30 13F/A SHERWIN WILLIAMS COM Put 0 -100.00 0 -100.00 n/a n/a n/a
2020-05-15 2020-03-31 13F SHERWIN WILLIAMS COM Put 1,100 450.00 505 331.62 n/a n/a n/a
2020-02-13 2019-12-31 13F SHERWIN WILLIAMS COM Put 200 -92.31 117 -91.82 n/a n/a n/a
2019-11-13 2019-09-30 13F SHERWIN WILLIAMS COM Put 2,600 -78.51 1,430 -74.21 n/a n/a n/a
2019-08-14 2019-06-30 13F SHERWIN WILLIAMS COM Put 12,100 5,545 n/a n/a n/a
2018-05-15 2018-03-31 13F SHERWIN WILLIAMS COM Put 0 -100.00 0 -100.00 n/a n/a n/a
2018-02-14 2017-12-31 13F SHERWIN WILLIAMS COM Put 600 246 n/a n/a n/a
2016-08-12 2016-06-30 13F SHERWIN WILLIAMS COM Put 0 -100.00 0 -100.00 n/a n/a n/a
2016-05-11 2016-03-31 13F SHERWIN WILLIAMS COM Put 11,000 -52.17 3,131 -47.56 n/a n/a n/a
2016-02-12 2015-12-31 13F SHERWIN WILLIAMS COM Put 23,000 5,971 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.