Workspace Python API fails when requesting data for some investor types

When using Workspace Python API (under Windows 10) and requesting data for some company investors, data are returned for institutional investors, but not for some other investors.

For example, the command:

df=dl.get_data('48471668160', ['TR.OrganizationID','TR.CommonName', '(TR.InvestorSharesHeld/1000000-TR.InvtrPrevSharesHeld)/TR.InvtrPrevSharesHeld', 'TR.SecurityOwnedName', 'TR.SecurityOwnedRIC', 'TR.InvestorValueHeld', 'TR.InvestorValueHeld.currency', 'TR.InvestorSharesHeld/1000000', 'TR.InvtrPrevSharesHeld'], parameters={'Scale':6,'NULL':'Blank','Curn':'NATIVE'})

produces error

RDError: Error code -1 | Unable to resolve all requested identifiers in ['48471668160'].

for '48471668160' (Bettencourt Meyers Family), but the same command works fine for '4297651992' (The Vanguard Group, Inc.) or '4295890634' (Nestle SA).

How can one use the get_data command to retrieve the required data for all investor types?

Find more posts tagged with

python api

#content

refinitiv-data-libraries

Accepted answers

IoannisG

The code: '48471668160' is correct and can be found from the query

df=rd.get_data('OREP.PA',['TR.InvestorFullName.investorpermid', 'TR.InvestorFullName','TR.InvestorType'],parameters={'EndNum':5,'SortD':'TR.PctOfSharesOutHeld/100','NULL':'Blank'})

To solve this, I have chosen to programmatically not download data for Investor Types 'Other Insider Investor'.

All comments

nick.zincone

Hi @IoannisG

It appears the code: '48471668160' is not recognized. I would suggest you contact the helpdesk (Get Help & Support - F1) within the desktop. They will bring in a content specialist to confirm the specific code to pull down this data.

What I did find was something related to: 'Francoise Bettencourt Meyers' (PermID: 4295867384).

IoannisG

The code: '48471668160' is correct and can be found from the query

df=rd.get_data('OREP.PA',['TR.InvestorFullName.investorpermid', 'TR.InvestorFullName','TR.InvestorType'],parameters={'EndNum':5,'SortD':'TR.PctOfSharesOutHeld/100','NULL':'Blank'})

To solve this, I have chosen to programmatically not download data for Investor Types 'Other Insider Investor'.

EXPLORE OUR SITES