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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 1 4 5

Companies missing from historical ASX 100 data retrieved with Python API

I've been trying to retrieve a list of companies that are in the ASX 100 at various points in time. I tried this to get a list of companies 10 years ago:

ek.get_data(['.ATOIA'], ['TR.IndexConstituentRIC','TR.IndexConstituentName'], {'SDate': '-10CY'}) 

And I also tried this below based on the recommendation of Eikon support.

ek.get_data("Index(SPASX100,20080601)",["TR.PortfolioConstituentName","TR.PortfolioShares"]) 

Neither of these returns a complete list of 100 companies - there are more than a dozen companies missing in the returned dataset. Does anyone know a way to retrieve a complete list?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonapi
icon clock
10 |1500

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

1 Answer

Upvote
Accepted
4.6k 26 7 22

From the API usage perspective everything you do is correct. What I suggest is to ask your local Thomson Reuters support desk for a Eikon Excel spreadsheet, that is going to do what you expect. If there any peculiarities in the dataset, they will be visible in the spreadsheet model.

icon clock
10 |1500

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

Click below to post an Idea Post Idea