Absolute and Relative financial period for the fundamental data in ek.get_data()

dan.li01

Hello friends,

I'm using Eikon data API to get some financial fundamental data. I use the function

df,err = ek.get_data('AAPL.O',['TR.NetIncome(Period=FQ0)', 'TR.NetIncome(Period=FQ-1)'])

to retrieve the net income for AAPL.O. And this function works perfectly. You may notice that the financial period is a relative value, such as FQ0 for the current financial quarter and FQ-1 for the previous one.

However, sometimes I need to use Absolute period instead of the Relative one, and I found in DIB that the Absolute period of FQ0 for AAPL.O is showing FY2020Q2. and I replaced in the parameters, it doesn't work.

df,err = ek.get_data('AAPL.O',['TR.NetIncome(Period=FY2020Q2)', 'TR.NetIncome(Period=FY2020Q1'])

This issue happened for the quarter fundamental data, and for the annual one, both Absolute and Relative financial period are working fine. eg.

df,err = ek.get_data('AAPL.O',['TR.NetIncome(Period=FY2019)', 'TR.NetIncome(Period=FY2018'])

df,err = ek.get_data('AAPL.O',['TR.NetIncome(Period=FY0)', 'TR.NetIncome(Period=FY-1'])

Thanks in advance for your looking into it.

Dan

chavalit-jintamalit

Hi @dan.li01

Thanks for the detailed explanation of the issue.

Please try this code:

dan.li01

Hi chavalit jintamalit

Thank you for your guidance. It works perfectly and the explanation is very helpful !

Dan