TR.EPSMean(Period=FY1).periodenddate inconsistent between Python and Excel API

I have a doubt about the way Python API recognizes accounting periods. On 2020-04-22, namely today, 8060.T announced Q1 (2020 Jan-Mar) result and I wanted to see quarterly EPS estimate and found this seemingly erroneous phenomenon.
1-A. On Python, ek.get_data('8060.T', fields=["TR.EPSMean(Period=FQ1).periodenddate"], parameters={'SDate':'2020-04-22', "RollPeriods":True})[0]
This gives me back Period End Date 2020-03-31
1-B. On Excel, =TR("8060.T", "TR.EPSMean(SDate=2020-04-22, Period=FQ1, RollPeriods=True).periodenddate")
This returns 2020-06-30.
Since I specify RollPeriods=True and now that Q1 (2020 Jan-Mar) result is out, I expect it to roll the window over to the next quarter FQ1, 2020 Apr-Jun. Why does Python still refer to Jan-Mar as FQ1?
2-A. ek.get_data('8060.T', fields=["TR.EPSMean(Period=FQ0).periodenddate"], parameters={'SDate':'2020-04-20', "RollPeriods":False})[0]
This returns 2019-12-31, which does not make any sense. If I am not mistaken, RollPeriods=False means that the period is purely based on calendar quarter, not fiscal quarter of interest. As of 2020-04-20, it is clear that the Q1 (Jan-Mar) is behind us, so FQ0 should be the three months ending in Mar. Why does it still stick to the period prior to the last quarter?
2-B. =TR("8060.T", "TR.EPSMean(SDate=2020-04-20, Period=FQ0, RollPeriods=False).periodenddate")
Excel seems to be working correctly, by showing 2020-03-31. This is good, but it also highlights another issue, inconsistency.
The issue problem 1 and 2 may look similar to each other at first glance, but I believe they are essentially different. For the issue 1, it may be because Python API is slow to recognize the result announcement and time could solve this inconsistency. However, the issue 2 has nothing to do with a result announcement. Regardless of the Q1 result being released or not, the calendar quarter Q1 is already behind us.
Could someone correct me if my understanding is not quite correct? Also, I appreciate it if someone can give me more colors what is going on behind the scene?
Thank you very much, in advance!
Best Answer
-
Hi @iwasaki - thanks for you question. I have run your python code and it seems to be what you are getting from excel: see screenshot below:
The only thing I can think of is some small delay in the table being updated - but the source for excel and python API should be the same. Can you run now to see if it is ok?
0
Answers
-
Oh, thank you very much for double checking and as you pointed out, now inconsistency has gone and everything looks all right. So, it seems that once the the database is updated and Python API recognizes an announcement date correctly, things are sorted and put in order.
Thank you again for taking care of it!
0 -
@iwasaki My pleasure! Glad to be of help
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 616 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛