Why is the fperiod not properly aligned with the values?

augusto_krappa · 2025-03-25T19:29:39+00:00

There was an error rendering this rich post.

I'm having problem when downloading financial income data. For this example in the code below, the "Financial Period Absolute" (fperiod) is not properly aligned with the true financial data. We can see that on "TR.F.OperProflnOpCASR | XEBT", there are 2 values on FY2024Q4, but it should be one value for FY2024Q4 and another for FY2024Q3 (respectively 514.763 and 353.769).

df_ASR_err = ek.get_data( instruments = ['MGLU3.SA'], fields= ["TR.F.ASRIncomeStatement.fieldname", "TR.F.ASRIncomeStatement.date", "TR.F.ASRIncomeStatement.fperiod"], parameters = {'Scale': 6, 'SDate': 0, 'EDate': -30, 'Period': 'FQ0', 'FRQ': 'FQ', 'AlignType': 'PrelimOrPeriodEndDate', 'ConsolBasis': 'Consolidated'})

Find more posts tagged with

python

excel

workspace

codebook

eikon-data-api

financial-statements

#content

#technology

Accepted answers

All comments

Jirapongse

@augusto_krappa

Thank you for reaching out to us.

I ran the following code.

df_ASR, err = ek.get_data( 
    instruments = ['MGLU3.SA'], 
    fields= ["TR.F.ASRIncomeStatement.fieldname", 
             "TR.F.ASRIncomeStatement.date", 
             "TR.F.ASRIncomeStatement.fperiod"], 
    parameters = {'Scale': 6, 
                  'SDate': 0, 
                  'EDate': -30, 
                  'Period': 'FQ0', 
                  'FRQ': 'FQ', 
                  'AlignType': 'PrelimOrPeriodEndDate', 
                  'ConsolBasis': 'Consolidated'})

df_ASR

I got this data.

I couldn't see the 514.763 and 353.769 values.

augusto_krappa

https://community.developers.refinitiv.com/discussion/comment/124858#Comment_124858

try to expand the dataframe and filter by "TR.F.OperProflnOpCASR | XEBT"

augusto_krappa

Check that XEBT is returning 2 times FY2024Q4, when 353 is the XEBT for FY2024Q3

Jirapongse

@augusto_krappa

You need to use the TR.F.ASRIncomeStatement.fperiod field instead.

augusto_krappa

Alright!!! thanks a lot

EXPLORE OUR SITES