Fetching Underwriters with Valuation Date and PermID for a Bond

Question

Question by Jotun · Dec 11, 2019 at 12:16 PM · permid bonds eikonexcel underwriter valuation 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. :-)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-12-17T09:02:49Z

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.

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Fetching Underwriters with Valuation Date and PermID for a Bond

1 Reply

Watch this question

Related Questions