get data screener --> ticker / symbol translation

mjg

for a "get_data" call that pulls in MNA fields with a screener,

how do i get back any semblance of a normal ticker? for AAPL, ... AAPL, or AAPL.O or whatever?

based on searches for querying for MNA, i am able to do this:

data = ek.get_data(

"SCREEN(U(IN(DEALS)),BETWEEN(TR.MnAAnnDate,20220314,20220314))",

[

"TR.MnAAnnDate",

"TR.MnATarget",

"TR.MnATargetPermId",

"TR.MnAAcquiror",

"TR.MnAAcquirorPermId"]

)

to get back useful 'symbols' or 'tickers', based on searches in the developer community, i have tried guesses like:

"TR.ExchangeTicker", (seems to be a real field in other queries)

"TR.TickerSymbol", (seems to be a real field in other queries)
"TR.MnAAcquirorTickerSymbol" (i just guessed at this one)

and so on...

and those fail. is the mna screener instrument list argument somehow leading to an outcome different than other queries that let you specify

"TR.ExchangeTicker", (seems to be a real field in other queries)

"TR.TickerSymbol", (seems to be a real field in other queries)

specifically, can i get or translate what comes back from the query into an actual security i can trade or associate with other data. i see that "MnATargetPermId" comes back. but how do i translate that to a ticker, or some other actually useful identifier?

i would think at worst there should be a translator/adapter for perm id i can call. at most there should be a native field in the screener or query that can deliver something besides permid.

Jirapongse

@mjg

I checked and found that the Ticker and RIC fields may not be available in the Deals screener. You may need to contact the Eikon Excel or Eikon Screener support team via MyRefinitiv directly to confirm it.

However, you can use Eikon Data API to convert PermIDs to RICs, as shown below.

ek.get_data(list(map(str,  data["Acquiror PermID"].tolist())),["TR.RIC","TR.CommonName"])[0]

However, some companies may not have RICs because they are private companies.