Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by rajanraju · May 07, 2019 at 06:48 PM · python apipython api eikonsharesoutstanding

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by chavalit.jintamalit · May 08, 2019 at 12:14 AM

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)
Comment
rajanraju

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by rajanraju · May 08, 2019 at 01:20 AM

@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!

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Alex Putkov. · May 08, 2019 at 09:13 AM

@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'})
Comment
rajanraju

People who like this

1 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
rajanraju · May 08, 2019 at 02:28 PM 0
Share

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

Field for currency in timeseries

I want to get data using python API.

Historical company guidance data

Python API - Fi Option Adjusted Spread (get data)

EIKON API PYTHON AUTOMATION

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges