Hello, Please I have working to collect the historical data on ALL Cocos bonds . when I selected...

bashar

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

Alex Putkov.1

@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")

Jirapongse

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

bashar

https://community.developers.refinitiv.com/discussion/comment/53023#Comment_53023

@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