Historical fundamental data with multiple periods

reid

I am trying to make a request for quarterly historical actual revenue, and return the full fundamental backhistory for each calcdate.

below the request for the current and previous fiscal quarter data works, but adding any further relative quarters does not work.

I would also like to know how I could make the call to request all of the previous fundamental data, e.g. FQ0,FQ-1,FQ-2,...,FQ-N for all N quarters available.

# FQ0, FQ-1 WORKS
raw_ids, err = ek.get_data(
            ['EYE.OQ'], 
            ['TR.RevenueActValue', 'TR.RevenueActValue.calcdate','TR.RevenueActValue.date','TR.RevenueActValue.fperiod','TR.RevenueActValue.periodenddate','TR.RevenueActValue.announcedate'
], 
            {
                'SDate':'2000-01-01',
                'EDate':'2022-01-01',
                'Period':'FQ0,FQ-1',# pull past quarters data
                'Frq':'FQ'
            }
    )

# FQ0,FQ-1,FQ-2 DOES NOT WORK
raw_ids, err = ek.get_data(
            ['EYE.OQ'], 
            ['TR.RevenueActValue', 'TR.RevenueActValue.calcdate','TR.RevenueActValue.date','TR.RevenueActValue.fperiod','TR.RevenueActValue.periodenddate','TR.RevenueActValue.announcedate'
], 
            {
                'SDate':'2000-01-01',
                'EDate':'2022-01-01',
                'Period':'FQ0,FQ-1,FQ-2',# pull past quarters data
                'Frq':'FQ'
            }
    )

Alex Putkov.1

@reid

I can't say I quite understand what you're looking to achieve. Nevertheless, the notation "FQ0,FQ-n" for the Period parameter is interpreted as the range of quarters between FQ0 and FQ-n. So, try 'Period':'FQ0,FQ-4' for example. Does it give you what you're looking for? If not, could you please elaborate on what you're trying to achieve? It strikes me as rather odd to combine in the same request a range of fiscal quarters using Period parameter and a range of dates (using SDate and EDate).