Extracting all historical companies listed on the ASX using the Python API?

jack.simpson0
jack.simpson0
in Eikon Data APIs

I've been using Eikon to extract the historical All Ordinaries Index from the ASX at various points in time (e.g. 10 years ago). However, I need a more complete list of companies as some are missing. Does anyone know if it is possible to get a complete list at various points in time of all the companies listed on the ASX?

Tagged:

Best Answer

  • Jirapongse
    Jirapongse admin
    Answer ✓

    It looks similar to this question.

    From TR function, you can convert it to Eikon Data API, as shown below.

    data = ek.get_data(".ATOI", 
                       ["TR.IndexConstituentRIC",";TR.IndexConstituentName"],
                       {'SDate':'2016-10-01',                     
                        'CH':'Fd', 
                        'RH': 'IN'})
    data

    The output is:

    image

Answers

  • jack.simpson0
    jack.simpson0

    Apologies I accidentally added '100' to the question title when I meant how to find the complete list of all companies on the ASX (not just the 100 or 500)

  • Alex Putkov.1
    Alex Putkov.1

    I don't believe there's any way to retrieve a complete exchange listing as of a historical date using Eikon. To confirm this you may want to reach out to Thomson Reuters Helpdesk by either calling the Helpdesk number in your country or by using Contact Us capability in Eikon application. When contacting the Helpdesk ask if there's any way to retrieve complete exchange listing as of a historical date into Excel. If the Helpdesk can provide an Excel worksheet function that returns the desired result, it should be possible to replicate it using the API.

Categories