Obtain both active and inactive stocks on an exchange using Datastream
Hello,
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
Best Answer
-
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.
0
Answers
-
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.
0 -
Thank you very much for this answer. I'm trying to implement the formula, having also looked at the two links in the answer, however I'd need some further help:
Implementing the following works fine, just as you wrote.
sec = ds.get_data(tickers='LFTSE100|L',fields=['MNEM'],kind=0)
However, when I try to get the constituents as at August 2020 (as per the thread you indicated)
sec = ds.get_data(tickers='LFTSE1000820|L',fields=['MNEM'],kind=0)
I receive the same results and output date (i.e. as at 14 September 2020).
In addition, when I try the formula above with the Vienna Stock Exchange, I do not get any results. However, this is strange because when I perform a static request using the Excel plugin, I can see all of the constituents of this index, so I know they're available.
sec = ds.get_data(tickers='ATXWBIX|L',fields=['MNEM'],kind=0)
Would you have any further thoughts on these two questions?
Many thanks again
0 -
Thank you very much for this answer. I'm trying to implement the formula, having also looked at the two links in the answer, however I'd need some further help:
Implementing the following works fine, just as you wrote.
sec = ds.get_data(tickers='LFTSE100|L',fields=['MNEM'],kind=0)However, when I try to get the constituents as at August 2020 (as per the thread you indicated)
sec = ds.get_data(tickers='LFTSE1000820|L',fields=['MNEM'],kind=0)I receive the same results and output date (i.e. as at 14 September 2020).
In addition, when I try the formula above with the Vienna Stock Exchange, I do not get any results. However, this is strange because when I perform a static request using the Excel plugin, I can see all of the constituents of this index, so I know they're available.
sec = ds.get_data(tickers='ATXWBIX|L',fields=['MNEM'],kind=0)Would you have any further thoughts on these two questions?
Many thanks again
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛