Retrieving Stock Split Data using the Eikon Data API (get_data)

I am using the Eikon Data API (Python) to retrieve various time series data (prices, volume, etc.) using the get_data function. Did anyone already successfully obtain explicit information in stock splits (effective date, ratio) using that function? if yes, which fieldnames were used?
Best Answer
-
Thank you for reaching out to us.
It is recommended to use the LSEG Data Library for Python instead of the Eikon Data API, as it offers enhanced functionality and better integration. The LSEG Data Library also includes the get_data method, which can retrieve the same data available through the Eikon Data API.
The sample code is available on GitHub.
I found this TR.CAAdjustmentFactor field which provides the multiplication factor expressing the effect of the capital change event on historical per share values. The code looks like this:
ld.get_data( universe = ['AAPL.O'], fields = ['TR.CAAdjustmentFactor(CAEventType=SSP).coraxcaanndate','TR.CAAdjustmentFactor(CAEventType=SSP)'], parameters = {'SDate':'2000-01-01','EDate':'2025-09-29'})
You can use the Data Item Browser tool to search for fields and parameters.
Otherwise, the best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.
You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data.
Then, we can help you converting that formula to Python code.
1
Answers
-
Hi Jirapongse,
many thanks for your comprehensive reply, worked well and helped a lot!
I am just wondering if there is some documentation on all the event types that could be selected. Do you know if there is a list to be found somewhere?
I am also not sure if there is a code different from SSP to be used for reverse stock splits. Do you maybe know more about that?
Kind regards,
Peter
0 -
Within the Data Item Browser (DIB), when you pull up the Data Item Code (TR.CAAdjustmentFactor), you can pull up the Parameters section which will offer a number of settings. For example, you can see a multitude of available codes for the Corporate Actions:
I don't see any specific reference to the term "reverse stock split", however, I believe the "Share Consolidation" may be referring to the reverse stock split. And if I apply this event type (SCN) to the request, I don't see any events. Now, that may be true for Apple.
However, trying another RIC, I do see one:Because these are more content-based questions, you can go through support and they will bring in a content specialist to confirm.
1
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 713 Datastream
- 1.5K DSS
- 639 Eikon COM
- 5.3K Eikon Data APIs
- 20 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 12 Trading API
- 3K Elektron
- 1.5K EMA
- 260 ETA
- 574 WebSocket API
- 42 FX Venues
- 16 FX Market Data
- 2 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 26 Messenger Bot
- 5 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 285 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 25 RDMS
- 2.3K Refinitiv Data Platform
- 20 CFS Bulk File/TM3
- 939 Refinitiv Data Platform Libraries
- 6 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 12 World-Check Customer Risk Screener
- World-Check On Demand
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 46 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 126 Open DACS
- 1.1K RFA
- 108 UPA
- 197 TREP Infrastructure
- 232 TRKD
- 925 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 107 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛