question

Upvote
Accepted
Tulkkas avatar image
37 ●10 ●10 ●13

How to extract quarterly fundamentals data

I would like to extract quarterly values for the field totalEquity for Apple usnig the Python eikon API. I currently have the following function: 

temp_data = ek.get_data('AAPL.O',['TR.ISOriginalAnnouncementDate','TR.TotalEquity.periodenddate','TR.TotalEquity'],parameters={'SDate': start_date, 'EDate': end_date})

But i only get yearly values. I tried to change the field FRQ in the parameters but could not get the right set-up. Any suggestion?


eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apidatafundamentals
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvote
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @Tulkkas

You can try this code:

df,e  = ek.get_data('AAPL.O',
                    ['TR.ISOriginalAnnouncementDate(SDate="2017-01-01",EDate="2019-08-01",Period=FQ0,Frq=FQ)',
                     'TR.TotalEquity(SDate="2017-01-01",EDate="2019-08-01",Period=FQ0,Frq=FQ).periodenddate',
                     'TR.TotalEquity(SDate="2017-01-01",EDate="2019-08-01",Period=FQ0,Frq=FQ)'])
df


ahs.png (47.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.