How do I retrieve financial data for the fiscal year with irregular settlements?
For example, <4812.T>
On EIKON desktop, it shows the data seems to be correct,
Whereas API returns period end date wrong, missing 2015-03-31、2014-12-31、and 2014-09-30.
「Reuter_question1.csv」 import eikon as ek from datetime import datetime as dt import pandas as pd ek.set_app_id('8A74283D221E74D48347816') fields = ['TR.Revenue.date', 'TR.Revenue', 'TR.GrossProfit'] param = {'SDate': 0, 'EDate': -3, 'FRQ': 'FS'} if __name__ == '__main__': start_date = str(20170701) end_date = str(20171005) chunk = ['1730.T'] fields = ['TR.ISOriginalAnnouncementDate', 'TR.ISPeriodEndDate', 'TR.TotalOperatingExpense', 'TR.CostofRevenueTotal', 'TR.SgaExpenseTotal', 'TR.ResearchAndDevelopment', 'TR.UnusualExpense'] data, error = ek.get_data(chunk, fields, {"SDate": start_date, "EDate": end_date, "FRQ": "FQ", "Period": "FQ0", "ReportingState": "Orig"}) data.to_csv(path + "Reuter_question1.csv", index=None) print(data)