Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by phbas14 · Feb 15, 2019 at 07:31 AM · historical dataidanalyst

Historical analyst unique ID for list of RIC's

Dear developers,

Currently, I have been using the Eikon Excel add-in for all my data requests but have encountered an issue. My request is, that I have a list of RIC's, wherein I want to retrieve (on a year-by-year basis on a specific date) a list of the Unique Analyst ID's (number format) providing estimates for the given RIC. I have not been able to do this, all I can do is get the current unique ID's - but these do not change over time according to my code... I have used:

=TR(B1,"TR.AnalystUID","Sdate=2003-03-31 Period=NTM",B3)

I was wondering if anyone here knows how to do this? I would be more than willing to use a Python API, so any suggestions are welcoming!

adpro17

People who like this

1 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Feb 15, 2019 at 02:11 PM

@phbas14, @adpro17
I'm afraid the moderators on this forum wouldn't know the answer. This question is not specific to using Eikon Data APIs, it is about whether the workflow you're looking to build is possible given the data structure, availability and relationship. The moderators on this forum don't have that deep an expertise in this specific dataset to provide an authoritative response.
I advise you to contact Refinitiv Helpdesk by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application and ask for help with building the workflow you need in Excel. If it's not possible to build it in Excel, it's not possible through Eikon Data APIs either. If it is possible to build it in Excel and you prefer to implement it in Python, it's quite easy to move the implementation from Excel to Python script.

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
phbas14 · Feb 16, 2019 at 04:36 AM 0
Share

I am happy that you confirm that the data availability is the same in the Excel-add in as it is for any API. I was thinking the same.

My issue is that my University does not have support in its license, so students like myself are left to ourselves - which is why I wanted to post here.. But thank you for the advice, it's appreciated.

avatar image
Answer by adpro17 · Feb 15, 2019 at 01:10 PM

This is one of the problems I am facing too! Really would help if someone know this..

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

Why does ek.get_data sometimes return all NaN-values if certain columns included?

Exporting weather data to CSV

How to get the TR.PE at a historical date?

Historical option data, missing Close Prices & Too many requests

retrieve historical data with get_timeseries for JCI.N

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges