The Rydex funds (now Guggenheim) missing from our constituent list file (constituentdata42.csv) since mid December, 2012, have now been restored. Today’s file has been rerun and is now on the server for download. In the process, Guggenheim informed us of a recent press release announcing that 9 funds are being discontinued. Click here for the Guggenheim press release.
Updated every day, we now collect over 1100 ETF and 366 index constituent lists and provide them in one easily downloaded file. Click here for more information about our index and ETF constituent lists
Two new values are now included in the ConstituentData42.csv file, DividendAmt (dividend amount) and LastDividendDate (last dividend date). If the file is opened in Excel, this would be columns AF and AG. Dividend information is now provided for both ETFs and all constituents and will be updated monthly with other fundamental data.
A question was asked about the columns labeled “FutVal”. “FutVal” (future value) columns are placeholders so that when new values are added to the file, they will not disrupt your input routines. New “FutVal” columns will never be arbitrarily “added” to the existing file for the same reason. That, too, would disrupt your input routines. When and if we run out of space for new values in the existing structure, a totally new file will be created and made available while the existing file also continues to be made available. Both will be generated for a period of time to give you time to transition to the new file.
For more information about index and ETF constituent lists go to http://www.masterETFdata.com.
Thank you for your continued support. Your input is always appreciated.