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

jeane.samson.refinitiv

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

chavalit-jintamalit

Hi @jeane.samson.refinitiv

Is this the data point you are interested in?

jeane.samson.refinitiv

anyone who can help on this please?

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

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

jeane.samson.refinitiv

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

chavalit-jintamalit

Hi @jeane.samson.refinitiv

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

jeane.samson.refinitiv

Thank you for your input, I appreciate it