How do I retrieve financial data for an irregular account settlement?
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)
Best Answer
You should contact Eikon team for the Eikon Excel formula (=TR function) used to retrieve the required financial data.
After getting arguments for =TR function, you can apply those to ek.get_data, as mentioned in this question.
Thank you for your swift help!