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



Tagged:

Best Answer

  • Gurpreet
    Answer ✓

    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.

Answers

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