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

question

Upvotes
Accepted
1 1 4 9

Price Target data retruning from rd.get_data when data exists in DIB

hello, for many symbols, for one example, CUSIP 094235108


DIB shows data for:

'TR.PriceTargetMedian',

'TR.PriceTargetMean',

'TR.PriceTargetNumIncEstimates',


but when i pull the data with rd.get_data in python, all three return <NA>.


is there a difference in pulling via CUSIP as i do in rd.get_data vs how Eikon converts the cusip to a RIC before opening DIB? why is this happening?

python#technologyrefinitiv-data-platformrefinitiv-data-libraries
icon clock
10 |1500

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

Upvotes
Accepted
5.8k 18 2 7

@mjg ,

Sorry for the delay in the answer. Regarding the values that doesn't seem right I would definitely suggest raising a content query via my.refinitiv.com or Help&Support section in Workspace as what I understood your issue is related to the content itself. So please raise with the content team and they will bring a specialist who can answer to that question better.


Best regards,

Haykaz

icon clock
10 |1500

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

Upvotes
5.8k 18 2 7

Hi @mjg ,


Just checked for the example you have provided and I get the data:

rd.get_data(universe = '094235108', fields = ['TR.PriceTargetMedian','TR.PriceTargetMean','TR.PriceTargetNumIncEstimates'])

screenshot-2024-05-03-at-151314.png

Can you share the code you are using so we have a look what might be wrong?


Best regards,

Haykaz


icon clock
10 |1500

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

Upvotes
1 1 4 9

if i only ask for that one CUSIP, i get the data back too. my rd call asks for these fields for about 5592 cusips. would the length of my cusip list or the length of my field list matter?


df = rd.get_data(

universe=cusips,

fields=['TR.CompanyMarketCapitalization',

'TR.PE',

'TR.PriceToSalesPerShare',

'TR.GICSIndustry',

'TR.GICSSubIndustry',

'TR.SICIndustryGroup',

'TR.TotalDebtOutstanding',

'TR.ShortInterestPct',

'TR.CompanyName',

'TR.F.CashSTInvst',

'TR.PriceTargetMedian',

'TR.PriceTargetMean',

'TR.PriceTargetNumIncEstimates',

'TR.RevenueSmartEstF12MtoT12MGrowth',

'TR.EpsRepSmartEstF12MtoT12MGrowth',

'TR.PriceToBVPerShare',

'TR.FwdPEG'

]

)

icon clock
10 |1500

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

Upvotes
5.8k 18 2 7

Hi @mjg ,


It would be hard for me to see what is the issue without being able to reproduce it on my end, however there shouldn't be any data difference issue depending on the number of universes in the request.

Nevertheless, we do advice users to divide large identifier lists into smaller chunks do avoid API response errors.


Best regards,

Haykaz

icon clock
10 |1500

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

Upvotes
1 1 4 9

okay, so, when i use chunks of 500 the data comes back - but how do you explain these errant results.


for cusip G3643J108


Price Target - Median 19300

this does not match DIB, what's going on here?


my concern is now morphing into a concern about why i wasn't getting errors in the first place, and now why i am getting bad data =X


thanks for your prompt responses


icon clock
10 |1500

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

Upvotes
5.8k 18 2 7

Hi @mjg ,


I quickly checked the price target mean for G3643J108 and it does show 19300 on my end which matches the API output (with single cusip).

screenshot-2024-05-03-at-175116.png

As for not getting data, that might be because of API Limitations, please check it here and note that same limits for Eikon Library apply to RD as well: https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/documentation

For example, get_data returns 10,000 datapoints max, which exceeds in your situation of 5592 RICs with 17 fields.


Best regards,

Haykaz


icon clock
10 |1500

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

Upvotes
1 1 4 9

FLUT is trading $195.80 - 19,300 is just insane and wrong -


.... and the median target price is $246 - even in DIB

1714759906083.png


1714759906083.png (419.0 KiB)
icon clock
10 |1500

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

Upvotes
1 1 4 9

are you looking at FLTRF.L instead?

isn't the CUSIP supposed to 'solve for that' issue? that is why i am using the cusip, to try to lock down on the exact security (the u.s. security ...) G3643J108 which is FLUT

icon clock
10 |1500

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

Upvotes
1 1 4 9

well, thanks for solving this:

For example, get_data returns 10,000 datapoints max, which exceeds in your situation of 5592 RICs with 17 fields.

---

it seems like for the cusip/symbology stuff, that's another issue that merits its own investigation either/both on my side and on the api...


icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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