How could I get "Regular Dividends - Stock" from eikon api?

alexandre.almeida

I would like to get all the events and dividends for a ticker using the eikon api. Let`s consider the ticker SRL.N.

I am using this code below to get events:

EVT_FLDS = [
    "TR.CAExDate",
    "TR.CACorpActEventType",
    "TR.CAAdjustmentFactor",
    "TR.CAAdjustmentType",
    "TR.CATermsOldShares",
    "TR.CATermsNewShares"]
params = {"SDate": '2000-01-01',
          "EDate": '2023-01-20', 
          "CAEventType": "All"}
df_events, _ = ek.get_data(instruments=['SRL.N'], fields=EVT_FLDS, parameters=params)
df_events.dropna()[::-1]

And, I am using this code bellow for dividends:

params = {"SDate": '2000-01-01',
          "EDate": '2023-01-20',
          "dateType": "ED",
          "SORTD": "TR.DivExDate"}
DVD_FLDS = [
    'TR.DivExDate',
    'TR.DivUnadjustedGross',
    'TR.DivPaymentType',
    'TR.DivType']
df_div, _ = ek.get_data(instruments=['SRL.N'], fields=DVD_FLDS, parameters=params)
df_div.dropna()[::-1]

However, I am not able to get the "Regular dividends - stock" for dates 12-Nov-2021 and13-May-2021, as it is available at the eikon platform, see figure below:

Jirapongse

@alexandre.almeida

Yes, you are correct. It doesn't return the "Regular dividends - stock" events.

Please contact the Eikon Excel support team directly via MyRefinitiv and ask for the =@TR formula which can be used to retrieve the "Regular dividends - stock" events. Then, if the formula is available, you can apply the same formula to the get_data method to get the same data.