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

yunshan.chen.2024

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

raksina.samasiri

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.

description of the field can be found in description tab

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

yunshan.chen.2024

https://community.developers.refinitiv.com/discussion/comment/122714#Comment_122714

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=[ ]

raksina.samasiri

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.