I am trying to get information on bond issuance between a certain data range (including the amount and the the currency of issue) for a set of RIC codes. I am having a little bit of a trouble building the appropriate formula on excel. Thanks!
Hi @sanhitha.jugulum
And this is sample code:
HI @sanhitha.jugulum
If you can please share your attempt(s) so far, what trouble you are having and also some sample RICS that you are using this may help us. Thanks.
Hi Umer,
Sorry for the late reply! I couldn't figure out how to incorporate the formula that a representative from EIKON had sent across.
I am essentially having a problem figuring out the screener/Rsearch criterion to get all the list of all the bonds issued by a company (whose RIC code I have). Here is the excel function:
=TR($A$5:$A$2000,"TR.FiDebtTypeDescription;TR.FiIssueDate;TR.FiMaturityDate;TR.FiCurrency","CH=FD NULL=BLANK").
The bold part should be a screener/Rsearch sort of an expression I am guessing. I am also attaching the screeshot of the search criteria I use when extract this data manually.
The sample RIC code I am using is SVW.AX!
Thanks for the response! This is great but I need help with creating a line of code to retrieve the list of bond RICs (list ric in your code) using the company RIC /ticker. How can I do that?
If you could help me with that, that would be very much appreciated!
