Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
alexandre.almeida avatar image
5 ●0 ●0 ●2

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

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:

srlndiv.png


refinitiv-dataplatform-eikon#technology#content
srlndiv.png (272.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
84.9k ●289 ●53 ●77

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
Jirapongse avatar image
84.9k ●289 ●53 ●77

@alexandre.almeida

Thanks for reaching out to us.

You can try this code.

df, err = ek.get_data(["SRL.N"],
                      ["TR.EventStartDate","TR.EventType","TR.EventTitle"],
                      {
                          "SDate":"2019-01-01",
                          "EDate":"2023-01-01",
                          "EventType": "ALL"
                      }
                     )


df

The output is:

1674447700296.png

For more information, please refer to the Data Item Browser and Eikon Data API in Python video which demonstrates to find available fields and parameters in Eikon Data API.


1674447700296.png (44.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
alexandre.almeida avatar image
5 ●0 ●0 ●2

Hi @Jirapongse ,

I run your code, but it hasn`t returned me the field I am looking for. I want "Regular dividends - stock" for dates 12-Nov-2021 and13-May-2021. See image bedlow:

srlndiv.png

Also, the link to Data Item Browser and Eikon Data API in Python isn't working.


srlndiv.png (272.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.