Industry Median fields not working

Fields related to the median industry (found in Codecreator) are giving me error 414. Is it something related to these fields or what is the reason? Any alternative would be appreciated.

from refinitiv.data.content import fundamental_and_reference

fields = [

'TR.MedianIncAvailToComExclExordItemsMargPct',

'TR.MedianNetMargPct',

'TR.MedianGrossProfMarg',

'TR.MedianEBITDAMargPct',

'TR.MedianNetIntrMargTotPct',

'TR.MedianPretaxROEPct',

'TR.MedianIncTaxRatePct',

'TR.MedianEarnRetentionRate'

]

response = fundamental_and_reference.Definition(

universe = ['NVDA.O'],

fields = fields

).get_data()

data = response.data.df

Find more posts tagged with

python

equities

eikon-data-api

workspace-data-api

fundamental-data

#content

Accepted answers

Jirapongse

@alejandro.gonzalez

Thank you for reaching out to us.

It looks like to be a content question. The code works fine with other fields.

fields = [
   'TR.CommonName',
   'TR.PriceClose',
   'TR.MedianIncAvailToComExclExordItemsMargPct',
   'TR.MedianNetMargPct',
   'TR.MedianGrossProfMarg',
   'TR.MedianEBITDAMargPct',
   'TR.MedianNetIntrMargTotPct',
   'TR.MedianPretaxROEPct',
   'TR.MedianIncTaxRatePct',
   'TR.MedianEarnRetentionRate'
]
response = fundamental_and_reference.Definition(
   universe = ['NVDA.O'],
   fields = fields).get_data()

data = response.data.df
data

Please contact the helpdesk team directly via MyAccount to verify the data of those fields.

All comments

Jirapongse

@alejandro.gonzalez

Thank you for reaching out to us.

It looks like to be a content question. The code works fine with other fields.

fields = [
   'TR.CommonName',
   'TR.PriceClose',
   'TR.MedianIncAvailToComExclExordItemsMargPct',
   'TR.MedianNetMargPct',
   'TR.MedianGrossProfMarg',
   'TR.MedianEBITDAMargPct',
   'TR.MedianNetIntrMargTotPct',
   'TR.MedianPretaxROEPct',
   'TR.MedianIncTaxRatePct',
   'TR.MedianEarnRetentionRate'
]
response = fundamental_and_reference.Definition(
   universe = ['NVDA.O'],
   fields = fields).get_data()

data = response.data.df
data

Please contact the helpdesk team directly via MyAccount to verify the data of those fields.

grace.arquion

I am getting below error when using the above code.

--------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
/tmp/ipykernel_209/3472950077.py in <module>
     19 ]
     20 
---> 21 response = fundamental_and_reference.Definition(
     22 
     23 universe = ['NVDA.O'],

NameError: name 'fundamental_and_reference' is not defined

[ ]:

grace.arquion

Can you comment why using PFE we are getting the error

? @Jirapongse

NameError: name 'fundamental_and_reference' is not defined

alejandro.gonzalez

Grace, that name error is because you did not import the library
from refinitiv.data.content import fundamental_and_reference

So, the issue comes to the Content Team as @Jirapongse said. Something with those fields is not working as expected. I already contacted the help desk and would expect to receive a response in the next hours or so.

jonathan.legrand

Hi @grace.arquion , You will need to import the module:

from refinitiv.data.content import fundamental_and_reference

As per the examples:

Example.DataLibrary.Python/Examples/2-Content/2.09-FundamentalAndReference/EX-2.09.01-FundamentalAndReference.ipynb at main · LSEG-API-Samples/Example.DataLibrary.Python (github.com)

EXPLORE OUR SITES