1
●0 ●0 ●2
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
Hello @Alex Putkov. @chavalit.jintamalit, @jirapongse.phuriphanvichai
Could you help to look up to this question?
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 
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
39.4k
●77 ●11 ●27
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")
