question

Upvotes
Accepted
1 0 1 1

How can I get next ex-dividend date and dividend rate

Hi everyone,


I have an excel list about equities and I need have the next ex-dividend date and dividend rate.


Someone knows how can I get it?


Thanks so much



rdp-apiexcel
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.

1 Answer

· Write an Answer
Upvote
Accepted
22.8k 60 14 21

Hello @fabian.florez,

Within Refinitiv Data Platform, I could find that Search REST service can provide some of this data. I tried the following query and got dividend information:

POST https://api.refinitiv.com/discovery/search/v1/
{
  "View": "EquityQuotes",
  "Filter": "RIC eq 'TD.TO'",
  "Select": "ExDividendDate, EquityDividends, PreferredStockDividends"
}

Response:
{
  "Total": 1,
  "Hits": [
    {
      "ExDividendDate": "2022-04-07T00:00:00.000Z",
      "EquityDividends": -5741000000,
      "PreferredStockDividends": -249000000
    }
  ]
}


We are unable to help with content questions, on these forums. I would recommend that you raise a content ticket with Refinitiv support at my.refinitiv.com to speak with a content expert.

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.

Hi - In this example, how would one interpret the -5741000000 value? What does this value mean? Thank you. Doug

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.