How do I retrieve financial data for an irregular account settlement?

mariko.kataoka

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,

reuter-171213-2.png

Whereas API returns period end date wrong, missing 2015-03-31、2014-12-31、and 2014-09-30.

reuter-171213-1.png

「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)

Jirapongse

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.