Regarding the Refinitiv eikon API

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.

Find more posts tagged with

eikon-data-api

#content

#technology

Accepted answers

raksina.samasiri

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

All comments

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

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

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.

raksina.samasiri

Hi @vishnu01 @vasu01 ,

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

EXPLORE OUR SITES