question

Upvotes
Accepted
1 0 0 1

Hello, Please I have working to collect the historical data on ALL Cocos bonds . when I selected the Data items and pressed layouts . The program gave me the unable to collect the data ! any advises to work with that . many Thanks

eikoneikon-com-api
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.

@bashar

Could you please provide the screenshot of the application or the snippet code that you are using?

Then, we can refer the question to the correct team or verify the code.

@jirapongse.phuriphanvichai thanks a lot for your reply. I have been working to collect data about CoCos information in different years. But give me invalid something like that. Thanks

cocos.jpeg (238.0 KiB)

1 Answer

Upvotes
Accepted
39.3k 77 11 27

@bashar

You're using incorrect chain RIC. Try "0#ALLCOCO=" instead of "33#ALLCOCO=".

And if you're looking to use RHistory function to retrieve price, yield, spreads etc history for Coco bonds, then you cannot use the chain RIC in RHistory function. You need to retrieve the constituents of the chain first using =TR("0#ALLCOCO=") and then for each constituent you can retrieve say yield history using for example =RHistory("DE114071919=","YLDTOMAT.Timestamp;YLDTOMAT.Close;YLDTOMAT.Value","INTERVAL:1D")

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.