The instrument issue when I fetch historical PE ratio of SPX constituents

ylian

I use the following statement to fetch historical PE ratios of SPX constituents.

rcc, err=ek.get_data("0#.SPX(2002-08-09)",fields=["TR.RIC","TR.InstrumentDescription", "TR.RIC.date"])

instruments=rcc['RIC'].tolist()

df,err=ek.get_data(instruments, ['TR.PE', ‘TR.PE.date'], {"SDate": "2002-08-09", "EDate":"2002-08-09"})

Below is the message from Spyder.

 File "C:\Users\xxx\Anaconda3\lib\site-packages\eikon\data_grid.py", line 189, in get_data
    result = eikon.json_requests.send_json_request(_endpoint, payload, debug=debug)

  File "C:\Users\xxx\Anaconda3\lib\site-packages\eikon\json_requests.py", line 127, in send_json_request
    _check_server_error(result)

  File "C:\Users\xxx\Anaconda3\lib\site-packages\eikon\json_requests.py", line 203, in _check_server_error
    raise EikonError(int(server_response['ErrorCode']), error_message)

EikonError: Error code 1422 | Can not process metadata for request: DataGrid_StandardAsync.requests.instruments - non-empty is required

(1) I manually create a subset of the "instruments" and run the get_data statement. And it works fine. But when I include the instrument with the 500 RICs, it reports errors.

(2) Some tickers do not return PE ratio, such as TNB.N^E12. Do you have any other alternative get PE ratio for this RIC?

Can you advise? Thank you.

chavalit-jintamalit

Hi @ylian

1. The instruments variable contains empty value. So it causes the error.

2. Please contact the Refinitiv Content Helpdesk at https://my.refinitiv.com/ to get help on the field you are interested in.

Or you can use Data Item Browser to explore what field may fit with your requirement.

Data Item Browser tutorial is here.

ylian

https://community.developers.refinitiv.com/discussion/comment/58230#Comment_58230

Hi @chavalit.jintamalit Thank you for your response. That is a typo when I manually typed it in the thread.The quote in my original code is correct. Please advise me how to solve this issue. I try the same code on DJI index, it works. But when try to fetch the data from SPX, it reports error message.

The data item browser I used is from the formula builder in Eikon excel plugin. The TR.PE works for most of the RICs except some of them, I show you one of the RIC I found that have missing PE value, TNB.N^E12. Please advise me this is a glitch of your database or not.

Yili

chavalit-jintamalit

https://community.developers.refinitiv.com/discussion/comment/58272#Comment_58272

Hi @ylian

For error in function call, it is because you pass in empty string.

Please try to code I show you so you understand that the instrument list contains an empty string.

For the TR.PE content clarification, please contact Refinitiv Content Helpdesk.

ylian

https://community.developers.refinitiv.com/discussion/comment/58269#Comment_58269

Hi @chavalit.jintamalit Thank you for your help. For the empty string, can you recommend a solution so that I can fetch the data for those non-empty RICs and finish my project. Yili

chavalit-jintamalit

https://community.developers.refinitiv.com/discussion/comment/58348#Comment_58348

Hi @ylian

From technical point of view, I think you can use the 'Instrument' column instead of the 'RIC' column.