State Street SPDR S&P MIDCAP 400 ETF Trust
| Security | MDY / State Street SPDR S&P MIDCAP 400 ETF Trust |
| Institution | Wiley Bros.-aintree Capital, Llc |
| Latest Disclosed Ownership | 17,655 shares |
| Latest Disclosed Value | $ 10,888,942 |
Wiley Bros.-aintree Capital, Llc reports 1.85% increase in ownership of MDY / State Street SPDR S&P MIDCAP 400 ETF Trust
On May 15, 2026 - Wiley Bros.-aintree Capital, Llc filed a 13F-HR form disclosing ownership of 17,655 shares of State Street SPDR S&P MIDCAP 400 ETF Trust (US:MDY) valued at $10,888,898 USD as of March 31, 2026. The entity filed a previous 13F-HR on February 17, 2026 disclosing 17,334 shares of State Street SPDR S&P MIDCAP 400 ETF Trust. This represents a change in shares of 1.85% during the quarter. The current value of the position is $12,102,502 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 | STATE STR SPDR S&P MIDCAP 40 | UTSER1 S&PDCRP | 78467Y107 | 17,655 | 321 | 1.85 | 10,889 | 4.13 | 0.0538 | |||||
| 2026-02-17 | 2025-12-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 17,334 | 1,384 | 8.68 | 10,457 | 9.99 | 0.0547 | |||||
| 2025-11-14 | 2025-09-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 15,950 | 3,289 | 25.98 | 9,506 | 32.54 | 0.0609 | |||||
| 2025-08-14 | 2025-06-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 12,661 | 5,710 | 82.15 | 7,172 | 93.89 | 0.0550 | |||||
| 2025-05-15 | 2025-03-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 6,951 | 785 | 12.73 | 3,700 | 4.46 | 0.0393 | |||||
| 2025-02-14 | 2024-12-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 6,166 | 3,283 | 113.87 | 3,541 | 115.65 | 0.0425 | |||||
| 2024-11-14 | 2024-09-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 2,883 | 1,749 | 154.23 | 1,642 | 170.96 | 0.0317 | |||||
| 2024-07-24 | 2024-06-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 1,134 | 142 | 14.31 | 607 | 9.98 | 0.0266 | |||||
| 2024-04-11 | 2024-03-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 992 | -20 | -1.98 | 552 | 7.41 | 0.0760 | |||||
| 2024-01-09 | 2023-12-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 1,012 | 0 | 0.00 | 513 | 11.04 | 0.1251 | |||||
| 2023-10-06 | 2023-09-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 1,012 | -137 | -11.92 | 462 | -16.00 | 0.2157 | |||||
| 2023-07-05 | 2023-06-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 1,149 | 0 | 0.00 | 550 | 4.56 | 0.2464 | |||||
| 2023-04-06 | 2023-03-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 1,149 | 0 | 0.00 | 527 | 3.54 | 0.2533 | |||||
| 2023-01-10 | 2022-12-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 1,149 | 437 | 61.38 | 509 | 77.62 | 0.2527 | |||||
| 2022-10-11 | 2022-09-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 712 | 0 | 0.00 | 286 | -2.72 | 0.1654 | |||||
| 2022-07-06 | 2022-06-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 712 | 0 | 0.00 | 294 | -15.76 | 0.1698 | |||||
| 2022-04-26 | 2022-03-31 | 13F/A-1 | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 712 | 0 | 0.00 | 349 | -5.42 | 0.1959 | |||||
| 2022-04-11 | 2022-03-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 712 | 0 | 349 | 0.2514 | |||||||
| 2022-01-12 | 2021-12-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 712 | 137 | 23.83 | 369 | 33.21 | 0.2225 | |||||
| 2021-10-07 | 2021-09-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 0 | 0.00 | 277 | -1.77 | 0.1761 | |||||
| 2021-07-12 | 2021-06-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 0 | 0.00 | 282 | 2.92 | 0.1825 | |||||
| 2021-04-09 | 2021-03-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 0 | 0.00 | 274 | 13.69 | 0.1994 | |||||
| 2021-01-11 | 2020-12-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 575 | 241 | 0.2025 | |||||||
| 2020-04-03 | 2020-03-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 0 | -575 | -100.00 | 0 | -100.00 | ||||||
| 2020-01-10 | 2019-12-31 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 0 | 0.00 | 216 | 6.40 | 0.2570 | |||||
| 2019-10-10 | 2019-09-30 | 13F/A-1 | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 0 | 0.00 | 203 | -0.49 | 0.2633 | |||||
| 2019-10-04 | 2019-09-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 0 | 211 | ||||||||
| 2019-07-10 | 2019-06-30 | 13F | SPDR S&P MIDCAP 400 ETF TR | UTSER1 S&PDCRP | 78467Y107 | 575 | 575 | 204 | 0.2816 |
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.
