For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
caio.zentil avatar image
21 ●2 ●5 ●8

Last DIvidend DSS with API

Dear all, how are you?

I´m using the the ExtractionRequests.CorporateActionsStandardExtractionRequest function in order to get the last dividend for IVV.P, but the service don’t reply with the last dividend. The correct dividend value and date is:

"Identifier": "IVV.P",

"Period End Date": "2020-09-30",

"Dividend Announcement Date": "2020-01-16",

"Dividend Ex Date": "2020-09-23",

"Dividend Rate": 1.505804,

"Dividend Payment Type": "CDI",

"Dividend Payment Type Description": "Cash Dividend"


The API is replying 2020-06-30 as a last dividend, but the correct date is 2020-06-30


Anyone has a clue?

Thanks in advance!


REQUEST:


{

"IdentifierType": "Ric",

"Identifier": "IVV.P",

"Period End Date": "2020-06-30",

"Dividend Announcement Date": "2020-06-13",

"Dividend Ex Date": "2020-06-15",

"Dividend Rate": 1.260874,

"Dividend Payment Type": "CDI",

"Dividend Payment Type Description": "Cash Dividend",

"Dividend Pay Date": "2020-06-19"

},


{

"ExtractionRequest": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",

"ContentFieldNames": [

"Period End Date", "Dividend Announcement Date",

"Dividend Ex Date", "Dividend Rate", "Dividend Payment Type", "Dividend Payment Type Description", "Dividend Pay Date"

],

"IdentifierList": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

"InstrumentIdentifiers": [{ "Identifier": "IVV.P", "IdentifierType": "Ric" }],

"ValidationOptions": null,

"UseUserPreferencesForValidationOptions": false

},

"Condition": {

"ReportDateRangeType": "Last",


"ExcludeDeletedEvents": true,

"IncludeDividendEvents": true,

"IncludeEarningsEvents": true,

"ShareAmountTypes": [ ]

}

}

}


REPLY:


{

"IdentifierType": "Ric",

"Identifier": "IVV.P",

"Period End Date": "2020-06-30",

"Dividend Announcement Date": "2020-06-13",

"Dividend Ex Date": "2020-06-15",

"Dividend Rate": 1.260874,

"Dividend Payment Type": "CDI",

"Dividend Payment Type Description": "Cash Dividend",

"Dividend Pay Date": "2020-06-19"

},


dss-rest-apidatascope-selectdssdatacorporate-events
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.

zoya faberov avatar image   zoya faberov

Hello @caio.zentil,

I can confirm that by entering the same request I see the same result.

In order to better understand your question, I think it will help to know, how do you obtain the different result, that is shown first, with ""Dividend Rate": 1.505804," ?

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @caio.zentil

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Gurpreet avatar image
22.1k ●59 ●14 ●21

Hello @caio.zentil, I can see from Eikon that the latest dividend date is 2020-09-29 at 1.5058, but the DSS API is returning the previous dividend point at 2020-06-19 at 1.26087.

Period End Date,Dividend Announcement Date,Dividend Ex Date,Dividend Rate,Dividend Payment Type,Dividend Payment Type Description,Dividend Pay Date
2020/06/30,2020/06/13,2020/06/15,1.260874,CDI,Cash Dividend,2020/06/19



This is not something we can help with on the developers forum. Please raise a content ticket with Refinitiv Support to investigate why latest dividend data is not available yet.


1601649905896.png (107.6 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.