{"id":493,"date":"2025-12-01T11:23:34","date_gmt":"2025-12-01T19:23:34","guid":{"rendered":"https:\/\/masterdatareports.com\/forum\/?p=493"},"modified":"2025-12-01T11:45:45","modified_gmt":"2025-12-01T19:45:45","slug":"additions-to-etf-constituent-lists-report","status":"publish","type":"post","link":"https:\/\/masterdatareports.com\/forum\/etf-additions\/additions-to-etf-constituent-lists-report\/","title":{"rendered":"New Fundamental Additions to ETF Constituent Lists Report"},"content":{"rendered":"\n

The ETF constituent list data files are undergoing a major upgrade.  The structure of the current files will remain in place for the next two weeks, through December 15, 2025<\/strong>.  Many previously blank values will now be filled in.  In particular, the BBG-ID (FIGI) column is more complete, along with the DividendAmt, XDate, and DividendYield columns.  Additionally, SharesOutstanding, MarketCap. Earnings and PE Ratio for constituent issues will be populated.  Other, formerly blank fields will be populated in the remaining columns.<\/p>\n\n\n\n

There are now three additional files being generated.  Each of these filenames is exactly the same as the normal filenames, but with an \u201cX\u201d in the name.  These are the new files in each of the categories:<\/p>\n\n\n\n

    \n
  1. ConstituentData42X.csv (Both major US and global indexes and US traded ETFs)<\/li>\n\n\n\n
  2. ETFData42X.csv (US traded ETFs)<\/li>\n\n\n\n
  3. IndexData42X.csv (Major US and global indexes)<\/li>\n<\/ol>\n\n\n\n

    71 additional ETFs are now added to our ETP coverage.  This includes 1 US index, 6 commodity based ETFs, 13 globally based ETFs, 18 US equity based ETFs, and 27 US fixed income ETFs.<\/p>\n\n\n\n

    We now cover 3030 ETPs and 117 US and global indexes.<\/p>\n\n\n\n

    For a free look at the current files please click here<\/a> (no credit card required).<\/p>\n\n\n\n

    Please let me know if I can help at lc@americanetp.com.<\/p>\n\n\n\n

    70 additional ETFs are now included in the ConstituentData42.csv File, ETFDATA42.csv file, and Fundamentals.csv file as follows:<\/p>\n\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
    Name<\/th>Ticker<\/th>ETF Type<\/th>\n<\/tr>\n<\/thead>\n
    ARS Core Equity Portfolio ETF<\/td>ACEP<\/td>US Equity ETF<\/td>\n<\/tr>\n
    CSOP Bloomberg Barclays China Treasury + Policy Bank Bond Index ETF<\/td>3199.HK<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    CSOP CSI 500 ETF<\/td>3005.HK<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    CSOP ICBC S&P New China Sectors ETF<\/td>3167.HK<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    CSOP MSCI China A 50 Connect ETF<\/td>3003.HK<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    CSOP SZSE ChiNext ETF<\/td>3147 HK<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    Defined Duration 10 ETF\tDDX<\/td>DDX<\/td>US Fund of Funds ETF<\/td>\n<\/tr>\n
    Defined Duration 20 ETF<\/td>DDXX<\/td>US Fund of Funds ETF<\/td>\n<\/tr>\n
    Defined Duration 5 ETF<\/td>DDV<\/td>US Fund of Funds ETF<\/td>\n<\/tr>\n
    EA Series Trust<\/td>SFGV<\/td>US Equity ETF<\/td>\n<\/tr>\n
    EA Series Trust - Arin Tactical Tail Risk ETF<\/td>ATTR<\/td>US Option Based ETF<\/td>\n<\/tr>\n
    Invesco Core Fixed Income ETF<\/td>GTOC<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco CurrencyShares\u00ae Australian Dollar Trust<\/td>FXA<\/td>Commodity Based ETF<\/td>\n<\/tr>\n
    Invesco CurrencyShares\u00ae British Pound Sterling Trust<\/td>FXB<\/td>Commodity Based ETF<\/td>\n<\/tr>\n
    Invesco CurrencyShares\u00ae Canadian Dollar Trust<\/td>FXC<\/td>Commodity Based ETF<\/td>\n<\/tr>\n
    Invesco CurrencyShares\u00ae Euro Trust<\/td>FXE<\/td>Commodity Based ETF<\/td>\n<\/tr>\n
    Invesco CurrencyShares\u00ae Japanese Yen Trust<\/td>FXY<\/td>Commodity Based ETF<\/td>\n<\/tr>\n
    Invesco CurrencyShares\u00ae Swiss Franc Trust<\/td>FXF<\/td>Commodity Based ETF<\/td>\n<\/tr>\n
    Invesco Equal Weight 0-30 Year Treasury ETF<\/td>GOVI<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco Fundamental High Yield\u00ae Corporate Bond ETF<\/td>PHB<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco Intermediate Municipal ETF<\/td>INTM<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco National AMT-Free Municipal Bond ETF<\/td>PZA<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco New York AMT-Free Municipal Bond ETF<\/td>PZT<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco Rochester High Yield Municipal ETF<\/td>IROC<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco Short Duration Total Return Bond ETF<\/td>GTOS<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco Short Term Treasury ETF<\/td>TBLL<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Invesco Variable Rate Investment Grade ETF<\/td>VRIG<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    Manzil Russell Halal USA Broad Market ETF<\/td>MNZL<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    Matrix Advisors Value ETF<\/td>QHDG<\/td>US Equity ETF<\/td>\n<\/tr>\n
    SPDR\u00ae Bloomberg Enhanced Roll Yield Commodity Strategy No K-1 ETF<\/td>CERY<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae Galaxy Digital Asset Ecosystem ETF<\/td>DECO<\/td>US Equity ETF<\/td>\n<\/tr>\n
    SPDR\u00ae Galaxy Hedged Digital Asset Ecosystem ETF<\/td>HECO<\/td>US Option Based ETF<\/td>\n<\/tr>\n
    SPDR\u00ae Galaxy Transformative Tech Accelerators ETF<\/td>TEKX<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    SPDR\u00ae S&P Emerging Markets ex-China ETF<\/td>XCNY<\/td>Global Equity ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA IG Public & Private Credit ETF<\/td>PRIV<\/td>Global Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA IG Public & Private Credit ETF<\/td>PRIV<\/td>Global Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2026 Corporate Bond ETF<\/td>MYCF<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2026 Municipal Bond ETF<\/td>MYMF<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2027 Corporate Bond ETF<\/td>MYCG<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2027 Municipal Bond ETF<\/td>MYMG<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2028 Corporate Bond ETF<\/td>MYCH<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2028 Municipal Bond ETF<\/td>MYMH<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2029 Corporate Bond ETF<\/td>MYCI<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2029 Municipal Bond ETF<\/td>MYMI<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2030 Corporate Bond ETF<\/td>MYCJ<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2030 Municipal Bond ETF<\/td>MYMJ<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2031 Corporate Bond ETF<\/td>MYCK<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2031 Municipal Bond ETF<\/td>MYMK<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2032 Corporate Bond ETF<\/td>MYCL<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2033 Corporate Bond ETF<\/td>MYCM<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2034 Corporate Bond ETF<\/td>MYCN<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    SPDR\u00ae SSGA My2035 Corporate Bond ETF<\/td>MYCO<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    State Street\u00ae Communication Services Select Sector SPDR\u00ae Premium Income ETF<\/td>XLCI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Consumer Discretionary Select Sector SPDR\u00ae Premium Income ETF<\/td>XLYI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Consumer Staples Select Sector SPDR\u00ae Premium Income ETF<\/td>XLSI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Energy Select Sector SPDR\u00ae Premium Income ETF<\/td>XLEI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Financial Select Sector SPDR\u00ae Premium Income ETF<\/td>XLFI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Health Care Select Sector SPDR\u00ae Premium Income ETF<\/td>XLVI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Industrial Select Sector SPDR\u00ae Premium Income ETF<\/td>XLII<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Materials Select Sector SPDR\u00ae Premium Income ETF<\/td>XLBI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Real Estate Select Sector SPDR\u00ae Premium Income ETF<\/td>XLRI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Short Duration IG Public & Private Credit ETF<\/td>PRSD<\/td>Global Fixed Income ETF<\/td>\n<\/tr>\n
    State Street\u00ae Short Duration IG Public & Private Credit ETF<\/td>PRSD<\/td>Global Fixed Income ETF<\/td>\n<\/tr>\n
    State Street\u00ae SPDR\u00ae Portfolio S&P 500\u00ae ETF<\/td>SPYM<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae SPDR\u00ae Portfolio S&P Sector Neutral Dividend ETF<\/td>SPDG<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae SPDR\u00ae Portfolio Treasury ETF<\/td>SPTB<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    State Street\u00ae SPDR\u00ae Portfolio Ultra Short T-Bill ETF<\/td>SPTU<\/td>US Fixed Income ETF<\/td>\n<\/tr>\n
    State Street\u00ae SPDR\u00ae S&P\u00ae Leveraged Loan ETF<\/td>LVLN<\/td>Global Fixed Income ETF<\/td>\n<\/tr>\n
    State Street\u00ae Technology Select Sector SPDR\u00ae Premium Income ETF<\/td>XLKI<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae US Equity Premium Income ETF<\/td>SPIN<\/td>US Equity ETF<\/td>\n<\/tr>\n
    State Street\u00ae Utilities Select Sector SPDR\u00ae Premium Income ETF<\/td>XLUI<\/td>US Equity ETF<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n","protected":false},"excerpt":{"rendered":"

    The ETF constituent list data files are undergoing a major upgrade.  The structure of the current files will remain in place for the next two weeks, through December 15, 2025.  Many previously blank values will now be filled in.  In particular, the BBG-ID (FIGI) column is more complete, along with the DividendAmt, XDate, and DividendYield […]<\/p>\n","protected":false},"author":3864,"featured_media":494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[30,2],"tags":[],"class_list":["post-493","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-exchange-traded-fund-information","category-etf-additions"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/posts\/493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/users\/3864"}],"replies":[{"embeddable":true,"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/comments?post=493"}],"version-history":[{"count":6,"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/posts\/493\/revisions"}],"predecessor-version":[{"id":504,"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/posts\/493\/revisions\/504"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/media\/494"}],"wp:attachment":[{"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/media?parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/categories?post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterdatareports.com\/forum\/wp-json\/wp\/v2\/tags?post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}