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!
