Industry codes in MnA

nmcp

I need granular NAICS codes for MnA deals. However, I only seem to get industry labels and descriptions. Merging these back to codes would be extremely painful. How can I pull these with TR.MnA through the API? If this isn't possible, does Eikon provide a match table?

nmcp

For column names, I can see that you can switch between field_name=True and False and either receive the code or the label of the variable name. How can I switch to values instead of labels for the output/observations?

Sample code:

# SCREEN query with additional condition to exclude empty TR.MnATarget

query = (    'SCREEN(U(IN(DEALS)),'    'IN(TR.MnATRBCActivity,"5020101011"),'    'IN(TR.MnADealType,"DI","UN","SP"),'    'IN(TR.MnAAcquirorNation, "US"),' # Filter for Acquiror Nation = United States    'TR.MnAAnnDate > "2020-01-01")' # Filter for Deals announced after 2016)

fields = [    'TR.MnASDCDealNumber', 'TR.MnAStatus', 'TR.MnADealType', 'TR.MnAAnnDate',     'TR.MnATarget', 'TR.MnATargetPermId', 'TR.MnATargetSDCCusip',    'TR.MnAPriNaics', 'TR.MnATargetPriNaics22', 'TR.MnATargetPriSic',    'TR.MnANaics', 'TR.MnATargetNaics22', 'TR.MnATargetSic',     'TR.MnAAcquiror', 'TR.MnAAcquirorPermId', 'TR.MnAAcquirorSDCCusip',    'TR.MnAAcquirorNation']

example_data, err = tr.get_data(query, fields, field_name=True)

Jirapongse

@nmcp

Thank you for reaching out to us.

I used the formula builder in the Eikon/Workspace excel and found a lot of NAIC fields under the Mergers & Acquisitions category.

As this forum is dedicated to technical queries on API products, if you have any futher questions, please contact the helpdesk directly via MyAccount. The helpdesk can check if there are any TR.MnA fields that can provide the required data.

nmcp

Thank you for your reply! It seems I did not ask my question clearly - I can indeed pull these items from the API. However, the result is not a code (e.g., 311119) but the description (e.g., Other Animal Food Processing). The latter is not helpful. How can I adjust my query so that I obtain values of codes (e.g., 311119), not the labels or descriptions?

Jirapongse

@nmcp

I can't find any TR.MnA fields that can provide NAIC codes. You need to contact the helpdesk directly via MyAccount to confirm this.

nmcp

Thanks! It's possible to query on codes, so they seem to be there in the backend. This is extremely frustrating, and I don't understand the reasoning behind providing the product in this limited way. I'll reach out to support.