For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

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. :-)

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonpermid-apibonds
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
38.1k 71 35 53

@Jotun

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

icon clock
10 |1500

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

Click below to post an Idea Post Idea