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 Jotun · Dec 11, 2019 at 12:16 PM · permidbondseikonexcelunderwritervaluation date

Fetching Underwriters with Valuation Date and PermID for a Bond

I wrote a little TR-Formula that is supposed to fetch me the underwriters for a given bond with ISIN:

=TR(ISINs!$B$2:ISINs!$B$15000,"TR.UnderwriterRankDescription;TR.UnderwriterRank;TR.Underwriter;TR.UnderwriterCode;TR.FiIssueDate","CH=Fd RH=IN CODE=ISIN",B1)

Works fine so far. But I would also like to get the valuation date and PermIDs for each underwriter. Unfortunately, I could'nt find the corresponding Data Item with the Formula-Builder so far. Bloomberg had those values, so I expect it can be found somehow with Reuters, too.

Maybe somebody here can quickly help me out with this one. :-)

People who like this

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · Dec 17, 2019 at 09:02 AM

@Jotun

For this question, please directly contact the Eikon Excel support team via MyRefinitiv for the TR formular to get the required fields.

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 >
9 People are following this question.

Related Questions

permID with TRBC codes and Index RIC

When will bond search with Python be available in Eikon DAPI?

=TR(RIC; "BID) leads to "The record could not be found"

How can I get access to RSearch Library? And will it help me to access Bond RICs based on criterias?

How to get the same CSV data as the sample file of the book?

  • 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