How can I retrieve Dividend announcement dates?

Hello,

I'm trying to pull dividend announcement data through the eikon.get_data() function. I can pull ex-dividend dates but I'm not sure if there is functionality to pull the dividend announcement dates. I am using the following function:

start_date = '2021-06-01'
end_date = '2021-06-03'
instr, err = ek.get_data('0#.SPX','TR.IndexConstituentRIC')
instr = instr['Constituent RIC'].tolist() 
# Remove duplicates, None and empty strings from the list
instr = list(dict.fromkeys(instr))
instr = list(filter(None, instr))
instr = list(filter(str.strip, instr))
events_df, err = ek.get_data(instr,['TR.EventStartDate','TR.EventType','TR.EventTitle'],
                            {'SDate':start_date, 'EDate':end_date, 'EventType':'EXDIV'})
events_df.rename(columns = {'Event Start Date':'Event Date'}, inplace = True)
events_df = events_df[['Event Date','Instrument','Company Event Type','Event Title']]
events_df['Event Date'] = pd.to_datetime(events_df['Event Date'])
events_df.dropna(subset = ['Event Date'], inplace=True)
events_df

The github resource (https://github.com/Refinitiv-API-Samples/Example.EikonAPI.Python.CompanyEvents/blob/master/CompanyEventsCalendar.ipynb) I was using did not list announcement date as one of the event types. Is it possible to pull this data down?

Ideally I would like the output in the "Event Name" column in Eikon, show below:

image

Thanks.

Best Answer

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.