Earnings surprice for delisted stocks

Hello,


I have a list of 569 stocks on the Oslo stock exchange. I need to get the earning surprise on these stocks from 1993 - 2019. However, some of these stocks have been delisted. Is there any way for me to get the data I am looking for through the Eikon API?

Best Answer

  • Hi @s1815675

    To retrieve a small set of instruments, you can utilize the following code. It's worth noting the reported earnings date may be different for each instrument. I would suggest for processing purposes, you may want to consider performing your request in smaller batches.

    1678915955199.png

Answers

  • Hi @s1815675

    Can you provide a few examples of some of the stocks that are delisted?

  • Yes, for example:
    • AAV.OL
    • SCS.OL
    • EKJ.OL

    Now these tickers do not include the "delisting code" that refinitiv uses.

  • Hi @s1815675

    I don't know what you mean by 'delisting code', but when I plug in the above delisted instruments into the code I have below, no data is returned.

    As I suggested, you can open a ticket within the support desk and mention whether you can access any of these delisted instruments within Excel.