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

SecurityMDY / State Street SPDR S&P MIDCAP 400 ETF Trust
InstitutionCommonwealth Equity Services, Inc
Latest Disclosed Ownership149,100 shares
Latest Disclosed Value $ 48,656,000
Commonwealth Equity Services, Inc reports 10.95% decrease in ownership of MDY / State Street SPDR S&P MIDCAP 400 ETF Trust

On February 16, 2018 - Commonwealth Equity Services, Inc filed a 13F-HR/A form disclosing ownership of 149,100 shares of State Street SPDR S&P MIDCAP 400 ETF Trust (US:MDY) valued at $48,655,803 USD as of September 30, 2017. The entity filed a previous 13F-HR/A on February 16, 2018 disclosing 167,441 shares of State Street SPDR S&P MIDCAP 400 ETF Trust. This represents a change in shares of -10.95% during the quarter. The current value of the position is $100,581,369 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)
2018-02-16 2017-09-30 13F/A-1 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 149,100 -18,341 -10.95 48,656 -8.51 0.2911
2017-11-07 2017-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 149,099 -18,341 48,655
2018-02-16 2017-06-30 13F/A-1 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 167,441 -26,638 -13.73 53,183 -12.29 0.3379
2017-08-11 2017-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 167,440 -26,639 53,182
2018-02-16 2017-03-31 13F/A-1 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 194,079 15,105 8.44 60,634 12.28 0.4060
2017-05-15 2017-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 194,079 15,105 60,634
2018-02-16 2016-12-31 13F/A-1 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 178,974 6,664 3.87 54,002 11.03 0.3989
2017-02-01 2016-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 178,974 6,664 54,002
2016-10-25 2016-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 172,310 10,193 6.29 48,638 10.21 0.3858
2016-08-04 2016-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 162,117 -6,864 -4.06 44,133 -0.59 0.3720
2016-04-27 2016-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 168,981 51,141 43.40 44,395 48.30 0.3957
2016-01-19 2015-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 117,840 10,596 9.88 29,936 12.15 0.2835
2015-10-27 2015-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 107,244 6,293 6.23 26,692 -3.22 0.2810
2015-07-28 2015-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 100,951 3,462 3.55 27,580 2.04 0.2741
2015-04-28 2015-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 97,489 -799 -0.81 27,028 4.17 0.2806
2015-01-13 2014-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 98,288 -524 -0.53 25,945 5.31 0.2908
2014-10-17 2014-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 98,812 -1,414 -1.41 24,636 -5.66 0.2994
2014-07-23 2014-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 100,226 2,445 2.50 26,115 6.59 0.3178
2014-05-07 2014-03-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 97,781 -14,794 -13.14 24,501 -10.88 0.3384
2014-02-11 2013-12-31 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 112,575 17,543 18.46 27,491 27.81 0.3993
2013-11-04 2013-09-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 95,032 8,814 10.22 21,509 18.74 0.3493
2013-07-29 2013-06-30 13F SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 86,218 18,114
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.