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

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

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

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

Answers