Sample Period From Eikon

X.Sun1
X.Sun1 Newcomer
in Eikon Data APIs

Hi there,

I am a new PhD student and a new user of Eikon. When I download data from Eikon, I faced some problems. In particular, the fiscal year quite confused me.

For example, I want to download "audit fees" data for New Zealand companies. First, I choose country of exchange=> New Zealand. Second, I search "Data item library" => "Audit Fees,Supplemental". Third, I chose "series"=> Last 5 FY => from FY0 (newest to oldest) => OK.

However, after random checking some companies, I found a problem for the data. Current date is 24th of June 2018. For Company A whose fiscal year end is on 30th of June, the FY0 will show the data for 2017 as 2017 is the last fiscal year. For company B whose fiscal year end is 31st of March, the FY0 will show the data for 2018 as 2018 is the last fiscal year. So FY0 is not showing the same year for different companies in this situation.

Is there any method to choose a specific period of time (e.g., FY2010 to FY2017) when download data?

Thanks very much!

Regards,

Sean

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    @X.Sun1
    You can indeed use absolute period references, e.g.
    TR.AuditFees(Period=FY2010;FY2017)
    or
    ek.get_data('ASX.AX',['TR.AuditFees.date','TR.AuditFees.fpa','TR.AuditFees'],{'Period':'FY2010;FY2017'})

Answers

Categories