question

Upvotes
Accepted
IoannisG avatar image
54 ●1 ●0 ●5

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?

#contentpython apirefinitiv-data-libraries
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

· Write an Answer
Upvotes
Accepted
IoannisG avatar image
54 ●1 ●0 ●5

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'.


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
nick.zincone avatar image
18.9k ●85 ●39 ●63

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).

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.