[FR] List of ETFs and stocks

[sam1946]

Hi, this is less of an issue and more of a request.

• How do I get a list of all ETFs that are in the UK?
• Can I get a list of which ETF is leveraged and non-leveraged?
• Can I get a list of all stocks in an index, eg- S&P500

Thanks!

[JerBouma]

Hereby the answers:

How do I get a list of all ETFs that are in the UK?
Unfortunately this is not possible. The main purpose of the Finance Database is to allow you to look into Equities which is why you can use the Select function to search per country in that case.

Can I get a list of which ETF is leveraged and non-leveraged?

This is not supported and will most likely never be given that the main purpose is to provide general insights into Equities.

Can I get a list of all stocks in an index, eg- S&P500

You can use for example https://www.ssga.com/us/en/intermediary/etfs/library-content/products/fund-data/etfs/us/holdings-daily-us-en-spy.xlsx and extract those directly from the Finance Database Equities dataset. This should be doable for any index. I can not provide a special column for this given that it frequently changes and there are too many indices that would overlap for individual companies.

Just to let you know, maintaining the Finance Database or expanding it is very time consuming which is why the more custom fields I'd add in, the more time it will take me every week to maintain it. This is what I want to prevent as it is a free project after all.

[sam1946]

No probs and thank you for all your hard work :)