question

Upvotes
Accepted
canada.equity5 avatar image
7 ●2 ●2 ●3

Dividends returning old values for some stocks

I'm using the Eikon API for .NET, and for some stocks I request dividend pay dates and ex dates and they're old.

For example, 8369.T (Bank of Kyoto Ltd), I used the field names RCA.DH.ExDate and RCA.DH.PayDate and they respectively give me March 29 2017 and June 30 2017 despite the dividend that happened Sept 27. I am using the wrong fields? Why is it some stocks and not others?

I noticed in DIB in Eikon that the fields DIVPAYDATE and EXDIVDATE are correct but when I try to request them I get back that they are not valid request parameters.

eikoneikon-data-apieikon-com-apieikon-.net-api
icon clock
10 |1500

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

1 Answer

Upvote
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

The dividend is due to be paid on the 1st of December (it is under dividend type: forecast interim), hence, you would need to slightly change your request in order to get it.

Firstly, the fields that you would need to use, are under Content Classification > Corporate Actions > Dividend History in DIB.

Secondly, in the request params you will need to set something like this:

"SDate=3M EDate=-1Y DivType=66:65:60:61" (Interim, Final, Forecast Interim, Forecast final)

Thirdly, in order to use the fields from DIB in COM, you will need to activate your DEX API a little bit differently as described here.


screen-shot-2017-10-23-at-110900.png (299.7 KiB)
icon clock
10 |1500

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

canada.equity5 avatar image canada.equity5

So can I use the fields I was using before (RCA.DH.ExDate and RCA.DH.PayDate) with the request parameters you describe here?

Alex Putkov.1 avatar image Alex Putkov.1 canada.equity5

No, you cannot. It would be best to migrate to Eikon 4 field naming scheme, as at this point there's no good way to discover metadata for Eikon 3 field naming scheme, especially for the parameters you can use, as I explained on another thread.
https://community.developers.refinitiv.com/questions/20499/list-of-eikon-v3-fields.html

Click below to post an Idea Post Idea