Regarding the Refinitiv eikon API

vasu01
vasu01
in Eikon Data APIs

I encountered some difficulties while trying to fetch the revenue data for First Group and Farsers.

The data is available in the Refinitiv Workspace, but I could not access it through the API.

I also attempted to get the old and new share price, but I failed to do so.

Moreover, I would like to understand how the stock split rate is calculated.

I have attached a screenshot of the codes below. Could you please take a look and assist me ?

I tried using the field, for revenue is TR.Revenue and for old and new shares is TR.CATermsOldshares and TR.CATermsNewShares.

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hi @vishnu01 @vasu01 ,

    Regarding the information of how the split ratio is calculated and which field can be used to retrive the data you're interested, as the moderators
    on this forum are expertise on Refinitiv APIs usage. However, they do not have
    deep expertise in every type of content available through Refinitiv products.
    Such expertise is available through Refinitiv Helpdesk, which can be reached
    via MyRefinitiv. If the Helpdesk can show you how to retrieve it using =@TR formula in Eikon Excel, then the moderators on this
    forum can help you translate it into get_data method
    in Eikon Data API call

    Hope this helps
    and please let me know in case you have any further questions

Answers

  • jason.ramchandani01
    jason.ramchandani01
    @vasu01 Thanks for your question - apologies but I don't think you have pasted your code - its better for us if you copy and paste the code in rather than a screenshot. We are awaiting your code snippet.
  • vishnu01
    vishnu01

    Please check the codes

    1) for getting the total revenue

    df,err=ek.get_data (instruments=['FSTP.L','FRAS.L'],

    fields=['TR.TotalReveneue.periodenddata','TR.TotalRevenue.calcdate','TR.TotalRevenue'],

    parameters={'Period':'FS0','Frq':'FQ','SDate':'2015-01-01','EDate':'2023-08-29'}

    )

    display(df)


    2) for getting the new and old share prices

    df,err=ek.get_data(instruments=['AAPL.O','MSFT.O','RELI.NS','TCS.Ns'],

    fields=['TR.CATerrmsOldshares','TR.CATermsNewShares'])

    display(df)


    And also please provide the information about how the split ratio is calculated.

  • vasu01
    vasu01

    Please check the codes

    1) for getting the total revenue

    df,err=ek.get_data (instruments=['FSTP.L','FRAS.L'],

    fields=['TR.TotalReveneue.periodenddata','TR.TotalRevenue.calcdate','TR.TotalRevenue'],

    parameters={'Period':'FS0','Frq':'FQ','SDate':'2015-01-01','EDate':'2023-08-29'}

    )

    display(df)


    2) for getting the new and old share prices

    df,err=ek.get_data(instruments=['AAPL.O','MSFT.O','RELI.NS','TCS.Ns'],

    fields=['TR.CATerrmsOldshares','TR.CATermsNewShares'])

    display(df)


    And also please provide the information about how the split ratio is calculated.

Categories