State Street SPDR S&P MIDCAP 400 ETF Trust
US ˙ ARCA ˙ US78467Y1073

SecurityMDY / State Street SPDR S&P MIDCAP 400 ETF Trust
InstitutionBDO Wealth Advisors, LLC
Latest Disclosed Ownership34,320 shares
Latest Disclosed Value $ 16,436,292
BDO Wealth Advisors, LLC reports 0.46% decrease in ownership of MDY / State Street SPDR S&P MIDCAP 400 ETF Trust

On August 1, 2023 - BDO Wealth Advisors, LLC filed a 13F-HR form disclosing ownership of 34,320 shares of State Street SPDR S&P MIDCAP 400 ETF Trust (US:MDY) valued at $16,436,191 USD as of June 30, 2023. The entity filed a previous 13F-HR on May 9, 2023 disclosing 34,480 shares of State Street SPDR S&P MIDCAP 400 ETF Trust. This represents a change in shares of -0.46% during the quarter. The current value of the position is $23,151,929 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)
2023-08-01 2023-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 34,320 -160 -0.46 16,436 3.99 1.8852
2023-05-09 2023-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 34,480 -655 -1.86 15,806 1.59 1.9360
2023-01-30 2022-12-31 13F/A-1 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,135 107 0.31 15,558 10.57 1.9340
2023-01-27 2022-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,135 107 15,558 0.0019
2022-11-02 2022-09-30 13F/A-1 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,028 -211 -0.60 14,070 -3.44 1.8698
2022-11-01 2022-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,239 0 14,571 1.7906
2022-08-25 2022-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,239 -681 -1.90 14,571 -17.29 1.7932
2022-05-06 2022-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,920 -66 -0.18 17,617 -5.43 1.8799
2022-02-11 2021-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,986 18 0.05 18,629 7.71 1.9712
2021-11-09 2021-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,968 149 0.42 17,296 -1.66 1.9042
2021-09-03 2021-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,819 -139 -0.39 17,588 2.75 1.9473
2021-05-14 2021-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,958 -186 -0.51 17,118 12.78 2.0175
2021-02-12 2020-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 36,144 422 1.18 15,178 25.40 2.1349
2020-11-12 2020-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 35,722 -2,678 -6.97 12,104 -2.86 1.9708
2020-08-14 2020-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 38,400 -602 -1.54 12,460 21.53 2.1894
2020-05-15 2020-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 39,002 1,072 2.83 10,253 -27.99 2.0722
2020-02-14 2019-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 37,930 -2,726 -6.71 14,238 -0.64 3.6726
2019-11-12 2019-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 40,656 -885 -2.13 14,330 -2.72 3.6703
2019-08-09 2019-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 41,541 -508 -1.21 14,730 1.42 4.0119
2019-05-15 2019-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 42,049 -486 -1.14 14,524 12.82 4.2199
2019-02-14 2018-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 42,535 -579 -1.34 12,874 -18.74 4.4304
2018-11-07 2018-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 43,114 -1,664 -3.72 15,843 -0.34 5.1208
2018-08-27 2018-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 44,778 110 0.25 15,897 4.15 5.4132
2018-05-23 2018-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 44,668 -5,821 -11.53 15,264 -12.47 5.7299
2018-02-14 2017-12-31 13F SPDR S&P MIDCAP 400 ETF UTSER1 S&PDCRP 78467Y107 50,489 -3,317 -6.16 17,439 -0.68 7.8299
2017-11-08 2017-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 53,806 -7,909 -12.82 17,559 -10.42 8.7065
2017-08-07 2017-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 61,715 61,715 19,602 8.5573
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.