New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
yunshan.chen.2024 avatar image
1 ●0 ●0 ●0

How can I add date to get_data() when I want to to pull NumEstRevisingUp and NumEstRevisingDown

Here is the code I did to pull but there is only one date:


import refinitiv.data as rd

rd.open_session()

df = rd.get_data(

universe = ['ABI.BR'],

fields = [

'TR.NumEstRevisingUp',

'TR.NumEstRevisingDown',

'TR.PriceClose.date'

],

parameters={

# 'Curn': 'CAD',

# 'Frq': "1D"

'SDate': '-5', # "2023-11-01",

'EDate': '0', # "2023-12-11",

})



InstrumentNumber of Analysts Revising UpNumber of Analysts Revising DownDate0ABI.BR952024-10-251ABI.BR<NA><NA>2024-10-282ABI.BR<NA><NA>2024-10-293ABI.BR<NA><NA>2024-10-304ABI.BR<NA><NA>2024-10-315ABI.BR<NA><NA>2024-11-01

pythonworkspacerefinitiv-dataplatform-eikon#technologylseg-data-library
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.

2 Answers

· Write an Answer
Upvote
raksina.samasiri avatar image
15.6k ●33 ●5 ●10

Hi @yunshan.chen.2024 ,

Checking with Code Creator application in the Workspace, output date of fields TR.NumEstRevisingUp and TR.NumEstRevisingDown are not available. However, you can adjust other parameters such as Financial Period, Window Period, Methodology to retrieve other results.
1730704424441.png

description of the field can be found in description tab

1730705363610.png

The moderators on this forum are expertise on Refinitiv APIs usage. However, they do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through Refinitiv Helpdesk, which can be reached via MyAccount and the support team is going to contact you soon to assist with this.


Hope this helps and please let me know in case you have any further questions


1730704424441.png (195.8 KiB)
1730705363610.png (43.1 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.

yunshan.chen.2024 avatar image yunshan.chen.2024

Thank you very much! It is weird that it does not have the 'date' parameters but when I change the start date in parameters=[ ], it will only show the earliest date in parameters=[ ]


Upvotes
raksina.samasiri avatar image
15.6k ●33 ●5 ●10

Hi @yunshan.chen.2024 ,

I can reproduce what you have face too (as the data is changed based on the start date provided in parameters but the date output isn't available for the field)

You may raise ticket via MyAccount with the link provided above to query about content such as, more detail of each field.

Hope this helps and please let me know in case you have any further questions.

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.