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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Jotun avatar image
1 ●0 ●0 ●3

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-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpermid-apibonds
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.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
47.2k ●110 ●44 ●60

@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 512.0 KiB each and 1.0 MiB total.