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,

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)

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    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.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.