Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by AAMZ · Sep 11, 2020 at 05:51 PM · datastream-apidsws-apiequitiesexchanges

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Jirapongse · Sep 18, 2020 at 02:12 AM

@AAMZ

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.



1600394810279.png (20.8 KiB)
1600394859427.png (13.1 KiB)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Jirapongse ♦♦ · Sep 18, 2020 at 02:13 AM 0
Share

MyRefinitiv Get Support.

1600395159071.png (20.3 KiB)
avatar image
REFINITIV
Answer by Jirapongse · Sep 14, 2020 at 06:55 AM

@AAMZ

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.



1600066526999.png (15.0 KiB)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
AAMZ · Sep 15, 2020 at 09:51 AM 0
Share

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.

  
                   
  1. 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)

  
                   
  1. 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.

  
                   
  1. sec = ds.get_data(tickers='ATXWBIX|L',fields=['MNEM'],kind=0)

Would you have any further thoughts on these two questions?

Many thanks again

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

How can I call a full list of companies listed in one country (e.g., Australia) in a specific year (e.g., 2005)?

Unable to download equity indices data using Datastream

How to get the free float shares outstanding on country level

Equities Data - S&P/Nasdaq/DAX filtered by financial/accounting numbers possible to create?

using schedual task in windows to run Data Stream request

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges