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

fabian.florez

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

Find more posts tagged with

excel

rdp-api

Accepted answers

Gurpreet

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.

All comments

Gurpreet

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.

douglas.jansen

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

EXPLORE OUR SITES