Couldn't find deal with API

Hi!

I'm currently using EIKON data API in order to acquire information about Nvidia corporate actions.
I use following expression to fetch the data:

data, err = ek.get_data(f'''SCREEN(U(IN(DEALS)),IN(TR.MnAParticipant(DealPartRole=T,A),{permids}),BETWEEN(TR.MnAOrigAnnDate,{dates}))''', fields)


where permids is Nvidia permid and dates are '20200301,20200420'.

This query supposed to return all m&a with Nvidia but I couldn't find recent deal with mellanox:
https://nvidianews.nvidia.com/news/nvidia-receives-approval-to-proceed-with-mellanox-acquisition-from-chinas-antitrust-authority

Is this flaw of my code or data?

P.s.:
Also I couldn't figure out how to fetch information about spin-offs. I would be very glad if you could help me with this too.

Best Answer

  • chavalit-jintamalit
    Answer ✓

    Hi @m.titov.sergey

    I tried to use the SCREENER app to screen a similar filter and I could not find the deal you are looking for.

    image


    I tried the same on API and received the same result.

    Code:

    syntax = 'SCREEN(U(IN(DEALS)), IN(TR.MnAParticipantRole,"T","A"), BETWEEN(TR.MnAOrigAnnDate,20200301,20200420), Contains(TR.MnACompLongName(DealPartRole=T:A),"Nvidia"), CURN=USD)'
    fields = ['TR.MnASDCDealNumber','TR.MnAAnnDate','TR.MnAAcquiror']

    df,e = ek.get_data(syntax, fields)
    df

    image

    I would suggest that you contact the Refinitiv Content Helpdesk at https://my.refinitiv.com/ to clarify if the search syntax is correct or not (I am not sure about the permids you put in on your search syntax)