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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
39 4 6 5

Retrieving upcoming earnings events, AGMs

Hello.

I am trying to use DataScope Select to retrieve upcoming (future) earnings dates, and/or estimates data.

This data is available through Eikon Desktop and the related Python API.

I would like to get this same data using DSS, if possible?

Unfortunately, it seems DSS only has historical earnings dates and estimates. I have put in NextDays which does not work.

DSS code below and corresponding Eikon Desktop event (requested 5th May)

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
    "ContentFieldNames": [
      "Corporate Actions Type",
      "Corporate Action Notes",
      "Earnings Announcement Date",
      "Effective Date"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
          { "Identifier": "SRG.MI", "IdentifierType": "Ric" }
      ]
    },
    "Condition": {
      "ReportDateRangeType": "Range",
      "PreviousDays": 1,
      "NextDays": 30,
      "PendingEventsHours": 720,
      "IncludeInstrumentsWithNoEvents": true,
      "IncludeEarningsEvents": true,
      "CorporateActionsEarningsType": "EarningsAnnouncementDate"
    }
  }
}

I get the following result (no actions)

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
    "value": [
        {
            "IdentifierType": "Ric",
            "Identifier": "SRG.MI",
            "Corporate Actions Type": null,
            "Corporate Action Notes": null,
            "Earnings Announcement Date": null,
            "Effective Date": null
        }
    ]
}

The data is available on Eikon Desktop (tomorrow 6th and 7th note date of this post is 5th May)



dss-rest-apidssdatascope-selectdatarest-api
srgmi.png (67.3 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.

Upvotes
Accepted
32.2k 39 11 19

Hello @JIAN.DU,

Once the question becomes content-specific, there are better ways to get them answered then API forums. The developers forums are best suited for Refinitiv API usage questions.

Once the question becomes if DSS supports future earning dates:

  • If you have a good understanding of the content that you require, you can research the right request options via DSS GUI, and then translate them into DSS API request parameters
  • Or research via CorporateActionsStandardExtractionRequest spec within REST API Reference Tree
  • In general case, for DSS content specific questions, as a customer you can contact Refinitiv Content Helpdesk online or your local Helpsdesk via phone, and select product = DSS, "I need help finding content".

Will you be able to proceed? Would you like me to create a content inquiry on your behalf?

(you are going to research content with helpdesk, try not to bring up API use, or Eikon Data API in Python, as then, potentially, your question may be interpreted as API-specific, and you will not be able to find out how to request future earnings from DSS, but will be advised to turn to this forum for API instead)

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.

Upvotes
32.2k 39 11 19

Hello @JIAN.DU,

I think that Condition is what prevents your request from returning the result you are looking for, as having both PreviousDays and NextDays is confusing.

Would this be what you are looking for?

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
    "ContentFieldNames": [
      "Corporate Actions Type",
      "Corporate Action Notes",
      "Earnings Announcement Date",
      "Effective Date"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
          { "Identifier": "SRG.MI", "IdentifierType": "Ric" }
      ]
    },
    "Condition": {
      "ReportDateRangeType": "Last",
      "PreviousDays": 30,
      "ExcludeDeletedEvents": true,
      "IncludeCapitalChangeEvents": true,
      "IncludeDividendEvents": true,
      "IncludeEarningsEvents": true,
      "IncludeMergersAndAcquisitionsEvents": true,
      "IncludeNominalValueEvents": true,
      "IncludePublicEquityOfferingsEvents": true,
      "IncludeSharesOutstandingEvents": true,
      "IncludeVotingRightsEvents": true,
      "CorporateActionsCapitalChangeType": "CapitalChangeExDate",
      "CorporateActionsDividendsType": "DividendPayDate",
      "CorporateActionsEarningsType": "EarningsAnnouncementDate"
    }
  }
}

This results in populated result from my run:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
    "value": [
        {
            "IdentifierType": "Ric",
            "Identifier": "SRG.MI",
            "Corporate Actions Type": "CAP",
            "Corporate Action Notes": "Snam is going to spin off Italgas.",
            "Earnings Announcement Date": null,
            "Effective Date": "2016-11-07"
        },
....

Or you can try with QueryStartDate and QueryEndDate to get different interval.


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.

This does not work as required. I am after events in the future (all events from tomorrow). Using your suggested only looks at events in the past.

Upvotes
39 4 6 5

Hi @zoya.farberov thx for your reply but the proposed does not work as required.

I already have DSS working but I am after events in the future (all events from tomorrow). Using your suggested only looks at events in the past.

Can you confirm how to pull up events in the future please? I am just after the dates.

Thank you.

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.

Upvotes
32.2k 39 11 19

Hello @JIAN.DU,

To get all future events, try NextDays = -1

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
    "ContentFieldNames": [
      "Corporate Actions Type",
      "Corporate Action Notes",
      "Earnings Announcement Date",
      "Capital Change Event Type",
      "Capital Change Event Type Description",
      "Actual Adjustment Type",
      "Actual Adjustment Type Description",
      "Adjustment Factor",
      "Currency Code",
      "Exchange Code",
      "Effective Date",
      "Dividend Pay Date",
      "Dividend Rate",
      "Nominal Value",
      "Nominal Value Currency",
      "Nominal Value Date"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
          { "Identifier": "SRG.MI", "IdentifierType": "Ric" }
      ]
    },
    "Condition": {
      "ReportDateRangeType": "Range",
      "PreviousDays": 0,
      "QueryStartDate": "2020-05-05T00:00:00.000Z",
      "NextDays": -1,
      "ExcludeDeletedEvents": true,
      "IncludeCapitalChangeEvents": true,
      "IncludeDividendEvents": true,
      "IncludeEarningsEvents": true,
      "IncludeMergersAndAcquisitionsEvents": true,
      "IncludeNominalValueEvents": true,
      "IncludePublicEquityOfferingsEvents": true,
      "IncludeSharesOutstandingEvents": true,
      "IncludeVotingRightsEvents": true,
      "CorporateActionsCapitalChangeType": "CapitalChangeExDate",
      "CorporateActionsDividendsType": "DividendPayDate",
      "CorporateActionsEarningsType": "PeriodEndDate",
      "ShareAmountTypes": [
      ]
    }
  }
}


You may also find useful this previous discussion thread ?

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.

Thanks ZOya unfortunately still no luck. Just posted a reply

Upvotes
39 4 6 5

Hi Zoya, unfortunately the proposed solution still doesn't work. Using your code above, I get the following (just one DIV event)

According to Eikon Desktop specifically for EAR earnings events there should be

6 May, 29 Jul, 4 Nov 2020

16 Mar 2021

So I am not sure, whether DSS supports future EAR events (even though they seem to be in Eikon Desktop, and also TRKD as far as I'm aware), and if it does, how to get it working in DSS?


{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
    "value": [
        {
            "IdentifierType": "Ric",
            "Identifier": "SRG.MI",
            "Corporate Actions Type": "DIV",
            "Corporate Action Notes": "Dividend amount will be announced at a later date.",
            "Earnings Announcement Date": null,
            "Capital Change Event Type": null,
            "Capital Change Event Type Description": null,
            "Actual Adjustment Type": null,
            "Actual Adjustment Type Description": null,
            "Adjustment Factor": null,
            "Currency Code": "EUR",
            "Exchange Code": "MIL",
            "Effective Date": null,
            "Dividend Pay Date": "2020-06-24",
            "Dividend Rate": 0.1426,
            "Nominal Value": null,
            "Nominal Value Currency": null,
            "Nominal Value Date": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "SRG.MI",
            "Corporate Actions Type": "PEO",
            "Corporate Action Notes": null,
            "Earnings Announcement Date": null,
            "Capital Change Event Type": null,
            "Capital Change Event Type Description": null,
            "Actual Adjustment Type": null,
            "Actual Adjustment Type Description": null,
            "Adjustment Factor": null,
            "Currency Code": "EUR",
            "Exchange Code": "MIL",
            "Effective Date": null,
            "Dividend Pay Date": null,
            "Dividend Rate": null,
            "Nominal Value": null,
            "Nominal Value Currency": null,
            "Nominal Value Date": null
        }
    ]
}


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.

Upvotes
39 4 6 5

Ok so seems like a content question (as future earnings events aren't in the DSS web GUI)

I will reach out to support desk. Thanks

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.