Daily EPS Trailing 5 years of a company using REST API
Is there a REST API that I could use to retrieve daily EPS Trailing 5 years of a company?
Best Answer
-
Hi,
You can use the following:
import refinitiv.data as rd
...
rd.get_data(
universe=['AAPL.O'],
fields=['TR.EPSMean', 'TR.EPSMean.date'],
parameters={'SDate':0, 'EDate':-4, 'Frq':'FY'}
)1
Answers
-
Thanks. How can I get this data using DataScope API?
0 -
Also is it possible to retrieve this data from datastream api?
0 -
I found some EPS fields in the DataScope Corporate Actions report template.
You can check all available fields and their descriptions in the Refinitiv DataScope Select Data Content Guide.
I tested it with the following request.
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
"ContentFieldNames": [
"Corporate Actions Type",
"Adjusted EPS Amount",
"EPS Amount",
"Earnings Announcement Date",
"Period End Date",
"EPS Basis Number of Shares",
"EPS Calculation Basis",
"EPS Currency",
"EPS General Marker",
"EPS General Marker Description",
"EPS Is Audited",
"EPS Net/Gross Marker",
"EPS Net/Gross Marker Description"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "AAPL.O",
"IdentifierType": "Ric"
}
]
},
"Condition": {
"ReportDateRangeType": "Range",
"QueryStartDate": "2018-01-01",
"QueryEndDate": "2023-01-20",
"ExcludeDeletedEvents": false,
"IncludeCapitalChangeEvents": false,
"IncludeDividendEvents": false,
"IncludeEarningsEvents": true,
"IncludeMergersAndAcquisitionsEvents": false,
"IncludeNominalValueEvents": false,
"IncludePublicEquityOfferingsEvents": false,
"IncludeSharesOutstandingEvents": false,
"IncludeVotingRightsEvents": false,
"CorporateActionsEarningsType": "EarningsAnnouncementDate",
"ShareAmountTypes": []
}
}
}The output looks like this:
"Contents": [
{
"IdentifierType": "Ric",
"Identifier": "AAPL.O",
"Corporate Actions Type": "EAR",
"Adjusted EPS Amount": 0.6384675,
"EPS Amount": 2.55387,
"Earnings Announcement Date": "2020-04-30",
"Period End Date": "2020-03-28",
"EPS Basis Number of Shares": 4404691000,
"EPS Calculation Basis": "WAV",
"EPS Currency": "USD",
"EPS General Marker": 80,
"EPS General Marker Description": "Consolidated fully diluted earnings;interim before extraordi",
"EPS Is Audited": "n",
"EPS Net/Gross Marker": 2,
"EPS Net/Gross Marker Description": "Net"
},
{
"IdentifierType": "Ric",
"Identifier": "AAPL.O",
"Corporate Actions Type": "EAR",
"Adjusted EPS Amount": 2.5324025,
"EPS Amount": 10.12961,
"Earnings Announcement Date": "2020-07-30",
"Period End Date": "2020-06-27",
"EPS Basis Number of Shares": null,
"EPS Calculation Basis": "WAV",
"EPS Currency": "USD",
"EPS General Marker": 80,
"EPS General Marker Description": "Consolidated fully diluted earnings;interim before extraordi",
"EPS Is Audited": "n",
"EPS Net/Gross Marker": 2,
"EPS Net/Gross Marker Description": "Net"
},
{
"IdentifierType": "Ric",
"Identifier": "AAPL.O",
"Corporate Actions Type": "EAR",
"Adjusted EPS Amount": 0.6460125,
"EPS Amount": 2.58405,
"Earnings Announcement Date": "2020-07-30",
"Period End Date": "2020-06-27",
"EPS Basis Number of Shares": 4354788000,
"EPS Calculation Basis": "WAV",
"EPS Currency": "USD",
"EPS General Marker": 80,
"EPS General Marker Description": "Consolidated fully diluted earnings;interim before extraordi",
"EPS Is Audited": "n",
"EPS Net/Gross Marker": 2,
"EPS Net/Gross Marker Description": "Net"
},
...You can refer to the REST API Reference Tree for all parameters of the CorporateActionsStandardExtractionRequest.
Otherwise, if you have any further questions regarding the retrieved content, please contact the Datascope Select support team directly via MyRefinitiv.
1 -
For the Datastream Webservice, you can use the Datastream Navigator to search for data types or fields.
Then, you can use these data types with the Datastream Webservice to retrieve the data.
For example:
df = ds.get_data(tickers='U:IBM',
fields= ['EPS1TR12','EPS'],kind=1,start='-5Y', freq='Y')
dfThe output is:
I am using DatastreamPy to retrieve the data.
0 -
Thanks you, very useful.
Is this data store in TQA database as well? If yes, can you send me table name and column?
0 -
read store as stored
0 -
Also is it possible to retrieve this data from datastream api?
0 -
You need to use the Datastream Navigator to search for data types or fields, as mentioned in the answer below.
Otherwise, you can contact the DataStream Webservice support team directly via MyRefinitiv to check the data types for you.
0 -
@vishal.kak
Sorry. I am not familiar with the TQA database. You need to contact your Refinitiv Account team or Sales team to verify this.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛