We now cover 3898 ETPs.  There are over 5500 ETPs in the marketplace.  We have a ways to go.  The file containing the ETF holdings lists is currently 1,143.567 lines long.  The maximum number of rows in Excel is 1,048,576.  In other words, you cant’ open the full file in Excel.  The full file is still needed for importing into databases, but you can’t look at it in Excel?  Too many times that just doesn’t work.  So we’re adding files for download as follows:

  • ConstituentData42-1of2.csv
  • ConstituentData42-2of2.csv

Same data as the full file, but in two parts each fully openable in Excel.  The full file will continue as always (no change in structure or location).

For a free trial:  https://www.americanetp.com/amember/signup/Arhun2Iz