Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by JIAN.DU · May 05, 2020 at 10:54 AM · rest apidatascope selectearnings

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)



srgmi.png (67.3 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

6 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya.farberov · May 05, 2020 at 05:37 PM

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)

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by zoya.farberov · May 05, 2020 at 03:28 PM

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.


Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
JIAN.DU · May 05, 2020 at 03:40 PM 0
Share

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.

avatar image
Answer by JIAN.DU · May 05, 2020 at 03:41 PM

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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by zoya.farberov · May 05, 2020 at 04:52 PM

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 ?

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
JIAN.DU · May 05, 2020 at 04:59 PM 0
Share

Thanks ZOya unfortunately still no luck. Just posted a reply

avatar image
Answer by JIAN.DU · May 05, 2020 at 04:59 PM

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
        }
    ]
}


Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by JIAN.DU · May 05, 2020 at 05:51 PM

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
13 People are following this question.

Related Questions

Get Target RIC for Demerger from DataScope Select

Why do I get a different number of results using DataScope .Net SDK and DataScope Select Web UI?

DataScope Select - REST API , functionality Adhoc - decimals

REST API: List creation/amending

Do I have any contract restriction to receive the following message? I'm trying to extract Market Depth from US Stock equities.

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges