search

JerBouma / FinanceDatabase

This is a database of 300.000+ symbols containing Equities, ETFs, Funds, Indices, Currencies, Cryptocurrencies and Money Markets.
https://www.jeroenbouma.com/projects/financedatabase
MIT License
3.07k stars 357 forks source link

[FR] List of ETFs and stocks #73

Closed sam1946 closed 5 months ago

sam1946 commented 5 months ago

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

Thanks!

JerBouma commented 5 months ago

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.

Screenshot 2024-01-21 at 18 12 54

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 commented 5 months ago

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