Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Jotun avatar image
3 ●0 ●2 ●5

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apipermid-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

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
80k ●257 ●52 ●75

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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