Data Items behind Shareholder History Screen
Hi Community,
I have a question: How can I find the Data Items behind the "Shareholder Report" in its specific configuration as it is displayed in Eikon? By "Data Items" i mean the very specific TR.CODES and the parameter implemented to retrieve the displayed results as can be seen in the attached Screenshot:
My ultimate goal is to get the same output via python and the API.
Kind regards
Best Answer
-
Hi @s2782245 ,
Hovering your cursor on the column, such as the % Outstanding one, the [?] button will be shown up. If you click on this, the field definition and the Excel function used to retrieve this data will be shown on the pop-up
from this Excel function
Excel Function: =TR("SIEGn.DE@RIC","TR.PctOfSharesOutHeld")
It can be converted to this Python code
df, err = ek.get_data(['SIEGn.DE@RIC'], [ 'TR.PctOfSharesOutHeld'])
dfand with other columns field name
df, err = ek.get_data(['SIEGn.DE@RIC'],
[ 'TR.FirmInvestorId',
'TR.PctOfSharesOutHeld',
'TR.SharesHeld',
'TR.SharesHeldChange',
'TR.SharesHeldValue',
'TR.HoldingsDate',
'TR.FilingType',
'TR.InvParentType',
'TR.InvestorType',
'TR.TotalEquityAssets',
'TR.InvInvestmentStyleCode',
'TR.OwnTrnverRating', # 0 = N/A, 1 = Low, 2 = Medium, 3 = High
'TR.InvestorAddrCity',
'TR.InvAddrCountry',
# 'TR.ConsHoldPctPortfolio'
])
dfHere's the result
Hope this helps and please let me know in case you have any further questions
0
Answers
-
thank you very much for your reply. I would say that is the first step in the right direction. However, I would like to "replicate" the very same answer as I get on the desktop application. On the desktop application I can retrieve the information for the last eight quarters with one simple click. Is there a possibility to pass "the last eight quarters" as an argument within the code in python? So that I can obtain with one request the same output as displayed in the desktop application?
Kind regards
0 -
Hi @s2782245 ,
The moderators on this forum do not have deep expertise in
every type of content available through Refinitiv products. Such expertise is
available through Refinitiv Helpdesk. If the Helpdesk can show you how to
retrieve it using =@TR formula in Eikon Excel, then
the moderators on this forum can help you translate it into get_data method in Eikon Data API call. Refinitiv Helpdesk can
be reached via MyRefinitiv. To be of help, I have opened a support case on your behalf, case 12820708, please expect an Eikon support
expert to reach out to you shortly, via the email address you registered on the
developers portal.Hope this helps.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛