Methodology

AmericanETP updates all ETF and index constituent lists twice daily.

Primary Update (6:00 PM EST)

We collect holdings directly from ETF sponsors and index providers. All values are validated, normalized, and written to uniform CSV files.

Secondary Update (Shortly After Market Open)

Select ETF families receive a second update, published by approximately noon EST.

Data Processing & Validation

• Each update includes:
• constituent weight
• shares held
• sector and industry classifications
• identifiers (CUSIP, ISIN, SEDOL, BloombergSymbol, BBG_ID, LEI)
• fundamentals (market cap, earnings, P/E, dividend, etc.)
• breadth values (advancers/decliners, new highs/lows, % above 200‑day MA)

All files follow a consistent 42‑column structure to support sorting, filtering, merging, and relationship analysis across thousands of securities.

File Delivery

Files are delivered in CSV format for compatibility with:

• Excel
• databases
• automated workflows
• internal systems
• distribution platforms

The full constituent file exceeds one million rows, so it is also provided in two Excel‑friendly parts.

Archives

Constituent list archives begin as early as July 2009.