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

what is the formula for average PE ratio for the past 5 year in excel API?

eikoneikon-data-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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
Accepted
18.2k 21 13 21

Hi @jeane.samson.refinitiv

Is this the data point you are interested in?

ahs1.png


ahs1.png (23.4 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.

Is this already average PE Ratio for the past 5 years? The only thing he was using though was RIC JSMR.JK. Perhaps, similar to this Eikon excel formula.

=TR("JSMR.JK","AVG(TR.PE)","Frq=D SDate=2016-01-01 EDate=2021-07-18 CH=Fd RH=IN")

Can you provide a formula similar to that Eikon excel formula? Thank you for your help.

Hi @jeane.samson.refinitiv

With the sample formula in Excel, it is much easier to provide sample code in Python, Thanks.


ahs1.png

ahs1.png (10.6 KiB)
Thank you for your input, I appreciate it
Upvotes

anyone who can help on this please?


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.