Best method to import all available tickers for certain dates?

Jonas.Nijssen

I want to import all available tickers, for example all stocks that trade in EUR, for a given date in the past. to avoid survivorship bias, I would do this for example every quarter. I am using python. In addition, which API would be best for this analysis (I intend to also download financials for the available tickers in each period)?

Thanks.

[Deleted User]

Hi @Jonas.Nijssen ,

I would suggest having a look at Screener and Search services; have you used them before for this use-case?

Jonas.Nijssen

https://community.developers.refinitiv.com/discussion/comment/107211#Comment_107211

I guess the screener could work. However this would require a new screen every period. Is this the best method available? Thanks

[Deleted User]

https://community.developers.refinitiv.com/discussion/comment/107305#Comment_107305

Hi @Jonas.Nijssen, the idea behind the programatic sreener is that you can build code to change depending of the situation. Using Excel is only really the 1st step to understand the nomenclature and grammar of Screener in Python. You can then study it to see how you can programaatically change the screener automatically so you don't have to be in front of your machine every period.

If you want this to be done automatically, you may want to look into Windows Task Scheduler to run your code automatically.