Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by henry.hildebrandt · Oct 01, 2018 at 06:09 PM · python api eikonpandasdataframeshareholders

How can I import a shareholder history report through the eikon python API?

I would like to import a shareholder history report for a company as a pandas dataframe, i.e. at least the absolute amount of capital invested and the changes therein. Preferably though I would like to get the complete shareholder history report in the same structure as you can simply download it in excel. I have not been able to find the respective code for that in the instrument browser. If someone would be able to provide a coding example, that would be very helpful! Thanks in advance

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Oct 02, 2018 at 06:45 AM

@henry.hildebrandt

So, this will give you the current snapshot:

df, e = tr.get_data('TRI.N', ['TR.SharesHeld.InvestorPermID', 'TR.SharesHeld.Value'], {'SDate':'0D'})

This - last calendar year end:

df, e = tr.get_data('TRI.N', ['TR.SharesHeld.InvestorPermID', 'TR.SharesHeld.Value'], {'SDate':'0CY'})

You can issue a second request to look up which perm id represents which company:

codes = df['Investor Perm Id'].apply(lambda x: f'{x:.0f}').tolist()
cmp, e = tr.get_data(codes, ['TR.CommonName'])


screenshot-2018-10-02-at-114510.png (206.2 KiB)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ · Oct 08, 2018 at 04:28 AM 0
Share

You can also use a TR.InvestorFullName field to get the full name of the investor.

df, e = ek.get_data('TRI.N', ['TR.InvestorFullName', 'TR.SharesHeld'], {'SDate':'0D'})

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

For 2 stocks listed on same exchange I get different number of rows of historical data and missing minutes

I need a key for python Beta product. How do get a key generated?

Download indices in percentages

If I am trying to convert tickers to RIC's which Eikon Api do I need?

Screener APP and Primariness.

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges