I want to generate a table of ETFs listed in the US and declared benchmarks. The idea is that I want to have the possibility to use the benchmark as a proxy of the ETF to run longer backtests when appropriate.
Among cheap data vendors, there is a nice table provided by ETF Global on Quandl that does the job. However, there is no ISIN or SEDOL for the ETFs and no identifiers for the benchmark, making not possible to automatically download the corresponding total return time series from Thomson Reuters or Bloomberg afterwards.
I've spent hours with Eikon, Datastream and chatting with the support to create this table using Thomson Reuters data, but many benchmarks are wrong or missing. I do not have access to Bloomberg.
Question: is it possible to retrieve such table from Bloomberg or Thomson Reuters?