Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
rajanraju avatar image
63 ●10 ●17 ●19

Shares outstanding every quarter - Python API

Was looking to get the shares outstanding every quarter. Used the following

ek.get_data('STEL.SI', fields = ['TR.ISPeriodEndDate','TR.CompanySharesOutstanding'] , parameters= {'Frq' : 'FQ', 'SDate' : 0, 'EDate': -12, 'CH' : 'Fd'})

The TR.ISPeriodEndDate was to give the reporting date. Unfortunately, this gives

InstrumentIncome Statement Period End DateCompany Shares

STEL.SI 2018-03-31. 16329158300.0

STEL.SI 2018-03-31. 16329158300.0

STEL.SI 2018-03-31 16329158300.0

STEL.SI 2018-03-31. 16329158300.0

STEL.SI 2017-03-31. 16329100000.0

STEL.SI 2017-03-31. 16329100000.0

rather than the reporting quarter dates.

Pls advise what would be the correct query

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

3 Answers

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

Hi @rajanraju

The TR.ISPeriodEndDate is for Income Statement Period End Date.

I think you may need Income Statement Last Update Date or Source Date ?

You can use "Data Item Browser" to search for fields and see its description.

Please see this article.


dib.png (203.6 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.

Upvotes
rajanraju avatar image
63 ●10 ●17 ●19

@chavalit.jintamalit thank you. I used Balance Sheet Period End Date:

ek.get_data('STEL.SI', fields = ['TR.BSPeriodEndDate','TR.CompanySharesOutstanding'], parameters= {'Period':'FQ0','Frq': 'FQ', 'SDate':0, 'EDate': -12, 'CH':'Fd'})

and it works!

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.

Upvote
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

@rajanraju
For TR.* fields that can return timeseries there's always date and calcdate output that can be requested along with the values. For your use case I think the best call would be

ek.get_data('STEL.SI', ['TR.CompanySharesOutstanding.calcdate',
                        'TR.CompanySharesOutstanding'],
            {'Frq':'FQ', 'Sdate':'0', 'Edate':'-12'})
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.

rajanraju avatar image rajanraju

@Alex Putkov. many thanks. this solves a lot of my issues!!

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.