Companies missing from historical ASX 100 data retrieved with Python API

jack.simpson0
jack.simpson0
in Eikon Data APIs

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?

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov
    Answer ✓

    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.

Categories