Exchange Traded Fund (ETF) Holdings and Weights, Index Constituent Lists, and Daily Data Update

Sample reports available here (click on the symbol.name):

• IWM - iShares Russell 2000 ETF

• QQQ - Invesco QQQ Trust Series I

• VTI - Vanguard Total Stock Market ETF

• XLK - SPDR Technology Select Sector SPDR Fund

• SPY - SPDR S&P 500 ETF Trust

Once subscribed, individual curent reports on ETFs like these are available for daily download.  Download these reports by clicking on the above links (no sign up of any kind required).  Once subscribed, the full downloadable report contains all the available ETF reports in one file.

To sign up for immediate access to all the current files, email here or go to https://www.americanetp.com/amember/signup/Arhun2Iz  (no credit card required)

Bloomberg IDs (FIGIs) now included in constituent list holdings files.

What We Provide

• AmericanETP does not sell data. We collect it on behalf of our subscribers and deliver it in aggregated, daily updated CSV files that you download and use to make investment decisions. You may use this data:
• internally within your firm
• in client reports
• on your website
• or in distribution workflows
  
  All files are consistently formatted to eliminate cleanup work and support automated processing.

Daily ETF & Index Updates

AmericanETP updates all Loading… ETF (Loading…) and index (Loading…) constituent lists daily. The primary update begins at approximately 6:00 PM EST, collecting holdings directly from ETF sponsors and index providers. A second update for select ETF families and corrections is performed shortly after the U.S. market open and published by approximately noon EST and as complete. All values are processed, validated, and written to uniform CSV files for download. Reports include current ETF holdings lists, ETF constituent weighting, constituent shares held, sector and much more.  Constituent values include sector, industry, sub-industry, shares outstanding, market cap, earnings, P/E ratio, dividend, CUSIP and ISIN. Click here for the current list of values provided. 

What a Subscription Includes

The Index and ETF Constituent Holdings List File

Methodology

This file includes the following for all ETFs and indexes:  Sponsor, Composite Ticker, Composite Name, Constituent Name, Weighting, Identifier, Date, Location, Exchange, Total Shares Held, Notional Value, Market Value, Sponsor Sector, Last Trade, Currency, Exchange, NAICSSector, NAICSSubIndustry, Coupon, Maturity, Rating, Type, SharesOutstanding, MarketCap, Earnings, PE Ratio, Face, TimeZone, DividendAmt, XDate, DividendYield, RIC, IssueType, NAICSSector, NAICSIndustry, NAICSSubIndustry

Identifiers Included

Constituent Ticker, Bloomberg Symbol, LEI, SEDOL, CUSIP,  ISIN, BBG_ID (aka FIGI)

This file and all datafiles are delivered in CSV format for compatibility with Excel, databases, and automated workflows. This structure supports sorting, filtering, merging, and relationship analysis across thousands of securities.  Individual ETF files are available.  The current full file is over one million rows, too large to open in Excel, so we broke it into two parts also, each of which open easily in Excel.  Both the full file and the two smaller files are provided for your download.

Includes constituent list archives beginning as early as July, 2009 (immediate access for annual subscriptions.  After 3 months of monthly subscriptions.).

Index and ETF coverage

Fundamentals File

The ETF fundamentals file includes numerous current values including ETF description, expense ratio, number of holdings, ETF type, inception date, identifiers (CUSIP and ISIN) and much more.  Click here for the current list of values provided.

Reliability and Trust

About AmericanETP

Compiled and managed by over 50 years of professional investment industry experience.  AmericanETP serves exchanges data venders, banks, hedge funds, money managers, and ETF-focused platforms, globally.  Data is never outsourced and is produced entirely within the United States.  We have been doing this since 1990.