The Sherwin-Williams Company
US ˙ NYSE ˙ US8243481061

SecuritySHW / The Sherwin-Williams Company
InstitutionMacquarie Group Ltd
Latest Disclosed Ownership21,054 shares
Latest Disclosed Value $ 6,748,859
Macquarie Group Ltd reports 37.13% decrease in ownership of SHW / The Sherwin-Williams Company

On May 15, 2026 - Macquarie Group Ltd filed a 13F-HR form disclosing ownership of 21,054 shares of The Sherwin-Williams Company (US:SHW) valued at $6,748,860 USD as of March 31, 2026. The entity filed a previous 13F-HR on February 13, 2026 disclosing 33,487 shares of The Sherwin-Williams Company. This represents a change in shares of -37.13% during the quarter. The current value of the position is $6,242,300 USD.

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 .

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)
2026-05-15 2026-03-31 13F SHERWIN WILLIAMS COM 824348106 21,054 -12,433 -37.13 6,749 -37.81 0.0314
2026-02-13 2025-12-31 13F SHERWIN WILLIAMS COM 824348106 33,487 -259,670 -88.58 10,851 -89.31 0.0474
2025-11-13 2025-09-30 13F SHERWIN WILLIAMS COM 824348106 293,157 -72,830 -19.90 101,509 -19.22 0.1185
2025-08-14 2025-06-30 13F SHERWIN WILLIAMS COM 824348106 365,987 -8,694 -2.32 125,665 -3.95 0.1541
2025-08-14 2025-03-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 374,681 -32,368 -7.95 130,834 -3.31 0.1624
2025-05-15 2025-03-31 13F SHERWIN WILLIAMS COM 824348106 374,681 -32,368 126,269 0.1032
2025-02-14 2024-12-31 13F SHERWIN WILLIAMS COM 824348106 407,049 -18,931 -4.44 135,310 -16.77 0.1642
2024-11-14 2024-09-30 13F SHERWIN WILLIAMS COM 824348106 425,980 105,217 32.80 162,584 69.84 0.1755
2024-08-09 2024-06-30 13F SHERWIN WILLIAMS COM 824348106 320,763 -5,237 -1.61 95,725 -15.46 0.1098
2024-05-14 2024-03-31 13F SHERWIN WILLIAMS COM 824348106 326,000 -17,630 -5.13 113,229 5.65 0.1284
2024-02-14 2023-12-31 13F SHERWIN WILLIAMS COM 824348106 343,630 -103,543 -23.16 107,179 -6.03 0.1238
2023-11-14 2023-09-30 13F SHERWIN WILLIAMS COM 824348106 447,173 -17,463 -3.76 114,052 -7.55 0.1433
2023-10-27 2023-06-30 13F/A-2 SHERWIN WILLIAMS COM 824348106 464,636 -29,467 -5.96 123,371 11.09 0.1411
2023-10-12 2023-06-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 464,636 -29,467 123,371 0.1240
2023-08-14 2023-06-30 13F SHERWIN WILLIAMS COM 824348106 464,636 -29,467 123,371 0.1252
2023-06-01 2023-03-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 494,103 -58,866 -10.65 111,059 -15.37 0.1319
2023-05-15 2023-03-31 13F SHERWIN WILLIAMS COM 824348106 494,103 -58,866 111,059 0.1020
2023-02-21 2022-12-31 13F SHERWIN WILLIAMS COM 824348106 552,969 40,132 7.83 131,236 24.98 0.1550
2022-11-14 2022-09-30 13F SHERWIN WILLIAMS COM 824348106 512,837 -9,122 -1.75 105,003 -10.16 0.1288
2022-08-17 2022-06-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 521,959 174,635 50.28 116,872 34.80 0.1312
2022-08-15 2022-06-30 13F SHERWIN WILLIAMS COM 824348106 521,959 174,635 116,872 0.0419
2022-05-16 2022-03-31 13F SHERWIN WILLIAMS COM 824348106 347,324 -96,447 -21.73 86,699 -44.52 0.0659
2022-02-11 2021-12-31 13F SHerwin-Williams COM 824348106 443,771 -160,392 -26.55 156,279 -7.53 0.1302
2021-11-12 2021-09-30 13F SHERWIN WILLIAMS COM 824348106 604,163 -9,387 -1.53 169,002 1.10 0.1440
2021-08-13 2021-06-30 13F SHERWIN WILLIAMS COM 824348106 613,550 597,476 3,717.03 167,162 1,329.35 0.1373
2021-05-14 2021-03-31 13F SHERWIN WILLIAMS COM 824348106 16,074 -975 -5.72 11,695 -6.66 0.0165
2021-02-16 2020-12-31 13F SHERWIN WILLIAMS COM 824348106 17,049 -1,467 -7.92 12,529 -2.88 0.0183
2020-11-13 2020-09-30 13F SHERWIN WILLIAMS COM 824348106 18,516 639 3.57 12,901 24.88 0.0218
2020-08-11 2020-06-30 13F SHERWIN WILLIAMS COM 824348106 17,877 -546 -2.96 10,331 22.03 0.0178
2020-05-15 2020-03-31 13F SHERWIN WILLIAMS COM 824348106 18,423 -156 -0.84 8,466 -21.91 0.0174
2020-03-18 2019-12-31 13F/A-2 SHERWIN WILLIAMS COM 824348106 18,579 241 1.31 10,842 7.53 0.0155
2020-02-28 2019-12-31 13F/A-1 SHERWIN WILLIAMS COM 824348106 18,579 0 10,842 0.0157
2020-02-14 2019-12-31 13F SHERWIN WILLIAMS COM 824348106 18,579 241 10,842 13,605.7912
2019-11-14 2019-09-30 13F SHERWIN WILLIAMS COM 824348106 18,338 0 0.00 10,083 19.98 0.0169
2019-11-06 2019-06-30 13F/A-2 SHERWIN WILLIAMS COM 824348106 18,338 617 3.48 8,404 10.12 0.0142
2019-09-24 2019-06-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 18,338 0 8,404 0.0143
2019-08-14 2019-06-30 13F SHERWIN WILLIAMS COM 824348106 18,338 617 8,404
2019-05-15 2019-03-31 13F SHERWIN WILLIAMS COM 824348106 17,721 -23 -0.13 7,632 9.33 0.0130
2019-02-15 2018-12-31 13F SHERWIN WILLIAMS COM 824348106 17,744 -1,168 -6.18 6,981 -18.91 0.0135
2018-11-15 2018-09-30 13F SHERWIN WILLIAMS COM 824348106 18,912 1,207 6.82 8,609 19.30 0.0140
2019-03-21 2018-06-30 13F/A-1 SHERWIN WILLIAMS COM 824348106 17,705 -5,619 -24.09 7,216 -21.09 0.0124
2018-08-14 2018-06-30 13F SINA ORD 824348106 17,705 -5,619 7,216
2018-05-11 2018-03-31 13F SHERWIN WILLIAMS COM 824348106 23,324 -509 -2.14 9,145 -2.41 0.0167
2018-02-14 2017-12-31 13F SHERWIN WILLIAMS COM 824348106 23,833 -14,899 -38.47 9,371 -32.43 0.0166
2017-11-08 2017-09-30 13F SHERWIN WILLIAMS COM 824348106 38,732 16,230 72.13 13,868 75.59 0.0249
2017-08-14 2017-06-30 13F SHERWIN WILLIAMS COM 824348106 22,502 235 1.06 7,898 14.35 0.0144
2017-05-15 2017-03-31 13F Sherwin-Williams COM 824348106 22,267 -5,594 -20.08 6,907 -7.75 0.0126
2017-03-30 2016-12-31 13F/A-1 Sherwin-Williams Common Stock 824348106 27,861 13,767 97.68 7,487 92.02 0.0143
2017-02-15 2016-12-31 13F Sherwin-Williams Common Stock 824348106 27,861 7,487
2016-11-15 2016-09-30 13F Sherwin-Williams Common Stock 824348106 14,094 -198 -1.39 3,899 -7.12 0.0075
2016-09-14 2016-06-30 13F/A-1 Sherwin-Williams Common Stock 824348106 14,292 -1,208 -7.79 4,198 -4.85 0.0082
2016-08-15 2016-06-30 13F Sherwin-Williams Common Stock 824348106 14,292 4,198
2016-05-16 2016-03-31 13F Sherwin-Williams Common Stock 824348106 15,500 13,700 761.11 4,412 844.75 0.0089
2016-02-16 2015-12-31 13F Sherwin-Williams Common Stock 824348106 1,800 -7,700 -81.05 467 -77.93 0.0010
2015-11-16 2015-09-30 13F Sherwin-Williams Common Stock 824348106 9,500 -17,000 -64.15 2,116 -70.97 0.0045
2015-08-21 2015-06-30 13F/A-1 Sherwin-Williams Common Stock 824348106 26,500 -3 -0.01 7,288 -3.34 0.0144
2015-08-14 2015-06-30 13F Sherwin-Williams Common Stock 824348106 26,500 7,288
2015-05-18 2015-03-31 13F Sherwin-Williams Common Stock 824348106 26,503 -11,197 -29.70 7,540 -23.96 0.0148
2015-02-17 2014-12-31 13F Sherwin-Williams Common Stock 824348106 37,700 -11,500 -23.37 9,916 -7.96 0.0205
2014-11-14 2014-09-30 13F Sherwin-Williams Common Stock 824348106 49,200 3,000 6.49 10,774 12.71 0.0231
2014-08-14 2014-06-30 13F SHERWIN-WILLIAMS COMMON 824348106 46,200 -11,800 -20.34 9,559 -16.40 0.0213
2014-05-15 2014-03-31 13F Sherwin-Williams Common Stock 824348106 58,000 24,500 73.13 11,434 86.01 0.0197
2014-02-14 2013-12-31 13F Sherwin-Williams Common Stock 824348106 33,500 3,700 12.42 6,147 13.23 0.0110
2013-11-14 2013-09-30 13F SHERWIN-WILLIAMS Common Stock 824348106 29,800 0 0.00 5,429 3.17 0.0106
2013-08-16 2013-06-30 13F/A-1 SHERWIN-WILLIAMS COMMON 824348106 29,800 29,800 5,262 0.0115
2013-08-14 2013-06-30 13F SHERWIN-WILLIAMS COMMON 824348106 29,800 5,262 0.0115
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.