Couldn't find deal with API

m.titov.sergey
m.titov.sergey Newcomer
in Eikon Data APIs

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.

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    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)

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Quick Links

Categories