Industry Median fields not working

Question

question

alejandro.gonzalez

1 ●0 ●0 ●1

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

eikon-data-api python workspace-data-api #content equities fundamental-data

Jul 02 at 09:28 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2024-07-03T03:37:30Z

Jirapongse

84.6k ●287 ●53 ●77

@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.

1719977791405.png (12.7 KiB)

Jul 03 at 03:37 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2024-07-03T16:12:16Z

grace.arquion

1 ●0 ●0 ●0

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

[ ]:

Jul 03 at 04:12 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jonathan.legrand Jul 10 at 12:37 PM

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)

Answer 3 · 2024-07-03T16:22:07Z

grace.arquion

1 ●0 ●0 ●0

Can you comment why using PFE we are getting the error

? @Jirapongse

NameError: name 'fundamental_and_reference' is not defined

Jul 03 at 04:22 PM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

alejandro.gonzalez Jul 03 at 05:49 PM

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.

Q&A Forum

question

Industry Median fields not working

3 Answers

Write an Answer

question

Industry Median fields not working

3 Answers

Write an Answer

Related Questions