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
vasu01 avatar image
1 ●0 ●0 ●0

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.

eikon-data-api#technology#content
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.

jason.ramchandani01 avatar image 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.
vasu01 avatar image vasu01 jason.ramchandani01

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.

2 Answers

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.4k ●30 ●5 ●10

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

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
vishnu01 avatar image
3 ●0 ●3 ●8

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.

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.

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.