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
15 6 8 11

How to fetch Quaterly TotalRevenue and TR.DilutedWghtdAvgShares data for RICs

I'm looking for "Quaterly" data for RevenuePerShare or "Quaterly" data for Total Revenue and TR.DilutedWghtdAvgShares
Annual data is available need assistance in fetching the quaterly data

eikon-data-apidata
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
32.2k 40 11 20

Hello @BlackBird ,

You can try this code:

df, err = ek.get_data(
    instruments = ['IBM.N'],
    fields = [
        'TR.F.TotRevPerShr(SDate=0,EDate=-3,Period=FQ0,Frq=FQ)',
        'TR.DilutedWghtdAvgShares(SDate=0,EDate=-3,Period=FQ0,Frq=FQ)'
    ]
)

display(df)

On my side the result looks like:

totrevenue.gif

If this is not exactly what you are looking for, I have arrived at this code using Code Creator tool available in Refinitiv Workspace/Eikon, "codecr". You can use the tool to identify the available content by selecting:

  • Instrument (for example IBM)
  • Fields (search by description)
  • Parameters ( check-mark Time Series option and select Quarter)

and adding to your formula that can next be copied to your code.

If you are unable to pinpoint the content you are looking for via the tool, or have questions about this content, as a customer you can engage with Eikon support experts via Refinitiv Helpdesk Online -> Content -> Eikon to help you identify the required content via formula first, and next copy the identified formula into your code.

Hope that this information helps


totrevenue.gif (14.7 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.

Hi ,

Thank you for the information.

For this question, I will accept the below answer as it helped us figure out the quarterly data.

Regards,

BlackBird.

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.