Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by jack.simpson0 · Jun 04, 2018 at 08:11 PM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonindexconstituents

How to get list of leaver companies of the ASX 100 using the Python API?

I've been using the following code to get a list of current ASX 100 companies:

ek.get_data(['.ATOIA'], ['TR.IndexConstituentRIC','TR.IndexConstituentName'])

Using the desktop program, I can also get a complete list of all the leavers and joiners in the ASX 100 over time.

Does anyone know how I can use the Python API to get a similar dataset of all the leavers of this index?

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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Jun 05, 2018 at 04:58 AM

To get the leavers for the last calendar year, for example, you need to do this:

f = ['TR.IndexJLConstituentChangeDate','TR.IndexJLConstituentName',
     'TR.IndexJLConstituentRIC','TR.IndexJLConstituentComName']
df, e = tr.get_data(['.ATOI'], fields=f, parameters={'IC':'L', 'SDate':'0D', 'EDate':'-1CY'}
Comment
jack.simpson0
mtinatin

People who like this

2 Show 5 · 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
jack.simpson0 · Jun 05, 2018 at 05:52 AM 0
Share

Thanks so much!

avatar image
datateam · Jun 12, 2018 at 12:06 PM 0
Share

Zhenya, I am looking to get a similar list for the ".UKX" index but get the following error:

{'code': 413,
   'col': 1,
   'message': 'Unable to resolve all requested identifiers.',
   'row': 0},

Could you point me to where I can get more information on the identifiers used on the call you suggest?

Thanks in advance.

avatar image
REFINITIV
Alex Putkov.1 ♦♦ datateam · Jun 12, 2018 at 12:51 PM 0
Share

".UKX" is not a valid RIC, hence the error message. One place where you can browse content available through Eikon is Content Kiosk app, which you can find by typing in "Content Kiosk" into Eikon command/search bar. Another is Eikon command/search bar where you can type in free text and select the best match from autosuggest. You may also want to browse the tutorials available under the main Eikon menu - Help - Tutorials & Training, which explain how to use Eikon to find the content you're interested in. Finally for specific questions about content you can contact Thomson Reuters Helpdesk.

avatar image
mtinatin · Jun 19, 2018 at 02:43 PM 0
Share

Hello Zhenya, I tried this piece of code with '.SPX' index and 'EDate' : '-25CY'

It gives a list of 600+ companies, with the dates that I assume denote the time company left the Index (the last ConstituentChangeDate was 1995-01-18).

When I changed the end date with -30, even -50 years, the output was still the same. Do you maybe know why is that? Thanks!

avatar image
REFINITIV
Alex Putkov.1 ♦♦ mtinatin · Jun 19, 2018 at 03:06 PM 1
Share

Most likely because we don't track changes in constituents of this index that far back. You can verify this by contacting Thomson Reuters Helpdesk and asking how far back you can track changes in index constituents for S&P 500 in Eikon.

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

Can't get constituents of Russell index

ETF constituent changes

Eikon Data API - Error requesting TR.IndexConstituentWeightPercent

Using API to pull the historical index constituents during a period of time

Time-series Total Return for Index (benchmark) eg .FTLC

  • 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