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 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.

There are now three additional files being generated.  Each of these filenames is exactly the same as the normal filenames, but with an “X” in the name.  These are the new files in each of the categories:

  1. ConstituentData42X.csv (Both major US and global indexes and US traded ETFs)
  2. ETFData42X.csv (US traded ETFs)
  3. IndexData42X.csv (Major US and global indexes)

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.

We now cover 3030 ETPs and 117 US and global indexes.

For a free look at the current files please click here (no credit card required).

Please let me know if I can help at lc@americanetp.com.

70 additional ETFs are now included in the ConstituentData42.csv File, ETFDATA42.csv file, and Fundamentals.csv file as follows:

NameTickerETF Type
ARS Core Equity Portfolio ETFACEPUS Equity ETF
CSOP Bloomberg Barclays China Treasury + Policy Bank Bond Index ETF3199.HKGlobal Equity ETF
CSOP CSI 500 ETF3005.HKGlobal Equity ETF
CSOP ICBC S&P New China Sectors ETF3167.HKGlobal Equity ETF
CSOP MSCI China A 50 Connect ETF3003.HKGlobal Equity ETF
CSOP SZSE ChiNext ETF3147 HKGlobal Equity ETF
Defined Duration 10 ETF DDXDDXUS Fund of Funds ETF
Defined Duration 20 ETFDDXXUS Fund of Funds ETF
Defined Duration 5 ETFDDVUS Fund of Funds ETF
EA Series TrustSFGVUS Equity ETF
EA Series Trust - Arin Tactical Tail Risk ETFATTRUS Option Based ETF
Invesco Core Fixed Income ETFGTOCUS Fixed Income ETF
Invesco CurrencyShares® Australian Dollar TrustFXACommodity Based ETF
Invesco CurrencyShares® British Pound Sterling TrustFXBCommodity Based ETF
Invesco CurrencyShares® Canadian Dollar TrustFXCCommodity Based ETF
Invesco CurrencyShares® Euro TrustFXECommodity Based ETF
Invesco CurrencyShares® Japanese Yen TrustFXYCommodity Based ETF
Invesco CurrencyShares® Swiss Franc TrustFXFCommodity Based ETF
Invesco Equal Weight 0-30 Year Treasury ETFGOVIUS Fixed Income ETF
Invesco Fundamental High Yield® Corporate Bond ETFPHBUS Fixed Income ETF
Invesco Intermediate Municipal ETFINTMUS Fixed Income ETF
Invesco National AMT-Free Municipal Bond ETFPZAUS Fixed Income ETF
Invesco New York AMT-Free Municipal Bond ETFPZTUS Fixed Income ETF
Invesco Rochester High Yield Municipal ETFIROCUS Fixed Income ETF
Invesco Short Duration Total Return Bond ETFGTOSUS Fixed Income ETF
Invesco Short Term Treasury ETFTBLLUS Fixed Income ETF
Invesco Variable Rate Investment Grade ETFVRIGUS Fixed Income ETF
Manzil Russell Halal USA Broad Market ETFMNZLGlobal Equity ETF
Matrix Advisors Value ETFQHDGUS Equity ETF
SPDR® Bloomberg Enhanced Roll Yield Commodity Strategy No K-1 ETFCERYUS Fixed Income ETF
SPDR® Galaxy Digital Asset Ecosystem ETFDECOUS Equity ETF
SPDR® Galaxy Hedged Digital Asset Ecosystem ETFHECOUS Option Based ETF
SPDR® Galaxy Transformative Tech Accelerators ETFTEKXGlobal Equity ETF
SPDR® S&P Emerging Markets ex-China ETFXCNYGlobal Equity ETF
SPDR® SSGA IG Public & Private Credit ETFPRIVGlobal Fixed Income ETF
SPDR® SSGA IG Public & Private Credit ETFPRIVGlobal Fixed Income ETF
SPDR® SSGA My2026 Corporate Bond ETFMYCFUS Fixed Income ETF
SPDR® SSGA My2026 Municipal Bond ETFMYMFUS Fixed Income ETF
SPDR® SSGA My2027 Corporate Bond ETFMYCGUS Fixed Income ETF
SPDR® SSGA My2027 Municipal Bond ETFMYMGUS Fixed Income ETF
SPDR® SSGA My2028 Corporate Bond ETFMYCHUS Fixed Income ETF
SPDR® SSGA My2028 Municipal Bond ETFMYMHUS Fixed Income ETF
SPDR® SSGA My2029 Corporate Bond ETFMYCIUS Fixed Income ETF
SPDR® SSGA My2029 Municipal Bond ETFMYMIUS Fixed Income ETF
SPDR® SSGA My2030 Corporate Bond ETFMYCJUS Fixed Income ETF
SPDR® SSGA My2030 Municipal Bond ETFMYMJUS Fixed Income ETF
SPDR® SSGA My2031 Corporate Bond ETFMYCKUS Fixed Income ETF
SPDR® SSGA My2031 Municipal Bond ETFMYMKUS Fixed Income ETF
SPDR® SSGA My2032 Corporate Bond ETFMYCLUS Fixed Income ETF
SPDR® SSGA My2033 Corporate Bond ETFMYCMUS Fixed Income ETF
SPDR® SSGA My2034 Corporate Bond ETFMYCNUS Fixed Income ETF
SPDR® SSGA My2035 Corporate Bond ETFMYCOUS Fixed Income ETF
State Street® Communication Services Select Sector SPDR® Premium Income ETFXLCIUS Equity ETF
State Street® Consumer Discretionary Select Sector SPDR® Premium Income ETFXLYIUS Equity ETF
State Street® Consumer Staples Select Sector SPDR® Premium Income ETFXLSIUS Equity ETF
State Street® Energy Select Sector SPDR® Premium Income ETFXLEIUS Equity ETF
State Street® Financial Select Sector SPDR® Premium Income ETFXLFIUS Equity ETF
State Street® Health Care Select Sector SPDR® Premium Income ETFXLVIUS Equity ETF
State Street® Industrial Select Sector SPDR® Premium Income ETFXLIIUS Equity ETF
State Street® Materials Select Sector SPDR® Premium Income ETFXLBIUS Equity ETF
State Street® Real Estate Select Sector SPDR® Premium Income ETFXLRIUS Equity ETF
State Street® Short Duration IG Public & Private Credit ETFPRSDGlobal Fixed Income ETF
State Street® Short Duration IG Public & Private Credit ETFPRSDGlobal Fixed Income ETF
State Street® SPDR® Portfolio S&P 500® ETFSPYMUS Equity ETF
State Street® SPDR® Portfolio S&P Sector Neutral Dividend ETFSPDGUS Equity ETF
State Street® SPDR® Portfolio Treasury ETFSPTBUS Fixed Income ETF
State Street® SPDR® Portfolio Ultra Short T-Bill ETFSPTUUS Fixed Income ETF
State Street® SPDR® S&P® Leveraged Loan ETFLVLNGlobal Fixed Income ETF
State Street® Technology Select Sector SPDR® Premium Income ETFXLKIUS Equity ETF
State Street® US Equity Premium Income ETFSPINUS Equity ETF
State Street® Utilities Select Sector SPDR® Premium Income ETFXLUIUS Equity ETF