I'm trying to obtain both active and inactive/delisted stocks on a few exchanges, let's say the NYSE and Deutsche Börse. The period doesn't matter, I'll take everything and deal with that later.
I'm aware that this isn't possible on Eikon, both thanks to this thread and also from using the Screener in the Eikon application, as explained in this thread (and I've tried this myself now just to make sure).
I then tried with Datastream, and found that I can obtain the companies I need manually, via a Static Request, clicking around to filter equities, inactive, etc. build a list in Excel, and keep doing this manually until I build up the list of companies that I want. This is quite time consuming though, and I'm trying to find an equivalent way to do this using the Python API connecting to DatastreamWS.
Is this possible? Can you please explain how, using an example? I've tried looking this up in the API documentation but unfortunately cannot find how to do this.
Thank you very much in advance
I have searched this instrument (ATXWBIX) in the http://product.datastream.com/browse website. ATXWBIX is not a list so it can't return the constituents.
The list instrument should display like this:
I think that the correct instrument could be LATXWBIX|L.
However, you need to directly contact the datastream support via MyRefinitiv to confirm LATXWBIX and verify the data of LFTSE1000820.
You can use the same instrument and fields in Excel with the DatastreamWS.
Refer to the Getting started with Python, you can use the Datastream to request constituent Lists of instruments. For example:
You can append MMYY to obtain the list for that month, as mentioned in this thread.