Hi,
I am trying to get the historical dividend for ETFs, but the return is always:
Instruments in the input list had no reported data.
The json file I am using is preseted next (when using Equities, it works perfectly).
Could you please help me out? How am I suppose to get these values for ETFs?
Thank you very much.
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
"ContentFieldNames": [
"Actual Adjustment Type",
"Adjustment Factor",
"Dividend Ex Date",
"Dividend Rate",
"Dividend Payment Type Description",
"Dividend Payment Type"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "DE0006289473", "IdentifierType": "Isin" },
{ "Identifier": "DE000ETFL185", "IdentifierType": "Isin" },
{ "Identifier": "FR0007075494", "IdentifierType": "Isin" },
{ "Identifier": "FR0010591362", "IdentifierType": "Isin" },
{ "Identifier": "FR0010717124", "IdentifierType": "Isin" },
{ "Identifier": "DE0005933931", "IdentifierType": "Isin" },
{ "Identifier": "LU0252633754", "IdentifierType": "Isin" },
{ "Identifier": "LU0274211480", "IdentifierType": "Isin" }
]
},
"Condition": {
"ReportDateRangeType": "Range",
"QueryStartDate": "2015-01-01",
"QueryEndDate": "2021-03-23",
"ExcludeDeletedEvents": true,
"IncludeDividendEvents": true,
"IncludeCapitalChangeEvents": true,
"IncludeEarningsEvents": true,
"IncludeMergersAndAcquisitionsEvents": true,
"IncludeNominalValueEvents": true,
"IncludePublicEquityOfferingsEvents": true,
"IncludeSharesOutstandingEvents": true,
"IncludeVotingRightsEvents": true,
"CorporateActionsCapitalChangeType": "CapitalChangeExDate",
"CorporateActionsDividendsType": "DividendExDate",
"CorporateActionsEarningsType": "PeriodEndDate",
"ShareAmountTypes": [
]
}
}
}