Why is the fperiod not properly aligned with the values?

augusto_krappa · March 25

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'})

Jirapongse · March 27

@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.