For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
jeane.samson.refinitiv avatar image
1 ●1 ●0 ●0

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikon
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

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 5.0 MiB each and 10.0 MiB total.

jeane.samson.refinitiv avatar image jeane.samson.refinitiv

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")

jeane.samson.refinitiv avatar image jeane.samson.refinitiv

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

chavalit-jintamalit avatar image chavalit-jintamalit jeane.samson.refinitiv

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)
jeane.samson.refinitiv avatar image jeane.samson.refinitiv chavalit-jintamalit
Thank you for your input, I appreciate it
Upvotes
jeane.samson.refinitiv avatar image
1 ●1 ●0 ●0

anyone who can help on this please?


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea