API dividends estimates

Question 3 – In our code we aim to capture all future dividends using the future dividend cashflows and dividends that have gone XD in the current month up to the current date. Intermediate Capital Group (SEDOL = BYT1DJ1) has no future dividend expectations however is going XD-Div on the 12-June based on the bottom rows. Therefore, our code does not capture this dividend as it has not yet gone XD-Div but has no forward dividends. Therefore, I am looking for an alternative way for us to capture this dividend.
client is using this api code
import lseg.data as ld
ld.open_session()
SEDOLs = '7021963'
def transform_ric(ric):
parts = ric.split('.', 1) # Split into two parts at the first "."
return parts[0] + 'DIVCF.' + parts[1] if len(parts) > 1 else ric + 'DIVCF'
def transform_row80_4(value):
value=value.strip()
if len(value) >= 4 and value[-4] == ' ':
return value[-3:]
else:
return 'No_FX'
# Grab ric code and dividend currency for each stock based on SEDOL
equity_parameters = ld.get_data(universe = SEDOLs, fields = ['TR.RIC'])
#Transform RICs and amend to code type used for fwd dividends
if equity_parameters is not None:
df_equity_codes = equity_parameters.dropna(subset=['RIC'])
else:
df_equity_codes = equity_parameters
df_equity_codes['Div RIC'] = df_equity_codes['RIC'].apply(transform_ric)
equity_static = ld.get_data(universe = SEDOLs, fields = ['TR.RegCountryCode'])
# Fields for retreiving forward dividend details
fields = [
'ROW80_1',
'ROW80_4',
'ROW80_7',
'ROW80_8',
'ROW80_9',
'ROW80_10',
'ROW80_11',
'ROW80_12',
'ROW80_13',
'ROW80_14',
'ROW80_15',
'ROW80_16',
'ROW80_17',
'ROW80_18',
'ROW80_19',
'ROW80_20',
'ROW80_21',
'ROW80_22',
]
RICs = df_equity_codes['Div RIC'].tolist()
# Retreive forward dividends estimates from LSEG
equity_fwd_dvd = ld.get_data(universe = RICs, fields = fields)
Answers
-
Thank you for reaching to us.
I tested the code and found that the client is using DB1GnDIVCF.F which is an invalid RIC.
First, the code gets TR.RIC of 7021963 and the TR.RIC is DB1Gn.F.
Then, it uses the following function to get a DIV RIC.
def transform_ric(ric):
parts = ric.split('.', 1) # Split into two parts at the first "."
return parts[0] + 'DIVCF.' + parts[1] if len(parts) > 1 else ric + 'DIVCF'This function returns DB1GnDIVCF.F. I am not sure if this is a correct way to get a DIV RIC.
Finally, the client used this DIV RIC (DB1GnDIVCF.F) to get the ROW80_xxx fields and the API returned "The record could not be found' for the instrument 'DB1GnDIVCF.F' Requested universes: ['DB1GnDIVCF.F']" which indicates that this DIV RIC is invalid.
This could be a content question. Please contact the content team regarding how to get dividends estimates from this SEDOL (7021963).
0 -
Hi need help regarding client's follow up
Is there a way to automate retrieving the forecast dividends RIC from the SEDOl. Eg. Is there a script to pull DB1GnDIVCF.DE from SEDOL 7021963 so I don’t have to find them all. Our list of SEDOLs may also change each month so need it to be an automated process.
0 -
This could be a content question. Please contact the content team regarding how to get dividends estimates from this SEDOL (7021963).
If we can retrieve it via the Workspace Excel, we may be able to convert the Workspace Excel functions to Python code.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 697 Datastream
- 1.5K DSS
- 632 Eikon COM
- 5.2K Eikon Data APIs
- 12 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 4 Trading API
- 2.9K Elektron
- 1.4K EMA
- 256 ETA
- 563 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 281 Open PermID
- 46 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 750 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 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
- 122 Open DACS
- 1.1K RFA
- 107 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 96 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛