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
1
●3 ●3 ●3
what is the formula for average PE ratio for the past 5 year in excel API?
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
18.2k
●21 ●13 ●21
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.
With the sample formula in Excel, it is much easier to provide sample code in Python, Thanks.
