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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

12 month Forward PE parameter code, to apply on national indexes

Hello


I am constructing the forward PE ratios for a number of countries, using the national index of a given country.

For example for USA i would use .spx as the ticker for US national index.

My question is what parameter would i need to use in order to get the 12 month forward pe for spx ?

for example df=eg.gettimeseries(.....) could you please give an example for US , spx index? i will apply the same methodology to get the forward PE ratio of other countries' indexes.


Thank you

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikontime-series
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.

Upvotes
Accepted
6.7k 8 6 7

@juliusz.pres you can try this :

df,err = ek.get_data([".SPX",".GDAXI",".FTSE"], ["TR.Index_PE_RTRS.date","TR.Index_PE_RTRS","TR.Index_EST_PE_Y1_RTRS","TR.Index_EST_PE_Y2_RTRS"],parameters={'SDate':'-100D','EDate':'1D'})

df

I have put in current, FY1 and FY2 forward PER fields. I hope this can help.


1621881062115.png (139.3 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.

Upvotes
1 0 0 1

Thanks a lot Jason. This seems quite helpful indeed. In general what is the easiest way to find the exact parameter that we want for our time series? I know TR. is a helper function and then you add the specific parameter that you want. Is there a specific documentation that we can filter with a keyword (e.g "Forward PE"), and get the specific parameter name that you kindly posted below?

TR.Index_EST_PE_Y1_RTRS


Thank you for your help

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.

@juliusz.pres My pleasure! So the best way to get to know our data model is to play around with the Data Item Browser app (type DIB into Eikon search bar). This can give you all the fields available from different content categories. Very importantly it gives field descriptions and perhaps even more importantly field parameters you can select. If you add an instrument at the top the tool will also give you values which is great for zeroing in on exactly what you need.

We also have a fully automated code creator application that can fully create the python code for a query you select visually (type CODECR into Eikon search bar).

I hope this can help.

1621928017517.png (507.2 KiB)
1621928191172.png (252.5 KiB)
Click below to post an Idea Post Idea